Data & Reporting Analyst

Job Title: Data & Reporting Analyst


Location : Southfield, MI (Fully in-person)

Job type : Full Time

Role Summary


The Data & Reporting Analyst is responsible for transforming complex operational, clinical, and financial data into clear, actionable insights that drive decision-making. This role requires deep expertise in Excel and experience working with healthcare reporting systems, with Athena reporting experience preferred. The analyst serves as a trusted partner to operations and leadership by owning reporting accuracy, performance analysis, and insight generation across the organization.


Key Responsibilities


Reporting & Analytics

• Design, build, and maintain standardized and ad-hoc reports using advanced Microsoft Excel techniques, including pivot tables, advanced formulas, Power Query, and data models.
• Analyze operational, clinical, and financial datasets to identify trends, risks, gaps, and opportunities.
• Ensure data accuracy, integrity, and consistency across all reporting outputs.
• Develop recurring reports to support leadership, operations, and performance management needs.

Performance Monitoring

• Track and monitor key performance indicators (KPIs), service-level agreements (SLAs), and operational thresholds.
• Identify drivers of performance variance and surface root causes.
• Support development and maintenance of scorecards, dashboards, and executive summaries.
• Proactively flag performance risks, outliers, and negative trends.

Data Interpretation & Storytelling

• Translate complex data into clear, concise narratives that explain performance and operational impact.
• Provide actionable insights and recommendations alongside reports.
• Partner with operational leaders to contextualize data and align insights with workflows and business processes.
• Support leadership decision-making by answering the "why," not just reporting the "what."

Process Improvement & Automation

• Identify opportunities to automate, standardize, and improve reporting processes.
• Reduce manual reporting effort and improve timeliness and scalability of reporting outputs.
• Support continuous improvement initiatives by supplying accurate, timely, and relevant performance insights.
• Document report logic, definitions, assumptions, and data sources.

Collaboration & Stakeholder Support

• Collaborate with operations, clinical leadership, finance, and project teams to understand reporting needs and priorities.
• Respond to ad-hoc data requests from leadership with clarity and urgency.
• Serve as a subject matter expert for Excel-based reporting and performance analytics.
• Maintain strong working relationships across departments to ensure alignment and trust in reporting.

Required Qualifications

• 10+ years of advanced Microsoft Excel experience, including pivot tables, advanced formulas (XLOOKUP, INDEX/MATCH, nested logic), Power Query, and large dataset management.
• Bachelor's degree in Business, Analytics, Finance, Healthcare Administration, or related field.
• Experience building, maintaining, and analyzing complex operational and performance reports.
• Athena reporting experience preferred, including operational, clinical, or financial reporting.
• Strong analytical and problem-solving skills with exceptional attention to detail.
• Ability to translate complex data into actionable insights for non-technical stakeholders.
• Excellent written and verbal communication skills.

Key Competencies

• Expert-level Excel and reporting analytics
• Data interpretation and storytelling
• Healthcare operations and performance analysis
• KPI and SLA tracking
• Process improvement and reporting automation

Success in This Role Looks Like

• Reports are accurate, standardized, and trusted by leadership.
• Excel-based reporting supports timely and informed decision-making.
• Performance risks and opportunities are identified early and clearly communicated.
• Athena data is effectively leveraged to support operational insights.
• Reporting processes are efficient, scalable, and continuously improving.