Job Description
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.
