Data Reporting Analyst

Key responsibilities

• Develop and maintain clinical, operational, financial, reimbursement, auditing, and management reports.
• Build interactive Power BI dashboards and Excel-based analytical tools.
• Write and maintain SQL queries, stored procedures, views, and extraction processes.
• Combine and reconcile information from Epic, NextGen, athenahealth, SQL Server, and other data sources.
• Analyze patient populations, providers, encounters, diagnoses, procedures, laboratory results, and medication records.
• Incorporate ICD-10, CPT, HCPCS, and medication classifications into reporting logic.
• Partner with clinical, operational, billing, reimbursement, auditing, finance, and management teams to define reporting needs and business rules.
• Validate results, reconcile source-system differences, investigate discrepancies, and resolve reporting issues.
• Automate recurring reports and data-processing workflows.
• Document data sources, calculations, business rules, SQL logic, and reporting processes.
• Protect confidential information and follow HIPAA requirements.

Required qualifications

• Experience in healthcare reporting and data analysis using EHR systems such as Epic, NextGen, and athenahealth.
• Strong SQL skills, including joins, aggregations, subqueries, transformations, stored procedures, and validation.
• Experience developing Microsoft Power BI reports and dashboards.
• Strong Excel skills, including PivotTables, formulas, data analysis, and data manipulation.
• Experience reporting on laboratory and medication data.
• Working knowledge of ICD-10, CPT, and HCPCS coding systems.
• Ability to validate data, reconcile differences, and investigate root causes.
• Ability to translate business questions into reporting requirements and explain findings clearly.
• Strong analytical, organizational, and problem-solving skills.
• Knowledge of HIPAA requirements and handling of PHI.

Preferred qualifications

• Epic Caboodle certification or experience with Epic Caboodle or Clarity data.
• 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.
• Familiarity with ATC codes, medication terminology, 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 with Visual Basic, VB.NET, Python, or Microsoft Visual Studio.
• Bachelor's degree in information systems, computer science, data analytics, healthcare informatics, business, or a related field, or equivalent experience.