Data Analyst

Job Location:

• The office for this position is located at the Department of Mental Health, 1706 East Elm Street, 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 with the Office of Administration, Information Technology Services Division, supporting the Department of Mental Health (DMH) might be for you!

ITSD-DMH has an opening for a Data Analyst. In this position, you will have the opportunity to develop complex data integration solutions that support DMH healthcare and billing applications as a member of an agile, well-organized team. You will have the ability to learn new tools for data integration and grow your skill set in a positive environment. You will have the chance to deliver a 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 integration solutions platform to meet business needs for healthcare and billing solutions.
• Develop and support HL7 and EDI transactions, API solutions, and PowerShell scripts.
• Develop and support complex stored procedures and custom functions.
• Analyze, solve, and correct production issues and provide documentation.
• Communicate with business users to establish business project 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.

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

• Bachelor's degree preferred.
• 2-5 years of Information Technology experience with emphasis in Data Management or Data Integration.
• Development of BizTalk solutions a plus.
• SQL Server 2019/2022 preferred.
• SQL Server query and stored procedure development.
• Familiar with Azure and/or AWS cloud platforms.
• Familiar with Azure DevOps and Agile development concepts.
• Strong data investigation and problem-solving skills.
• Knowledge of development and design concepts with practical experience in the implementation of these concepts.
• Effectively prioritize and execute tasks in a high-pressure environment using Agile methodology.
• Experience with Visual Studio and source control is preferred.
• Strong written and verbal communication skills.
• Be self-motivated and have the desire to continually develop new skills and improve existing 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.

Knowledge of data modeling and design. Ability to think methodically and critically. Ability to identify, evaluate, and resolve database performance issues. Ability to organize work assignments and multi-task.

The classification for this position is Data Analyst : 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