Data Reporting Analyst

Nephrology Associates of Northern Illinois and Indiana; Oak Brook (IL); On-site; USD 75,000 - 82,000; Full time

Job summary

Nephrology Associates of Northern Illinois and Indiana in Oak Brook, IL, seeks a Data Reporting Analyst to develop, maintain, and improve reporting supporting clinical care, operations, finance, and management. You will work with data from EHR systems to deliver accurate, timely information.

The role uses SQL, Power BI, and Excel to build reports, dashboards, data extracts, and automated processes, with accountability for data quality and stakeholder communication.

Qualifications

• Experience in healthcare reporting and data analysis using multiple EHR systems.
• Strong SQL skills incl. joins, aggregations, subqueries, stored procedures, and validation.
• Experience building Microsoft Power BI reports and Excel dashboards.
• Familiarity with ICD-10, CPT, HCPCS, and healthcare data relationships.
• Ability to translate business questions into clear reporting requirements.

Responsibilities

• Develop and maintain clinical, operational, financial, and management reports.
• Build interactive Power BI dashboards and Excel analytical tools.
• Write and maintain SQL queries, stored procedures, and data extracts.
• Integrate data from Epic, NextGen, athenahealth, and SQL Server sources.
• Collaborate with teams to define needs, rules, and acceptance criteria.
• Validate results and troubleshoot data discrepancies across sources.
• Automate recurring reporting and improve data refresh processes.
• Document data sources, calculations, and reporting logic.

Skills

SQL

Power BI

Excel

Healthcare reporting

EHR data

Data validation

Communication

HIPAA

Problem solving

Education

Bachelor's degree

Tools

SQL Server

VB.NET

Python

Visual Studio

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Reporting Analyst

Full Time Corporate Corporate, Oak Brook, IL, US

2 days ago Requisition ID: 1198

Salary Range: $75,000.00 To $82,000.00 Annually

Department: Information Technology | Reports to: Reporting and Analytics Manager

Onsite Monday – Thursday (Remote Friday) 8:30AM – 4:30PM CT

Position Summary

NANI is seeking a Data Reporting Analyst to develop, maintain, and improve reporting and analytics that support clinical care, operations, finance, reimbursement, auditing, and management. This position works with data from multiple electronic health record (EHR) systems, databases, and data warehouses to deliver accurate, timely, and actionable information.

The successful candidate will use SQL, Microsoft Power BI, and Excel to build reports, interactive dashboards, data extracts, and automated reporting processes. This is a hands‑on role with accountability for data quality, stakeholder communication, and dependable delivery, with an emphasis on reducing manual reporting and improving access to current information.

Key Responsibilities

• Reporting and dashboard development: Develop and maintain clinical, operational, financial, reimbursement, auditing, and management reports. Build interactive Power BI dashboards and Excel‑based analytical tools that help teams monitor performance and make informed decisions.
• Data extraction and integration: Write and maintain SQL queries, stored procedures, views, and extraction processes. Combine and reconcile information from Epic, NextGen, athenahealth, SQL Server, and other available data sources.
• Clinical and coding analysis: Analyze patient populations, providers, encounters, diagnoses, procedures, laboratory results, and medication records. Incorporate ICD‑10, CPT, HCPCS, and relevant medication classifications into reporting logic; evaluate laboratory dates and values and medication names, brands, and classifications.
• Business requirements and delivery: Partner with clinical, operational, billing, reimbursement, auditing, finance, and management teams to define reporting needs, business rules, and acceptance criteria. Prioritize requests, communicate progress, and deliver against agreed deadlines.
• Data quality and troubleshooting: Validate results, reconcile source‑system differences, and investigate discrepancies in clinical, laboratory, medication, billing, reimbursement, and encounter data. Resolve reporting, database, and application issues with the appropriate teams.
• Automation and standardization: Automate recurring reports and data‑processing workflows, improve refresh processes, and reduce manual effort. Maintain consistent definitions and update reports as business, clinical, and regulatory requirements change.
• Quality and performance analytics: Identify trends in outcomes, utilization, cost of care, reimbursement, and operational performance. Support value‑based care, population health, and quality reporting, including Kidney Care Choices (KCC) reporting when applicable.
• Documentation and change readiness: Document data sources, calculations, business rules, SQL logic, and reporting processes. Test and validate reporting impacts from EHR, database, interface, and process changes; provide backup for critical reports and reporting‑team responsibilities.
• Privacy and security: Protect confidential information and protected health information (PHI). Follow HIPAA and NANI requirements for data access, handling, storage, and sharing.

Required Qualifications

• Experience in healthcare reporting and data analysis using EHR systems such as Epic, NextGen, and athenahealth, including large datasets from multiple sources.
• Strong SQL skills, including joins, aggregations, subqueries, transformations, stored procedures, and validation; experience with Microsoft SQL Server or a comparable relational database platform.
• Experience developing Microsoft Power BI reports and dashboards, along with strong Excel skills in PivotTables, formulas, data analysis, and data manipulation.
• Experience reporting on laboratory and medication data, with an understanding of patient, provider, encounter, diagnosis, procedure, scheduling, billing, reimbursement, and operational information.
• Working knowledge of ICD‑10, CPT, and HCPCS coding systems and their application to healthcare reporting and analysis.
• Demonstrated ability to validate data, reconcile differences across source systems, investigate root causes, and deliver accurate reporting solutions.
• Ability to translate business questions into reporting requirements and explain findings clearly to technical and nontechnical audiences.
• Strong analytical, organizational, and problem‑solving skills, with attention to detail and the ability to manage competing priorities independently and collaboratively.
• Knowledge of HIPAA requirements and appropriate handling of PHI and confidential healthcare information.

Preferred Qualifications

• Epic Caboodle certification; experience with Epic Caboodle or Clarity data; additional Epic reporting and analytics certifications or proficiencies.
• Experience with nephrology billing and coding, healthcare claims, reimbursement, revenue cycle, or auditing.
• Familiarity with value‑based care and the Kidney Care Choices (KCC) Model, including quality measures, population health, patient outcomes, utilization, cost of care, and performance monitoring.
• Familiarity with Anatomical Therapeutic Chemical (ATC) codes, medication terminology, generic and brand drug names, and drug classification systems.
• Experience integrating or reconciling data across Epic, NextGen, and athenahealth; experience with ETL processes, enterprise data warehouses, and data pipelines.
• Advanced Power BI skills in data modeling and DAX; experience automating recurring reporting and data‑processing workflows.
• Experience with Visual Basic or VB.NET , Python, or Microsoft Visual Studio for reporting tools, application development, or automation.
• Bachelor’s degree in information systems, computer science, data analytics, healthcare informatics, business, or a related field, or equivalent professional experience.

Measures of Success

• Accurate, validated reports and dashboards delivered within agreed timelines.
• Reduced manual reporting effort through automation and standardized processes.
• Reliable data refreshes and timely investigation and resolution of discrepancies.
• Clear request ownership, stakeholder communication, and documentation of reporting logic.
• Reports and dashboards that meet stakeholder needs and support clinical, operational, financial, and quality decisions.

Work independently and collaboratively with clinical, business, and technology teams. Maintain ownership of assigned requests, provide backup for critical reporting processes, and follow NANI privacy and security requirements. Continue developing knowledge of healthcare systems, analytics tools, coding, medication classifications, and value‑based care reporting.

Compensation and HR Finalization

Annual base salary: $75,000–$82,000 USD, depending on relevant experience, certifications, and qualifications.