Reporting specialist with public benefits

The Data & Reporting Analyst will join the Integrated Data & Analytics Section (ID&AS) to
support complex data initiatives for Wisconsin’s Medicaid and FoodShare programs. Working
alongside ID&AS staff and contracted MMIS vendors, 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.
Key Responsibilities
1. Data Analysis and 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.
Knowledge Services RFS Summary
2
• Lead small to medium-sized project teams through problem-solving and
implementation phases.
• General skills and experience:
o Excellent interpersonal communication skills
o Excellent organization and time management skills
o Providing detailed status report updates to Project Manager
o Experienced with business process reengineering and identifying new
applications of technology to business problems to make business more
effective
o Experience with business analyst and testing industry standards, current and
emerging technologies, business process mapping, and reengineering
• Business analyst skills and experience:
o Facilitation
▪ Efficiently plan and execute meetings
▪ Establish agenda and set meeting objectives
▪ Document and distribute meeting decisions and action items
▪ Timely follow-up on all action items
▪ Document issues and providing to Project Manager
▪ Formulate systems to parallel overall business strategies
▪ Prepare Risk Identification
▪ Prepare Fiscal Analysis (i.e. cost/benefit, ROI, buy/build)
▪ Relies on experience and judgment to plan and accomplish goals.
Independently, performs a variety of complicated tasks. A wide
degree of creativity and latitude is expected.
o Elicitation
▪ Efficiently and effectively divine business requirements from
business area staff
o Documentation
▪ Use established business requirement templates
▪ Produce clear and concise requirements documentation
▪ Create traceability to RFP requirements
o Validation
▪ Effectively and efficiently review and validate documented business
requirements with business area staff and owners
▪ Review, analyze, and evaluate business systems and user needs
o Testing
▪ Document clear test plans and create test cases that are traceable to
business, functional, non-functional, and transition requirements
▪ Effectively and efficiently executes test plan and document test
results
▪ Document defects and collaborates with other business analysts and
developers to resolve and execute regression testing
▪ Facilitate review of test results with project stakeholders
• Data analytics skills and experience:
o Analyze and document the current state of existing data repositories and the
associated data reporting environments
o Assess end-to-end data integration workflows and systems operational
dependencies
Knowledge Services RFS Summary
3
o Create and maintain technical documentation such as data flows, interface
control documents, entity relationship diagrams and data catalogs
o Assist in clearly defining the future state of enterprise data analytics
capabilities
o Ability to grasp technical concepts (such as Data Warehouse, ETL,
Transactional Batch Processing, Data Schemas, Secured Transport, etc.) and
communicate to System Delivery Teams
o Gather and analyze end user requirements for new and existing data loads
for the enterprise data warehouse
o Create technical specifications to load data from disparate source systems
into the enterprise data warehouse for reporting and analysis
o Experience working in system environments with relational databases
(either SAS, MySQL, Oracle, MS SQL, DB2, etc.)
o Knowledge of data reporting platforms (either MS SSRS, MS Access, SAS,
etc.)
o Knowledge of data visualization tools (either SAS Visual Analytics, Power BI,
Tableau, etc.)
• Industry skills and experience
o 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
o Certified Business Analysis Professional (CABP) preferred
Hours
Required
Monday through Friday, 8:00 a.m. 5:00 p.m.
Work Location This position is remote and work must be performed within the St