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

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

(See official listing for full details.)

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.

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.

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
  • Troubleshooting all types 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.