Senior Data Warehouse SQL Developer/Supervisor (Data Management - Senior/Specialist)

Salary : $94,560.00 - $127,176.00 Annually
Location : Thurston County - Olympia, WA
Job Type: Full Time - Permanent
Remote Employment: Flexible/Hybrid
Job Number: 2024-10-A298-11262
Department: Dept. of Natural Resources
Opening Date: 10/04/2024
Closing Date: 10/30/2024 11:59 PM Pacific
Salary Information: The high end of the salary range, Step M is typically a longevity step
Description
Senior Data Warehouse SQL Developer/Supervisor (Data Management - Senior/Specialist) Recruitment #2024-10-A298
Full-time, Permanent, Represented position
Location: Natural Resources Building- Olympia, WA
Work Hours and Partial Telework flexibility may be available and considered
Salary: $7,880.00 - $10,598.00 Monthly
This position has an additional 5% supervisor premium added to the monthly base salary. The salary listed in the announcement reflects the additional 5%.
Review of applications is ongoing. We reserve the right to make a hiring decision or close this recruitment at any time after 10/16/24. It is in your best interest to submit materials as soon as possible.
Want to join something GREAT and make a difference?
The Department of Natural Resources (DNR) has an exciting opportunity within our IT Division. This senior-level professional position is the highest-level authority of DNR's enterprise Data Warehouse database and its associated Extract, Transform, Load (ETL)/Extract, Load, and transform (ELT) processes. This position will serve as the Agency enterprise Data Warehouse Specialist/Supervisor, using advanced data warehouse, programming, data architecture, and system design skills to maintain and enhance DNR's enterprise DataMart system.
This position extracts data from multiple data sources (including applications and transactional databases), transforms that data, and loads it into the DataMart Oracle database for Agency users to analyze the Agency's financial engineering, and forestry data. This analytical data is key for Agency users, Managers, decision-makers, and internal and external customers to analyze DNR data and make operational and strategic business decisions.
Duties
Responsibilities:

• Design, develop, support, enhance, and maintain the Agency enterprise DataMart data warehouse/database and its related automated Extract, Load, and Transform (ELT) processes. Integrate data from multiple source systems and databases to create an analytical data warehouse (in Oracle) serving users across the Agency. Design, develop, test, deploy, document, troubleshoot, and maintain this suite of component modules that contribute to the full DataMart/data warehouse integration process.
• Support the Agency's MS SQL Server database management systems that provide the back-end to several business Commercial-off-the-Shelf (COTS) systems to ensure smooth operation, security, and performance.
• Head the development and maintenance of data warehouse standards, processes, and policies, ensuring that they are aligned with IT best practices and methodologies and OCIO policies. Promote DNR-wide compliance among other IT professionals across the Agency
• Modernize and enhance the existing data warehouse (enterprise DataMart) and its infrastructure, incorporating the latest data warehouse/analytics platforms and technologies.
• Supervision - This position will oversee activities and direct employees of the DataMart team. Is responsible for assigning tasks, making, or changing work assignments providing feedback completing annual performance evaluations, and updating ITPDs.

Qualifications
Required Qualifications:

• Bachelor of Science in computer science, information systems, or related field AND seven years of experience in the following areas:
  • Oracle database and/or MS SQL Server database
  • SQL (PL/SQL or T-SQL) programming experience
  • Trouble shooting all type of technical issues and providing support on data warehouse
  • Scripting/coding experience (e.g. Python, C#)
  • Enterprise batch scheduling software (e.g. Application Manager)
  • Knowledge and experience in all systems development life cycle (SDLC) stages
    OR an equivalent combination and education and/or experience

Experience with data warehousing best practices and methodologies.

Experience with data modeling and database design principles.

Experience with ETL (Extract Transform Load) tools, such as Automic Applications Manager, Informatica, SSIS (SQL Server Integration Services), or similar software products.

Commitment to fostering and supporting an environment that honors diversity, equity, inclusion, and environmental justice practices.

Perform assigned duties in a manner consistent with applicable laws, regulations and public records retention and requests are followed.

Excellent problem-solving and analytical skills.

Strong communication, collaboration, and presentation skills.

ITD Competency Clusters:

• Communication
• Conflict Management
• Interpersonal skills
• Change Leadership
• Analytical thinking
• Customer focus
• Decision Making
• Planning & Organizing
• Thoroughness
• Fostering Diversity
• Team Participation
• Personal Credibility, Ethics and Integrity

DNR Core Competencies:

• Personal Accountability
• Value Others
• Compassionate Communication
• Inspire Others
• Commitment to Excellence

Special Requirements and Conditions of Employment:

• Typical office setting. Desktop, cubicle arrangement. Hybrid in-office and remote work.
• Occasionally, as needed.

Desired Qualifications:

• Experience with Business Intelligence tools, such as Microsoft Power BI, Tableau, or similar software.
• Experience with cloud technologies, such as Microsoft Azure.
• Experience with Agile methodologies.

Don't let doubts stop you from applying for this position - If you have any questions about the required qualifications or how your past experience relates to them, please contact us at A note to potential candidates: Studies have shown that women, trans, non-binary, Black, Indigenous, and people of color (BIPOC) are less likely to apply for jobs unless they feel they meet every qualification as described in a job description. We value diversity and inclusion in our organization, and we are looking for the best person for the job. Don't hesitate to apply!
Supplemental Information
Application Requirements:

• Apply online: at (Click on the APPLY button above).
• Letter of interest: describing your specific qualifications to the position and position required, desired, and special requirements.
• Resume: that details your experience and qualifications.
• References: at least three professional references with current telephone numbers- you may attach a document, use the References text field in the online application, or include it with your resume.
• Important: Do not attach any documents that include photos or private information (social security number, year of birth, etc.).
• Complete all supplemental questions.
• Candidates who move forward in the recruitment process may be contacted via email at with interview information/scheduling instructions. Please monitor the email listed in your application materials and check your junk email folder to ensure you receive those communications.

Questions? Please contact Michiko Quach at or e-mail us at
Persons needing accommodation in the application/testing process or this job announcement in an alternative format may call (360) 522-2500 or email Applicants who are deaf or hard of hearing may call through the by dialing 7-1-1 or 1-800-833-6384.
About the Department of Natural Resources (DNR).
At DNR we approach our work through the lens of making Washington a better place environmentally and are dedicated to serving Washington's lands and communities through diversity, equity, and inclusion.
Our Vision - Our actions ensure a future where Washington's lands, waters, and communities thrive.
Our Mission - Manage, sustain, and protect the health and productivity of Washington's lands and waters to meet the needs of present and future generations.
Our Core Values:

• Safety and Well-Being -Our top priority is the safety of the public and our employees.
• Public Service -We value and respect the public we serve, and we value and respect the people of the Department of Natural Resources who step up to serve.
• Innovation and Creative Problem-Solving - We solve our state's most pressing challenges through innovative thinking, dedication, and bold and creative vision.
• Leadership and Teamwork -We are committed to building leaders at all levels and building teams for success.

DNR provides excellent benefits, a few of which include:

• Commitment to organizational health and wellness
• Work/life balance
• DNR Employee Resource Groups (Diversity, Equity and Inclusion Council, Women's Employee Resource Group, Veterans Employee Resource Group, etc.)
• Statewide Employee Business Resource Groups,
• Leadership that empowers and supports employees
• Professional development opportunities
• Educational and career development aid
• Public Service Loan Forgiveness Eligibility
• Opportunities to participate in wildland fire suppression assignments
• A comprehensive benefits package that includes employer contributions toward health insurance, paid holidays, retirement plans, sick leave, and vacation days. Visit for more information.

Additional Information:
This recruitment may be extended and may also be used to fill future similar vacancies for up to sixty (60) days.
DNR does not use the E-Verify system. For more information, please visit
Veterans wishing to claim Veteran's preference please attach a copy of your DD-214, NGB-22, or other verification of military service. Please black out your social security number prior to attaching it. We thank you and are grateful for your service!
Equal Opportunity Employer:The Washington State Department of Natural Resources is an equal opportunity employer. We strive to create a working environment that includes and respects cultural, racial, ethnic, sexual orientation, and gender identity diversity. Women, racial and ethnic minorities, persons of disability, persons over 40 years of age, veterans, military spouses or people with military status, and people of all sexual orientations and gender identities are encouraged to apply.
Once you submit your online application, you can check your status by logging into your account. If you experience technical difficulties creating, accessing or completing your application call NEOGOV toll-free at (855) 524-5627 or email
Check us out on: | | | | |
More than Just a Paycheck!
Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation.
We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.
Read about our benefits:
The following information describes typical benefits available for full-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full-time work (e.g. part-time); view the job posting for benefits details for job types other than full-time.
Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits.
Insurance Benefits
Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state.
Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses. Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.
To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs.
Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.
Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.
The Washington State Employee Assistance Program promotes the health and well-being of employees.
Retirement and Deferred Compensation
State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.
Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre-tax salary dollars you defer as well as the flexibility to choose between multiple investment options.
Social Security
All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system.
Public Service Loan Forgiveness
If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.
Holidays
Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.
Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information.
Full-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday.
Part-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro-rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full-time employment, excluding all holiday hours. Pay status includes hours worked and time on paid leave.
Sick Leave
Full-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for less than 80 hours per month, earn a monthly proportionate to the number of hours in pay status, in the month to that required for full-time employment. Overtime exempt employees who are in pay status for less than 80 hours per month do not earn a monthly accrual of sick leave.
Sick leave accruals for part-time employees will be proportionate to the number of hours in pay status, in the month to that required for full-time employment. Pay status includes hours worked, time on paid leave and paid holiday.
Vacation (Annual Leave)
Full-time employees accrue vacation leave at the rates specified in (1) or the applicable collective bargaining agreement (CBA). Full-time employees who are in pay status for less than 80 nonovertime hours in a month do not earn a monthly accrual of vacation leave.
Part-time employees accrue vacation leave hours in accordance with (1) or the applicable collective bargaining agreement (CBA) on a pro rata basis. Vacation leave accrual will be proportionate to the number of hours in pay status, in the month to that required for full-time employment.
Pay status includes hours worked, time on paid leave and paid holiday.
As provided in , an employer may authorize a lump-sum accrual of vacation leave or accelerate the vacation leave accrual rate to support the recruitment and/or retention of a candidate or employee for a Washington Management Service position. Vacation leave accrual rates may only be accelerated using the rates established WAC 357-31-165.
Note: Most agencies follow the civil service rules covering leave and holidays for exempt employees even though there is no requirement for them to do so. However, agencies are required to adhere to the applicable RCWs pertaining holidays and leave.
Military Leave
Washington State supports members of the armed forces with 21 days paid military leave per year.
Bereavement Leave
Most employees whose family member or household member dies, are entitled to three (3) days of paid bereavement leave. In addition, the employer may approve other available leave types for the purpose of bereavement leave.
Additional Leave
Leave Sharing
Family and Medical Leave Act (FMLA)
Leave Without Pay
Please visit the State HR Website for more detailed information regarding benefits.
Updated 12-31-2022
01
Please describe what interests you about the Department of Natural Resources.
02
Please describe what a work environment based on diversity, equity, inclusivity and belonging means to you.
03
Please describe how you have designed and implemented a data warehouse so that it is easily maintained, enhanced, and supported for the long-term. If you do not have this experience type N/A.
04
Do you have a Bachelor of Science in computer science, information systems, or related field AND seven years of experience in the following areas: Oracle database and/or MS SQL Server database AND SQL (PL/SQL or T-SQL) programming experience AND Trouble shooting all type of technical issues and providing support on data warehouse AND Scripting/coding experience (e.g. Python, C#) AND Enterprise batch scheduling software (e.g. Application Manager) AND Knowledge and experience in all systems development life cycle (SDLC) stages OR an equivalent combination and education and/or experience?

• Yes
• No

05
Do you have experience with data warehousing best practices and methodologies?

• Yes
• No

06
Do you have experience with data modeling and database design principles?

• Yes
• No

07
Do you have experience with ETL (Extract Transform Load) tools, such as Automic Applications Manager, Informatica, SSIS (SQL Server Integration Services), or similar software products?

• Yes
• No

08
Do you now, or will you in the future, require sponsorship for employment visa status (e.g., H-1B visa status, etc.) to work legally for our agency in the United States? DNR is not an E-Verify agency.

• Yes
• No
• Unsure

09
Where did you originally hear about this job posting?

• WA WorkSource office or WorkSourceWA.com
• Governmentjobs.com
• Monster
• Indeed
• LinkedIn
• Twitter
• College/university website/career fair
• Handshake
• Newspaper
• Direct Email Notification
• Statewide Employee Business Resource Groups (BRG)
• Professional/Personal Network
• Job Board
• Job Fair
• Zip Recruiter
• Diversity Jobs
• Facebook
• Other (please specify below)

10
If you answered "other" to the previous question, please specify where you originally learned of this employment opportunity in the space below.
Required Question