Job Summary - Why you'll love this positionJob Location: - The office for this position is located at 3315 W. Truman Blvd., Jefferson City, MO 65109.
Why you'll love this position: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 Data Specialist position 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).
- 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) supporting 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 #OneTeam.
Responsibilities - What you'll do - Develop and maintain ETL processes using Microsoft SSIS and SQL agent jobs.
- Support complex stored procedures and custom functions.
- Analyze, solve, and correct production issues and provide documentation.
- Effectively prioritize and execute tasks in a fast-paced environment using Agile methodology.
- Support the integration of enterprise application databases and real time processing into the data warehouse.
- Create, adhere to, and enforce technical standards.
Qualifications - All you need for success - Experience with SQL Server and SQL Server query performance tuning.
- Ability to design 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 SQL Server data warehousing, data architecture, design concepts with practical experience in the implementation of these concepts, and cloud technologies.
- Be self-motivated and have the desire to continually develop new skills and improve existing skills.
- Strong written and verbal communication skills and organizational 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.This position is a critical position for the database environment support and modernization of the database environments. In addition, this position will help the team implement improvements and put in place more efficiencies to make DESE State and Federal Reporting easier through the use of AWS and CEDS and other modernization steps.
The classification for this position is Data Specialist: click for more information.
Job Details - More reasons to love this positionThe 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.
Contact Details - If you have questions or require any accommodations to participate in the application or interview process please contact:If you have questions please contact: 
Never miss an opportunity! Create an alert based on the job you applied for.
