**Bidders – Please note that you will be required to provide an updated resume to the hiring supervisor/manager for this position**

***This position is eligible for telework for applicants who reside in Minnesota or in a bordering state, with supervisory approval and satisfactory performance. If you live in a state bordering Minnesota, you must live within 50 miles or less from the primary work location to be eligible for telework.*** As a Medicaid Data Analyst, the incumbent will perform queries and data analysis to ensure that quarterly Medicaid reporting is completed accurately and timely. Responsibilities include but may not be limited to: • Oversee data preparation and information management to support federal Medicaid reporting and project-specific requirements. • Query and analyze data for federal reporting related to Medicaid claims financing changes. • Ensure fiscal data integrity through data warehouse queries of post-production funding code and claim changes.

**To facilitate proper crediting, please ensure that your resume clearly describes your experience in the areas listed and indicates the beginning and ending month, day and year for each job held.** Three (3) years of experience in data analysis. Experience must also demonstrate: • Writing SQL queries and developing reports and dashboards using Microsoft Power BI, including: o • Experience developing, maintaining, or supporting reports, data extracts, dashboards, or other business intelligence tools. o • Experience collecting, validating, analyzing, and interpreting data to identify trends, resolve data discrepancies, and support business operations and decision-making. • • Experience using Microsoft Excel and other reporting or data analysis tools to organize, reconcile, maintain, and present data for business users and management. • Experience extracting data from data warehousing using SAS or SQL in a variety of applications. • Experience providing data and other information for auditing purposes. • Creating dashboards, reports, and other methods of synthesizing analytic results. • Knowledge of Generally Accepted Accounting Principles (GAAP) and State Wide Integrated Financial Tools (SWIFT) or similar electronic accounting system. *** A Bachelor’s degree in social science, data science, analytics, research, public administration, accounting, finance or related field may substitute for one (1) year of experience.*** OR *** A Master’s degree in social science, data science, analytics, research, public administration, accounting, finance or related field may substitute for two (2) years of experience.***

• Experience extracting data from the DHS Data Warehouse. • Knowledge of the MMIS/MAXIS/METS/SSIS data system (or similar eligibility system for public assistance and health care), data structure, data relationships, and processes. • Understanding and experience in federal financial reporting. • Knowledge and experience in the Minnesota Government Data Practices Act (MGDPA). • Experience in designing, administering, and troubleshooting data models in a relational database system. • Knowledge of state and federal assistance programs and resulting data systems especially MMIS. • Demonstrated understanding of the roles and inter-relationships of local, state, federal, and community agencies in the administration of public programs. • Variety of experiences working effectively with others from different backgrounds and cultures.