Senior Data Specialist

Join to apply for the Senior Data Specialist #1999022 role at State of Missouri

The office for this position is located at 3315 W. Truman Blvd., Jefferson City, MO 65109.

Are you looking for a rewarding career? Do you enjoy working with collaborative teams? Are you looking for a position that will allow you to work on a variety of projects? If so, we invite you to apply for the Senior Data Specialist position.

• 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.
• The salary indicated represents a base pay rate. If the individual selected or the position is eligible for a pay differential (e.g., shift, security, or years of service), it will be added to the total compensation in your paycheck. A pay differential does not raise your base pay.

This position is with the Office of Administration, Information Technology Services Division (OA-ITSD) within the Office of Administration, Information Technology Services Division (OA-ITSD) supporting the Department of Elementary and Secondary Education (DESE) and the Department of Higher Education and Workforce Development (DHEWD).

ITSD Core Values - We Innovate and Partner with Passion, Respect, and Integrity United as #One Team.

• Primarily responsible for architecting, configuring, analyzing, and maintaining data structures.
• Design and implement solutions to integrate data between on‑premises and cloud technologies.
• Learn and demonstrate software products and prototype functionality to stakeholders.
• Create, adhere to, and advise team members of best practices, standards, and methodologies.
• Support the integration of enterprise application databases and real‑time processing into the data warehouse.
• Responsible for the full life cycle development, implementation, support, architecture and tuning of databases, data warehouses, and data pipelines.
• Write technical policies, procedures, and documentation for the systems, including data flow diagrams, architecture diagrams, etc.
• Effectively prioritize and execute tasks in a high‑pressure environment using Agile methodology. Mentor database team members.
• Critical thinking and problem‑solving skills.
• Minimum 9 years in IT industry with emphasis in database development and architecture.
• Develop and maintain ETL processes using Microsoft SSIS and SQL agent jobs.
• Develop and support complex stored procedures and custom functions.
• Familiar with Azure Dev Ops and Agile development concepts.
• 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.

will not be used as the sole basis denying consideration to any applicant.

Knowledge of multiple platforms. Skill in prioritizing and multi‑tasking. Skill in communicating and collaborating with and providing guidance to staff.

The classification for this position is Senior 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.

If you have questions please contact: ITSDRecruiting.gov

Mid‑Senior level

Full‑time

Information Technology

Government Administration