Data & Reporting Analyst

Property Resources Group LLC

Madison, WI, United States

2 months ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

3 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Data Analysis Data Auditing Data Integration Data Integrity Extract Transform Load (ETL) Data Systems Data Warehousing IBM DB2 Relational Databases Microsoft SQL Server Medicaid Management Information Systems (MMIS) MySQL

+9 more

Oracle (Applications) Power BI Standard Sql SAS (Software) SQL Databases SQL Server Reporting Services Tableau (Software) 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.