Data Specialist #1999032

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

Job Location:

• The office for this position is located at 3315 W. Truman Blvd., Jefferson City, MO 65109.

Why You'll Love This Position

Do you enjoy working with collaborative teams? Are you looking for a position that will allow you to work on a variety of projects? If so, for the Data Specialist position within the Office of Administration, Information Technology Services Division (OA-ITSD) supporting the Department of Elementary and Secondary Education (DESE) and the Department of Higher Education and Workforce Development (DHEWD).

• Authorization to work in the United States is a prerequisite of employment. The Office of Administration, Information Technology Services Division (ITSD) will not sponsor applicants for work visas.
• The salary indicated represents a base pay rate. If the individual selected or the position is eligible for a pay differential (e.g., shift, security, or years of service), it will be added to the total compensation in your paycheck. A pay differential does not raise your base pay.

This position is with the Office of Administration, Information Technology Services Division (OA-ITSD) supporting Department of Elementary and Secondary Education (DESE) and the Department of Higher Education and Workforce Development (DHEWD).

ITSD Core Values - We Innovate and Partner with Passion, Respect, and Integrity United as #OneTeam.

• 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.
• Effectively prioritize and execute tasks in a fast-paced environment using Agile methodology.
• Support the integration of enterprise application databases and real time processing into the data warehouse.
• Create, adhere to, and enforce technical standards.
• Experience with SQL Server and SQL Server query performance tuning.
• Ability to design databases including relationships, indexes, views, tables, and fields.
• Familiar with Azure DevOps and Agile development concepts.
• Strong data investigation and problem-solving skills.
• Knowledge of SQL Server data warehousing, data architecture, design concepts with practical experience in the implementation of these concepts, and cloud technologies.
• Be self-motivated and have the desire to continually develop new skills and improve existing skills.
• Strong written and verbal communication skills and organizational skills.
• Successful background check results are required for employment in this position. This may include background checks involving a candidate's name and/or fingerprints and other screenings as needed for the specific position.

Lack of post-secondary education will not be used as the sole basis denying consideration to any applicant. This position is a critical position for the database environment support and modernization of the database environments. In addition, this position will help the team implement improvements and put in place more efficiencies to make DESE State and Federal Reporting easier through the use of AWS and CEDS and other modernization steps.

The classification for this position is Data Specialist: click for more information.

The State of Missouri offers an excellent benefits package that includes a defined pension plan, generous amounts of leave and holiday time, and eligibility for health insurance coverage. Your total compensation is more than the dollars you receive in your paycheck. To help demonstrate the value of working for the State of Missouri, we have created an interactive Total Compensation Calculator. This tool provides a comprehensive view of benefits and more that are offered to prospective employees. The Total Compensation Calculator and other applicant resources can be found here.

If you have questions please contact:

[e-mail]