Data & Reporting Analyst Medicaid

ID: KCIDS159566WIRM0611

We are not working with recruiting firms for this role.

This Data & Reporting Analyst will join the Integrated Data & Analytics Section (ID&AS) to support complex data initiatives. Along with other staff, this role is responsible for the end-to-end lifecycle of data reporting, from gathering requirements with stakeholders to the technical development and implementation of ad hoc and standard reports. The ideal candidate bridges the gap between policy and technology, ensuring all data outputs are compliant with state and federal regulations.

• Important Details -
• Remote or On-site: Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role. This position is remote, but work must be performed within the State of Wisconsin. Selected candidate will be required to be onsite in Madison, Wisconsin once a month.

Interview Process: MS Teams Video - at least 1 Round

Duration: 6/30/2027 with possibility of extension for a minimum of 1 year

• Key Responsibilities
• 1. Data Analysis & Report Development
• Perform analysis, development, preparation, implementation, and evaluation of complex standard and ad hoc reports that support data collection, access, changes, retrieval and retention related to Medicaid and FoodShare programs.
• Determine report specifications and assist in preparing necessary queries to obtain required data for reports to complete technical queries using SQL/SAS to extract and manipulate data from MES and IM databases.
• Perform rigorous testing and evaluation of report outputs to ensure accuracy and data integrity.

• 2. Stakeholder Engagement & Requirements Gathering
• Collaborate with internal and external stakeholders, management staff, and other colleagues to define reporting requirements and refine system modifications.
• Translate complex policy language into user-friendly logic flows and technical specifications.
• Review design layouts and file structures, providing recommendations for resource allocation and optimization.

• 3. Regulatory Compliance & Policy Integration
• Review and analyze changes in federal and state rules and regulations for impact on policy and processes, including system software support, especially those necessary for reporting.
• Implement necessary revisions to reporting frameworks to ensure 100% compliance with shifting regulations.
• Evaluate standard reports for cost improvements and operational efficiencies.

• 4. Documentation & Project Leadership
• Prepare written comprehensive system and data requirements, flowcharts, and draft formal work directives for vendors.
• Develop end-user documentation, program manuals, and user guides to ensure seamless adoption of reporting tools.
• Lead small to medium-sized project teams through problem-solving and implementation phases.

• Required Skills & Experience
• Key Skills and Experience (3 to 5 years of experience):
• Data Analysis and Report Development
• Stakeholder Engagement and Requirements Gathering
• Regulatory Compliance & Policy Integration
• Documentation & Project Leadership

Data analytics Skills & Experience:

• Experience working in system environments with relational databases (either SAS, MySQL, Oracle, MS SQL, DB2, etc.)
• Knowledge of data reporting platforms (either MS SSRS, MS Access, SAS, etc.)
• Knowledge of data visualization tools (either SAS Visual Analytics, Power BI, Tableau, etc.)

Industry Skills & Experience:

• 3 to 5 years of experience performing a business analyst role supporting State Medicaid and MMIS, or similar health care business and system in one or more of the following functional areas:
• Provider management
• Member (recipient) eligibility and enrollment
• Claims and encounters
• Benefit plan administration
• Service authorization
• Financial services
• Decision support system/data warehouse
• Pharmacy benefit management
• Program integrity and utilization management

Certifications:

Certified Business Analysis Professional (CABP) preferred

Benefits:

• Hourly rate for 1099: $68.00
• Hourly rate for W2: $49.00

Full-Time W2 employees may receive the following benefits:

• Health and Dental Insurance
• Life Insurance
• Short/Long Term Disability Insurance
• Simple IRA
• Referral Bonus
• Employee Assistance Program

Keystone Consulting, Inc. is an equal opportunity employer and is following Wisconsin’s Contract Compliance law. U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Keystone Consulting, Inc. participates in E-Verify. For more information, please click the following links:

• E-Verify Participation
• Right to Work
• Derecho a Trabajar
• WI Contract Compliance Law