About MacroHealth:
MacroHealth is a healthcare technology company that operates an intelligent marketplace platform purpose-built to bring transparency, control, and strategic intelligence to healthcare purchasing. The MacroHealth Marketplace Platform connects Payers — including health plans, third-party administrators, and brokers — with a curated ecosystem of Health Market Partners such as provider networks, specialty networks, pharmacy benefit managers, and payment integrity solutions.
Through data-driven tools for network optimization, provider search, price transparency, and performance analytics, MacroHealth helps Payer's design smarter benefit strategies, reduce total cost of care, and meet compliance requirements — all through a single point of integration.
Serving 300+ enterprise clients and 7.2 million members, MacroHealth delivers an average 6–8% reduction in total cost of care and a 4:1 return on investment. With offices in the U.S. and Canada, MacroHealth is a mission-driven company focused on making the healthcare ecosystem more connected, efficient, and transparent.
Position Summary:
The Sr. Data Analyst role will drive measurable impact for MacroHealth clients by turning complex healthcare data into clear, actionable insights. You'll design dashboards, automate reporting workflows, and build scalable analytics frameworks that help internal teams and clients understand business performance across our lines of business. Leveraging advanced SQL, Python, Tableau, and AI-assisted tools, you'll accelerate analysis, surface patterns at scale, and continuously improve the platforms that power our analytics. A collaborative partner by nature, you'll work cross-functionally with data engineers and stakeholders to standardize processes, reduce manual effort, and strengthen MacroHealth's position as a strategic partner to the organizations we serve.
Key Accountabilities:
1. Analytics Delivery & Business Insights:
- Design and develop dashboards and reports tailored to diverse business needs; leverage AI tools to accelerate prototyping and visual storytelling
- Provide on-demand and proactive insights to support operations and decision-making, using AI-assisted analysis to identify patterns and anomalies at scale
- Present analytics and insights to customers and internal stakeholders
2. Data Enablement, Automation & Scalable Reporting:
- Collaborate with data engineers to evaluate, ingest, and validate data sources
- Organize, standardize, and automate existing reports and analytics workflows; apply AI-assisted tools to reduce manual effort and improve consistency
- Develop scalable reporting frameworks and reusable data models to support consistent analytics
3. Platform Excellence & Continuous Improvement:
- Document analytics systems, data flows, and reporting processes
- Stay current with emerging technologies, AI tools, and best practices in data analytics
- Continuously evolve analytics platforms to improve scalability and maturity
Knowledge, Skills and Abilities:
- Advanced SQL expertise (complex joins, performance optimization, analytics use cases)
- Strong experience with Tableau or equivalent BI tools
- Proficiency in Python for data analysis and automation
- Hands-on experience using AI tools (e.g. Copilot, ChatGPT, Claude) to improve productivity and quality of analytical work
- Strong understanding of U.S. healthcare data and workflows (payer, provider, claims, utilization, cost drivers, performance metrics)
- Strong creative problem-solving skills and critical thinking competencies
- Excellent written and verbal communication skills
- Excellent organizational skills and attention to detail
- Ability and willingness to stay on top of current trends and industry knowledge
- Fits in a people-first culture of teamwork and respect
Required Education and Experience:
- 5-7 years of experience in data analytics working with enterprise-scale datasets
- 5+ years of hands-on SQL experience
- Experience working with Python
- 2+ years with Tableau or similar BI platforms
- Direct experience working with U.S. healthcare data is required
- Bachelor’s degree or equivalent practical experience
Preferred Education and Experience:
- Demonstrated use of AI tools (e.g. Copilot, ChatGPT, Claude) in a professional setting, including effective prompt engineering to support data analysis, querying, or reporting workflows
- Strong preference for candidates with Databricks (Spark, Delta Lake, Lakehouse architectures) experience
- Exposure to modern data modelling frameworks and analytics engineering practices
Compensation:
- $135,000 - $145,000 USD annual base salary plus bonus, equity, 401k match, flexible PTO and medical/dental/vision insurance.
- A people-first culture where your work directly shapes how employees experience the company.
- The opportunity to blend technology, compliance, and human connection.
- A mandate — not just permission — to experiment with and implement AI, with real influence over how we evolve our tools and ways of working.
- A chance to experiment with AI and automation to elevate efficiency and insight.
- Collaborative team that believes in continuous improvement.
- Direct impact on strategic growth and enterprise value creation.
- Executive-level visibility and influence.
- Opportunity to architect and build at scale.
- Competitive compensation package including base salary, bonus, equity, comprehensive benefits, and flexible work options.
- Mission-driven culture modernizing healthcare.
Guided by a shared vision, MacroHealth unites around a strong set of values our team embodies every day.
We Are One Team:- We act as one team with our fellow MacroMates and customers
- We value humility, low ego, and collaboration
- We are All for One, One for All
- We do the right thing
- We do what we say we will do
- We do it with a sense of urgency and transparency
- We challenge ourselves to think boldly, bigger, and into the future
- We lead with a growth mindset
- We act as a thought leader for the healthcare industry
MacroHealth is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
