Data Specialist

Job Location:

• The office for this position is located at the Roberts Building 1706 E. Elm St., Jefferson City, MO. 65101.

Why you’ll love this position:

Are you looking for a position that will allow you to work with a team of dedicated IT professionals? Are you interested in being a key player in a partnership between ITSD and DMH? If so, this position might be for you!

ITSD-DMH has an opening for a Data Specialist. In this position, you will have the opportunity to develop complex SSIS packages and SQL agent jobs that make data available to users of our data warehouse and applications and assist users with their own data queries as a member of an agile, well organized team. You will also have the opportunity to design databases, performance tune applications and assist with migration to the cloud while you grow your skill set in a positive environment. You will have the chance to deliver meaningful impact supporting DMH and the citizens of Missouri.

This position is with the Office of Administration, Information Technology Services Division (OA-ITSD) supporting the Department of Mental Health (DMH).

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.
• Develop and maintain reports using Microsoft SSIS, Tableau, or other reporting software supported by DMH.
• Develop and support complex stored procedures and custom functions.
• Analyze, solve, and correct production issues and provide documentation.
• Communicate with business users to establish database, SSIS, and SSRS package requirements.
• Effectively prioritize and execute tasks in a high-pressure environment using Agile methodology.
• Analyze, design, develop, peer review, test and implement code for projects.
• Create, adhere to and enforce technical standards.
• Design databases needed for applications, warehousing or reporting solutions.
• Performance tune stored procedures and queries.

The ideal candidate will have the following technical and soft skills:

• 5-8 years of information technology experience with emphasis in data management, data integration, or data reporting required
  
  SQL Server 2019/2022 preferred.
• Development of SSIS packages, SQL agent jobs and complex stored procedures.
• Development of SSRS reports, subscriptions, and data sources.
• Mainframe development, including Cobol, JCL, and VSAM, as well as CA-7 mainframe scheduling software is a plus.
• Familiarity with Azure and/or AWS cloud platforms.
• SQL Server query performance tuning.
• Design of 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 data warehousing, data architecture and design concepts with practical experience in the implementation of these concepts.
• Be self-motivated and have the desire to continually develop new skills and improve existing skills.
• Strong written and verbal communication skills and organization skills.
• Bachelor's degree preferred.
• 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.

Knowledge of data architecture, quality, mapping, and structures. Skill in providing direction in a clear and concise matter.

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 .

• 

• State of Missouri

Show more