-
Job Description
Job Location:- The office for this position is located at the Roberts State Office Building 1706 E. Elm St, Jefferson City, 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!
As a Data Technician you will have the opportunity to develop complex SSRS reports and SQL Server stored procedures that make data available to users of our data 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 grow your skill set in a positive environment. You will have the chance to deliver meaningful impact supporting DMH and the citizens of Missouri.
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.
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 complex reports using SSRS or other reporting tools as needed.
- Develop and support complex stored procedures and custom functions.
- Analyze, solve, and correct production issues and provide documentation.
- Communicate with business users to establish report requirements.
- Use critical thinking skills and good judgment in decision making.
- Effectively prioritize and execute tasks in a high-pressure environment using Agile methodology.
- Analyze, design, and develop code for daily work and projects.
- Adhere to established technical standards.
- Bachelor's degree preferred.
- 2-5 years of Information Technology experience with emphasis in data management, data integration, or data reporting required.
- SQL Server Management Studio.
- Visual Studio 2019 or above.
- Development of SSRS reports and complex stored procedures.
- Design and maintenance of complex reports using multiple tables and fields.
- Familiar with Azure DevOps.
- Strong data investigation and problem solving skills.
- Knowledge of data warehousing and design concepts with practical experience in the implementation of these concepts.
- Familiar with Agile development concepts.
- Experience with source control and Visual Studio 2019 or later versions is preferred.
- Development using Tableau, Power BI, or Power Apps cloud tools in Azure a plus.
- Strong written and verbal communication skills.
- Ability to be organized, self-motivated, and to work on a team or independently as required.
- 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 database management tools, reporting, structure/design, and query languages. Knowledge of how data structure/design affects network performance. Ability to learn and apply technical-related concepts. Ability to follow technical directions. Ability to problem-solve and apply analytical skills in resolving data issues.
The classification for this position is Data Technician ; 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: ITSDRecruiting@oa.mo.gov -
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!
-