Working with a high degree of ownership and attention to detail, the Reporting Analyst gathers and validates data, develops and maintains recurring and ad hoc reports, identifies trends, risks, and performance gaps, and communicates findings through clear dashboards, summaries, and recommendations. The role helps resolve data-quality and reporting barriers that may affect operational efficiency, service quality, revenue performance, or strategic initiatives.
Key responsibilities include:
- Build and govern scalable dashboards, KPI scorecards, operational reporting suites, and executive reporting packages.
- Lead cross-functional reporting solutions across Order Management and Quality.
- Establish performance measurement frameworks, KPI hierarchies, targets, service-level indicators, and exception thresholds.
- Perform multidimensional, longitudinal, and root-cause analyses to identify performance drivers, risks, bottlenecks, and revenue or service opportunities.
- Translate business questions into data, integration, and reporting requirements.
- Partner with vendors, system owners, IT, and operations stakeholders to define, test, validate, and operationalize new fields and data feeds.
- Create and maintain data dictionaries, metric specifications, lineage documentation, validation rules, ownership standards, and downstream impact assessments.
- Develop and validate SQL queries and reusable data models across operational, financial, quality, and vendor datasets.
- Design data-quality controls, reconciliations, anomaly detection, and issue-resolution protocols.
- Apply SQL, Excel, Tableau, Power BI, and other analytical tools to create visualizations, diagnostics, forecasts, and decision-support tools.
- Identify and implement automation and AI-enabled reporting opportunities.
- Build analytical views of the order lifecycle from referral volume and intake productivity through shipment, billing readiness, and revenue outcomes.
- Develop capacity, productivity, service-level, quality, and work-queue analyses.
- Conduct root-cause investigations involving cancellations, escalations, complaints, service failures, delayed progression, and quality defects.
- Create executive and operational dashboards focused on delivery success, follow-up compliance, patient engagement, utilization, issue resolution, and revenue-risk indicators.
- Act as a senior analytical advisor to operational leaders and deliver executive-ready dashboards, decision briefs, and presentations.
- 6 years of experience in business intelligence, reporting, analytics, revenue operations, healthcare analytics, call center analytics, data analysis, or a related field.
- Advanced SQL and Excel skills.
- Experience developing dashboards, scorecards, data visualizations, and recurring reporting solutions.
- Strong problem-solving, analytical thinking, and data validation skills.
- Ability to manage multiple priorities, deadlines, recurring reports, and ad hoc analytical requests.
- Strong communication skills with the ability to present insights to operational and leadership audiences.
- Demonstrated ability to identify missing data, define reporting requirements, and partner with stakeholders or vendors to improve data capture.
- Preferred experience in healthcare, DME, revenue cycle, workers' compensation, personal injury, patient access, intake, order management, or call center environments.
- Preferred experience working with vendor platforms and requesting or validating new reporting fields.
- Preferred exposure to Lean, Six Sigma, Continuous Improvement, or similar process improvement methodologies.
- Knowledge of healthcare insurance processes, patient intake workflows, billing operations, post-shipment support, and DME operations.
- Experience with SQL, Tableau, Advanced Microsoft Excel, Power BI, Microsoft Teams, SharePoint, and Microsoft Planner.
Location
Denver, Colorado, US
Employment Type
Full-time
Experience Level
Senior
Salary Range
$100,000 - $100,000
Remote work allowed
No
Posted
4 weeks ago