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 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 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 ETL processes using Microsoft SSIS and SQL agent jobs.
- Develop and support complex stored procedures and custom functions.
- Develop and support cloud interfaces and APIs for use with databases, data warehouses or application infrastructure.
- Analyze, solve, and correct production issues and provide documentation.
- Communicate with business users to establish database and SSIS 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.
The ideal candidate will have the following technical and soft skills:
- SQL Server 2016/2019 preferred.
- Development of SSIS packages, SQL agent jobs, and complex stored procedures.
- Familiarity with Azure and/or AWS cloud platform.
- Familiarity with MuleSoft or other API development 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.
- 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 .
