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 to create a modern People function.
- 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.
Top Skills
What We Do
MacroHealth's mission is to make buying and selling healthcare services simple and powerful. We provide a Marketplace-as-a-Service that enables Payers, Providers, and Health Market Partners to Optimize and Connect their unique healthcare ecosystems. Our Optimization solutions provide analytics and connectivity focused on optimizing healthcare pricing and payments. We provide health Payers with data enhancement, analytical tools, and market benchmarking to design Provider network solutions that are optimized for each unique member group. With our Connect solutions, a single EDI/API implementation can connect our clients with their chosen Providers, Provider Networks and industry Partners. Our team has a vision to create Intelligent Health Markets that dramatically improve healthcare cost, quality and access for everyone.
.png){kind=logo}
