Data & Reporting Analyst

Southfield, MI - USA

Monthly Salary: Not Disclosed

Posted on: 23 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Title: Data & Reporting Analyst

Location: Southfield MI (Fully in-person)

Job type: Full Time

Role Summary

The Data & Reporting Analystis responsible fortransforming complex operational clinical and financial data into clear actionable insights that drive decision-making. This role requires deepexpertisein 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.
Bachelors 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.

Required Experience:

Job Title: Data & Reporting AnalystLocation: Southfield MI (Fully in-person)Job type: Full TimeRole SummaryThe Data & Reporting Analystis responsible fortransforming complex operational clinical and financial data into clear actionable insights that drive decision-making. This role requires deepexpe...