Job Location: - The office for this position is located at the Harry S. Truman State Office Building, 301 W High Street, Jefferson City, MO. 65101.
Why you'll love this position: Do you want to see the impact of your efforts in action? Then this may be a great opportunity for you! This Data Analyst position is a vital member of our Application Development Support Team responsible for running queries, loading data, and creating custom SQL solutions that move and transform data to ensure accuracy and availability. A variety of work includes new project work, researching and resolving support tickets for live applications within the portfolio, and creating and maintaining documentation for training purposes. Duties may also include data modeling and database work. The successful candidate must be a motivated problem solver who can work independently or in a team environment. They must also have a desire to continually develop new skills through self-study and assigned training or attendance at user group presentations.
By joining this team you will have the chance to deliver meaningful impact supporting DOC and the citizens of Missouri.
This position is with the Office of Administration, Information Technology Services Division (OA-ITSD) supporting the Department of Corrections (DOC).
ITSD Core Values - We Innovate and Partner with Passion, Respect, and Integrity United as #OneTeam.
What you'll do: - Develop and maintain SQL queries and system data databases, relationships, indexes, views, tables, and fields.
- Develop and support complex stored procedures and custom functions.
- Analyze, solve, and correct production issues and provide/edit documentation.
- Communicate with business users to establish database and report requirements.
- Effectively prioritize and execute tasks in a high-pressure environment.
- Analyze, design, develop, peer review, test, and implement code for projects.
- Create, adhere to, and enforce technical standards.
- Work independently and as part of a team.
- Continuous learning (technical and professional development).
All you need for success:
The following Knowledge, Skills, and Abilities are critical to the success of this position:
- SQL and DB2LUW proficiency is strongly preferred.
- Development of SQL agent jobs and complex stored procedures.
- SQL query performance tuning.
- Design of databases, including relationships, indexes, views, tables, and fields.
- 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.
- Strong written and verbal communication skills, be organized, and self-motivated, can work on a team or independently as required, and have the desire to continually develop new skills and improve existing skills.
- 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, multi-task, and take initiative toward innovative solutions
- 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.
More reasons to love this position: 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
