Job Summary - Why you'll love this positionJob Location: This position will be working in-office at 615 Howerton Court, Jefferson City, MO, 65109.
Why you'll love this position:There are three openings for Senior Data Specialists with the Data Management Office that will be focused on ensuring the effective usage of data and responsible for managing the accuracy, usability, integrity and distribution of program data. One of the positions will be focused on the new Missouri Integrated Health Data Fabric and will be an integral part of the implementation team. The second position will be focused on child welfare and work with our Division of Youth Services data systems and be an integral part of the implementation team for a new Child Welfare Information System. The third of these positions will be focused on eligibility data for SNAP, TANF, and Medicaid, and the systems currently being implemented to support the new Community Engagement requirements and streamline both citizen and caseworker experience.
Responsibilities - What you'll do- Monitor daily data feeds and ETL pipelines from diverse DSS source systems, proactively identifying and resolving broken feeds.
- Implement data quality monitoring alerts to catch anomalies and serve as the first line of defense for data pipeline troubleshooting in collaboration with internal information technology staff as well as vendor partners.
- Design, build, and maintain light-to-mid complexity ETL/ELT pipelines to extract and transform data for your assigned program area.
- Prepare, clean, and structure raw data for advanced BI dashboards (Power BI, Tableau) and future machine learning applications, collaborating with Data Architects to ensure data models fit within larger system diagrams.
- Enforce enterprise data standards, naming conventions, and metadata documentation across your assigned division.
Qualifications - All you need for successMinimum Qualifications:- Bachelor's degree and 7-10 years of information technology experience with emphasis on data management or data integration
Preferred Qualifications: - Must be able to write, read, and debug code to automate data tasks, troubleshoot broken scripts, and manage ETL/ELT pipeline failures.
- Strong, hands-on experience with advanced scripting to query, join, and structure complex datasets.
- Deep knowledge of data administration and management best practices, including enforcing enterprise standards, maintaining data dictionaries, and ensuring the absolute quality, integrity, and privacy of HHS data.
- Proven ability to design, build, and maintain light-to-mid complexity data integration pipelines, with experience implementing proactive monitoring alerts to catch anomalies before they reach downstream BI dashboards; experience preparing, cleaning, and structuring data specifically to support both high-performance BI dashboards and advanced analytic/ML models.
- Ability to translate complex technical data pipeline issues into clear, business-focused impact statement for non-technical stakeholders.
- Strong interpersonal and consensus-building skills with the ability to collaborate effectively across agency boundaries.
- Experience working with Medicaid (MHD), Child Welfare (CD/DYS), or Public Assistance (FSD) data and federal reporting standards.
- Familiarity with regulatory data compliance frameworks such as HIPAA, 42 CFR Part 2, and NIST 800-53 security controls.
- Experience extracting and transforming data from legacy mainframe systems (e.g., COBOL, DB2 flat files) into modern relational databases or data warehouses.
Lack of post-secondary education will not be used as the sole basis denying consideration to any applicant.Contact Details - If you have questions or require any accommodations to participate in the application or interview process please contact:If you have questions about this position, please contact Zana Stephenson at Zana.Stephenson@dss.mo.govIf you experience accessibility issues while applying, please contact Courtney Hall at Courtney.A.Hall@dss.mo.gov.