Data & Reporting Analyst
Property Resources Group LLC
Madison, United States of America
yesterday
Role details
Contract type
Temporary to permanent Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Madison, United States of America
Tech stack
Data analysis
Data Auditing
Data Integration
Data Integrity
ETL
Data Systems
Data Warehousing
IBM DB2
Relational Databases
Microsoft SQL Server
Medicaid Management Information Systems (MMIS)
MySQL
Oracle Applications
Power BI
Standard Sql
SAS (Software)
SQL Databases
SQL Server Reporting Services
Tableau
Data Analytics
User Administration
Job description
The Data & Reporting Analyst will support enterprise reporting and analytics initiatives for Medicaid and public assistance programs. This role is responsible for gathering business requirements, analyzing complex data, developing ad hoc and standard reports, and ensuring compliance with state and federal regulations. The ideal candidate will bridge business and technical teams, translate policy requirements into reporting solutions, and support data-driven decision-making., * Analyze, develop, test, and maintain complex reports and data solutions.
- Gather and document business requirements, technical specifications, and process flows.
- Create SQL/SAS queries to extract, validate, and analyze data from large relational databases.
- Collaborate with stakeholders to translate policy and business needs into reporting requirements.
- Ensure reporting accuracy, data integrity, and regulatory compliance.
- Develop test plans, execute testing, and resolve data/reporting issues.
- Create user documentation, data flow diagrams, and reporting procedures.
- Support data warehouse, ETL, and enterprise reporting initiatives.
- Lead small to medium-sized projects and provide status updates to project leadership.
Requirements
- 3+ years of Business Analysis and Data Analytics experience.
- Strong SQL and data reporting experience.
- Experience with relational databases (Oracle, SQL Server, DB2, SAS, MySQL, etc.).
- Knowledge of data warehousing, ETL processes, and data integration.
- Experience with reporting and visualization tools such as Power BI, Tableau, SSRS, or SAS.
- Strong requirements gathering, documentation, testing, and stakeholder management skills.
- Excellent communication, analytical, and problem-solving abilities., * Experience supporting Medicaid, MMIS, healthcare, or government programs.
- Knowledge of healthcare claims, eligibility, provider management, or data warehouse environments.
- CBAP/CCAP or related Business Analysis certification preferred.