State of Missouri · 1 day ago
Data Visualization & Insights Analyst
Missouri, United States
Full-time
Hybrid
Senior Level
$75K/yr - $75K/yr
5+ years expThe State of Missouri is seeking a Data Visualization & Insights Analyst to join their Department of Social Services. This role involves transforming complex data into actionable visual insights to support decision-making and performance management across the department.
GovernmentAgricultureInformation Technology
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
Qualification
Required
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
Preferred
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
Benefits
Defined pension plan
Generous amounts of leave and holiday time
Eligibility for health insurance coverage
Company
State of Missouri
The State of Missouri is a group of outstanding people that accomplish extraordinary things for our folks every day.
10001+ employees
H1B Sponsorship
State of Missouri has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Kevin Mccarthy
Chief Technology Officer
Jennifer Tidball
Chief Operating Officer at Missouri Department of Social Services
Recent News
2025-08-22
Seattle TechFlash
2025-05-10
Company data provided by crunchbase