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

$10,598 - $94,560/Yr

State of Washington - Olympia, WA

Full-time - Senior

Olympia, WA

Executive, Legislative, and Other General Government Support

About the position

The Senior Data Warehouse SQL Developer/Supervisor is responsible for designing, developing, and maintaining the Agency's enterprise DataMart data warehouse and its associated processes. This role involves integrating data from various sources to create an analytical data warehouse, ensuring compliance with IT best practices, and supervising the DataMart team to enhance the existing infrastructure with modern technologies.

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.
• Support the Agency's MS SQL Server database management systems to ensure smooth operation, security, and performance.
• Head the development and maintenance of data warehouse standards, processes, and policies, ensuring alignment with IT best practices 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.
• Oversee activities and direct employees of the DataMart team, assigning tasks and providing feedback.

Requirements

• Bachelor of Science in computer science, information systems, or related field.
• Seven years of experience with Oracle database and/or MS SQL Server database.
• SQL (PL/SQL or T-SQL) programming experience.
• Troubleshooting technical issues and providing support on data warehouse.
• Scripting/coding experience (e.g. Python, C#).
• Experience with enterprise batch scheduling software (e.g. Application Manager).
• Knowledge and experience in all systems development life cycle (SDLC) stages.
• Experience with data warehousing best practices and methodologies.
• Experience with data modeling and database design principles.
• Experience with ETL tools, such as Automic Applications Manager, Informatica, SSIS, or similar software products.
• Commitment to fostering an environment that honors diversity, equity, inclusion, and environmental justice practices.
• Excellent problem-solving and analytical skills.
• Strong communication, collaboration, and presentation skills.