Visual & Usage Data Analyst

The position Visual & Usage Data Analyst (K0233552) Gathers, analyzes, and interprets more complex data using appropriate statistical techniques and computer software to obtain and present findings. Perform economic modeling using various statistical techniques. Design queries and collect data from the Medicaid database system to track multiple funded services to report on usage trends, costs, efficiencies, and effectiveness of health programs. Creates and maintains queries for utilization across managed care encounter data and specific populations when requested. Maps and traces data across multiple systems to identify and resolve problems. Creates and maintains documentation for each report. Data is gathered from the agency’s system, other states, or other national sources. Peer reviews others’ analyst work while providing feedback and best practices. Design, build, and maintain dashboards and reports using Tableau, Power BI, or similar tools to support Medicaid program evaluation, performance tracking, and financial forecasting., * Performs ad hoc analysis and interprets results for a wide audience, including TMaH staff, DHCF staff, and stakeholders.

• Provides data for legislative requests or policy analysis. Responds to written and verbal inquiries concerning Medicaid data.
• Responds to written and verbal inquiries concerning Medicaid data.
• Displays a readiness to expand workload to meet leadership expectations.
• Support external data reporting needs, including CMS reporting, legislative inquiries, and responses to public records requests., + Valid Driver’s License - Incumbent is required to have and maintain a valid driver’s license when operating a state vehicle, a private vehicle, or a rental vehicle for the benefit of the State.

• High School, GED, + Demonstrates strong analytical skills, supported by two years of experience in the health insurance or healthcare data sector, working with claims/encounter data, quality data, and/or clinical data.
• Proficiency in data visualization, with one year of experience utilizing Tableau, Power BI, or similar software to generate insightful visual representations.
• Education may be substituted for experience, as deemed relevant by the agency.
• Preferred Qualifications:
• Strong analytical and critical thinking with the ability to effectively collaborate with others
• Ability to exercise good judgment in evaluating situations and making decisions
• Experience in health care or insurance
• Two years of experience performing analysis of procedures, policies or programs
• Strong written and oral communication skills
• Ability to prepare comprehensive reports and data in clean, concise ways and communicate information
• Strong proficiency in Tableau, Power BI, or similar tools to create dashboards and reports
• Word, Excel, PowerPoint, Access
• Proofreading, editing, attention to detail
• Background in health care or related services
• Post-Offer, Pre-employment Requirements:
• Kansas Tax Clearance Certificate: A valid Kansas Tax Clearance Certificate is a condition of employment for all employees of the State of Kansas. Applicants (including non-residents) who receive a formal job offer for a state job, are required to obtain a valid Tax Clearance within ten (10) days of the job offer. A Tax Clearance can be obtained through the Kansas Department of Revenue who reviews individual accounts for compliance with Kansas Tax Law. If you have a missing tax return(s) or you owe taxes to the State of Kansas, please know that the Kansas Department of Revenue will work with you. The Kansas Department of Revenue can set you up on a payment plan to receive a Tax Clearance so you can get a job working for the State of Kansas. The Kansas Department of Revenue can be contacted at . Kansas Department of Revenue - Tax Clearance Frequently Asked Questions

Our agency is led by Secretary Janet Stanek, who was appointed by Gov. Kelly in Dec 2021. KDHE is comprised of three divisions: Public Health, Environment, and Health Care Finance (which includes the State’s Medicaid program, KanCare). We are the only agency in the nation to have these three entities under one roof which allows us to take a holistic approach to improving and protecting the health and well-being of all Kansans.