Data Reporting Analyst

Position summary

Schedule

• Full-time schedule, Monday through Friday, 8:30 a.m. to 4:30 p.m. Central Time.
• Onsite Monday through Thursday and remote Friday.

Key responsibilities

• Develop clinical, operational, financial, reimbursement, auditing, and management reports, Power BI dashboards, and Excel analytical tools.
• Write SQL queries, stored procedures, views, and extraction processes; combine and reconcile data from Epic, NextGen, athenahealth, SQL Server, and other sources.
• Analyze patient, provider, encounter, diagnosis, procedure, laboratory, and medication data, incorporating ICD-10, CPT, HCPCS, and medication classifications into reporting logic.
• Work with clinical, operational, billing, reimbursement, auditing, finance, and management teams to define reporting needs, business rules, and acceptance criteria; prioritize requests and communicate progress.
• Validate reporting, investigate discrepancies, reconcile source-system differences, and resolve reporting, database, and application issues with relevant teams.
• Automate recurring reports and data workflows, improve refresh processes, reduce manual effort, and maintain consistent definitions.
• Identify trends in outcomes, utilization, cost of care, reimbursement, and operational performance; support value-based care, population health, and quality reporting, including KCC reporting when applicable.
• Document data sources, calculations, business rules, SQL logic, and processes; test changes and provide backup for critical reports.
• Protect confidential information and PHI and 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 SQL Server or a comparable relational database.
• Experience developing Power BI reports and dashboards and strong Excel skills, including PivotTables, formulas, data analysis, and data manipulation.
• Experience reporting on laboratory and medication data and understanding patient, provider, encounter, diagnosis, procedure, scheduling, billing, reimbursement, and operational information.
• Working knowledge of ICD-10, CPT, and HCPCS coding systems and their use in healthcare reporting and analysis.
• Ability to validate data, reconcile source differences, investigate root causes, and deliver accurate reporting solutions.
• Ability to translate business questions into reporting requirements and explain findings to technical and nontechnical audiences.
• Strong analytical, organizational, and problem-solving skills, attention to detail, and ability to manage competing priorities independently and collaboratively.
• Knowledge of HIPAA requirements and appropriate handling of PHI and confidential healthcare information.