-
Job Description
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 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 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 support complex stored procedures and custom functions.
- 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.
- 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:- SQL Server 2016/2019 preferred.
- Development of SSIS packages, SQL agent jobs and complex stored procedures.
- Familiarity with Azure and/or AWS cloud platform.
- 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.
- 5-8 years of information technology experience with emphasis in data management or data integration required.
- 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 . -
ABOUT THE COMPANY
-
-
State of Missouri
Show moreBuild the Missouri of tomorrow.
Ensure a strong foundation today.
Join a group of innovative team members focused on driving the State of Missouri forward. As public servants, our team members have the opportunity to produce work that is both lasting and important. This work serves to protect families, communities, and our natural resources.
No matter where you are in your career, whether entry level or senior level, a career with the State of Missouri will challenge you to grow both personally and professionally. Though one employer, there is no shortage of exciting opportunities as there are many career paths you may take within the State. If you are searching for a job that transforms lives, including your own, a career with the State of Missouri is the perfect fit!
-