Data Visualization & Insights Analyst

State of Missouri; Remote; USD 63,000 - 75,000; Full time

Job summary

A State government department is seeking a Data Visualization & Insights Analyst in Missouri. This role emphasizes transforming complex data into actionable insights for decision-making. The ideal candidate will have a Bachelor's degree and substantial experience in data analysis, SQL proficiency, and the ability to create effective visualizations. The position includes a competitive salary of $75,000/year along with an excellent benefits package supporting work-life balance and career development.

Benefits

Defined pension plan

Generous leave and holiday time

Health insurance coverage

Qualifications

• 5-7 years of relevant experience in data analysis or similar role.
• Proficiency in SQL necessary for data manipulation.
• Experience developing ETL processes in a regulated environment.

Responsibilities

• Design and maintain automated ETL processes for data extraction.
• Build dashboards and reports for various stakeholders.
• Transform raw data into usable datasets for analysis.

Skills

SQL (joins, aggregations, CTEs)

Data visualization skills

Building ETL pipelines

Analytical skills

Problem-solving skills

Education

Bachelor’s degree

Tools

Tableau

Power BI

Informatica

Job description

The Department of Social Services - Officer of the Director is seeking a Data Visualization & Insights Analyst to join our team.

Job Location: Statewide

The work location for this position can be anywhere in the state with 10%-15% of travel expected (if outside of Jefferson City).

Job Salary: $75,000/year

Individual(s) selected for this position may receive a higher rate based on a pay differential (e.g., shift, or time-of-service pay).

Under general supervision, the Data Visualization & Insights Analyst transforms complex program, operational, and key performance data into clear, actionable visual insights that support executive decision-making and frontline management across the Department. Working in close partnership with program and support divisions, this role transforms raw data into clean and usable data sets, designs and maintains dashboards, reports, and visual tools that improve transparency, accountability, and performance management. This position emphasizes clarity, usability, and impact over technical complexity, ensuring data products support strategic priorities, operational improvement, and compliance reporting.

Responsibilities

• Design, develop, and maintain automated ETL processes to extract data from various sources
• Design, build, and maintain dashboards, score cards, and visual reports for executive leadership, managers, operational teams, and a public audience
• Transform raw, unstructured data into clean, usable datasets for reporting and analysis
• Translate complex datasets into clear, intuitive visualizations that highlight trends, risks, performance gaps, and opportunities
• Build and optimize SQL pipelines to streamline data ingestion and enhance data accessibility
• Troubleshoot data quality issues and monitor ETL job performance
• Define data requirements and map source-to-target data flows
• Ensure consistent definitions and visual standards across agency dashboards while accommodating division-specific needs

Minimum Qualifications

• Bachelor’s degree and 5-7 years of relevant experience (Substitutions allowed)
• 5+ years experience as a Data Analyst or similar role
• Proficiency in SQL (joins, aggregations, CTEs)
• Experience building ETL pipelines (dbt, Informatica, or similar)
• Demonstrated ability to translate business questions into effective visual representations
• Experience working with large, complex datasets, preferably in government, health and human services, or similarly regulated environment

Experience in lieu of education will be considered. Lack of post-secondary education will not be used as the sole basis for denying consideration.

Preferred Qualifications

• Tableau Desktop Specialist/Certified Data Analyst/Power BI Data Analyst Associate or equivalent
• Working knowledge of SQL for data extraction and validation
• Strong facilitation, analytical, and problem-solving skills; ability to work effectively with frontline staff and executive leadership
• Ability to think independently and solve problems quickly and creatively.
• Attention to detail and commitment to data accuracy and integrity
• Ability to manage multiple priorities in a fast-paced, agency environment

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 any questions about this position, please contact Chris Rogers at [e-mail].

If you experience accessibility issues while applying, please contact Courtney Hall at [e-mail] or call 573-751-4244.

Recruitment Area: All qualified applicants.