Data Specialist: ETL, SQL & Cloud Data Warehouse

State of Missouri; Missouri; On-site; USD 60,000 - 90,000; Full time

Job summary

The State of Missouri is seeking a Data Specialist within the Office of Administration, ITSD, to develop and maintain ETL processes, support SQL Server procedures, and improve data warehousing capabilities. The role emphasizes collaboration, Agile delivery, and modernizing database environments.

You will work on integration of enterprise databases, real-time processing, and cloud technologies, contributing to DESE and DHEWD data initiatives with strong problem-solving and communication skills.

Qualifications

• Develop and maintain ETL processes using Microsoft SSIS and SQL agent jobs.
• Support complex stored procedures and custom functions.
• Analyze, solve, and correct production issues and provide documentation.
• Prioritize and execute tasks in a fast-paced environment using Agile methodology.
• Support integration of enterprise databases and real-time processing into the data warehouse.

Responsibilities

• Develop and maintain ETL processes using SSIS and SQL agent.
• Support complex stored procedures and functions.
• Analyze and resolve production issues with documentation.
• Work in Agile environment to prioritize tasks.
• Support integration of enterprise databases and real-time data into the warehouse.
• Create and enforce technical standards for data systems.

Skills

ETL development

SQL Server

Agile methodology

Data warehousing concepts

Problem solving

Analytical skills

Communication skills

Tools

SSIS

SQL Agent

Azure DevOps

SQL Server

Job description

The State of Missouri is seeking a Data Specialist within the Office of Administration, ITSD, to develop and maintain ETL processes, support SQL Server procedures, and improve data warehousing capabilities. The role emphasizes collaboration, Agile delivery, and modernizing database environments.

You will work on integration of enterprise databases, real-time processing, and cloud technologies, contributing to DESE and DHEWD data initiatives with strong problem-solving and communication skills.