The Sr. Data Analyst will turn healthcare data into insights, design dashboards, automate reporting, and collaborate cross-functionally to improve analytics frameworks.
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.
Why You Will Love Working Here:
- 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
Ai Tools
Python
SQL
Tableau
Similar Jobs
Big Data • Fitness • Healthtech • Information Technology • Software • Analytics
The Senior Data Analyst will analyze healthcare data, create insights for clients, develop dashboards, and collaborate across teams to improve healthcare delivery.
Top Skills:
AWSDbtLookerPower BIPythonQuick SightRedshiftSnowflakeSQLTableau
Cloud • Security • Software • Cybersecurity • Automation
As a Senior Data Analyst, you will analyze marketing performance, implement multi-touch attribution, and provide insights for strategic decisions.
Top Skills:
Claude With Mcp ConnectionsDbtGitlab Duo Agent PlatformSnowflakeSQLTableau
Fintech • HR Tech • Financial Services
The Senior Data Analyst will collaborate with the executive team to identify opportunities, drive reporting, and provide insights that guide strategic decisions at Addition Wealth.
Top Skills:
AmplitudeBi ToolsMixpanelPythonRSegmentSQL
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
