Principal Data Analyst

MacroHealth; Kirkland (WA); On-site; USD 140,000 - 200,000; Full time

Job summary

MacroHealth seeks a Principal Data Analyst to partner with the Product triad and steward the Data Foundation within the One Marketplace vision. You will own end-to-end analytical workstreams, translate complex healthcare data into actionable insights, and drive data quality and lineage across the Databricks environment.

You will lead collaborations with senior leadership, mentor analysts, and ensure data supports product decisions and strategic direction.

Qualifications

• 8+ years of progressive analytical experience in data-rich environments.
• Deep fluency in SQL and experience with Databricks and Delta Lake / Unity Catalog.
• Strong knowledge of healthcare claims data (medical/pharmacy) and related financial fields.
• Ability to own large, ambiguous analytical problems with minimal direction.
• Excellent communication skills for technical and non-technical audiences.

Responsibilities

• Partner with Product Manager, UI/UX Designer, and data teams to ground product decisions in data reality.
• Translate healthcare data structures (claims, invoicing) into clear, actionable insights.
• Own end-to-end analytical workstreams from framing to delivery, including reporting product performance.
• Develop and maintain gold-standard analytical frameworks for the team.
• Mentor the Reporting & Analytics team and influence data strategy with senior leadership.

Skills

SQL

Databricks

Delta Lake

Unity Catalog

Healthcare claims data

Data quality

Data lineage

Communication

Tools

Databricks

Unity Catalog

Delta Lake

Job description

MacroHealth is entering a pivotal transformation — advancing toward the One Marketplace vision: a unified, intelligent platform for healthcare data exchange where payers, providers, and partners can transact with clarity and confidence. Underpinning that vision is the Data Foundation, our medallion-architecture Databricks environment that governs how data is ingested, validated, and made available across the business.

The Principal Data Analyst is a newly established Individual Contributor role at the center of that strategy. This person sits within the Product triad — alongside the Product Manager and UI/UX Designer — and carries a dual mandate: to be a rigorous analytical thought partner on product decisions, and to serve as the steward of the Data Foundation as it continues to evolve.

MacroHealth's data is a high-value strategic asset. The Principal Data Analyst is responsible for protecting, developing, and leveraging that asset — ensuring data quality, lineage, and integrity are held to the standard the One Marketplace vision demands.

The right candidate brings deep institutional knowledge of healthcare claims data, strong analytical instincts, and the organizational credibility to influence how data is treated — not just reported on — across the company.

What You'll Do:

PRODUCT PARTNERSHIP

• Serve as the data voice within the Product triad (Product Manager, UX Designer, Principal Data Analyst) — ensuring product decisions are grounded in data reality
• Partner with UX on data-driven design: surface patterns, identify edge cases, and validate assumptions before and after build
• Translate complex healthcare data structures (claims, pharmacy, invoicing) into clear, actionable insights for product and design collaborators
• Participate actively in discovery, prioritization, and roadmap discussions — not as a downstream consumer of requirements, but as a co-author

ANALYTICAL LEADERSHIP

• Own end-to-end analytical workstreams from question framing through delivery — including invoicing analytics, claims data quality, and reporting product performance
• Develop and maintain gold-standard analytical frameworks that other analysts build from
• Identify opportunities for semi-automation, consolidation, and improved data reliability across MacroHealth, FPS, and Clear Cost Health reporting
• Conduct deep-dive analyses on complex, ambiguous problems where the answer isn't known in advance

DATA FOUNDATION STEWARDSHIP & PLATFORM STANDARDS

• Act as the primary steward of the MacroHealth Data Foundation — championing its continued development as the backbone of the One Marketplace platform and a high-value strategic asset
• Operate fluently across the Databricks / Unity Catalog environment (prod_z1), applying and enforcing medallion architecture principles (Bronze → Silver → Gold)
• Define and uphold data quality standards: own how healthcare financial fields (allowed amounts, fee structures, adjustments) are modeled, validated, and governed
• Maintain and extend understanding of end-to-end data lineage — how data enters MacroHealth systems, how it transforms, and how it is consumed across reporting and product surfaces
• Protect data integrity as the organization scales, ensuring the Data Foundation can support new products, new markets, and new partners without quality degradation

MENTORSHIP & INFLUENCE

• Mentor and elevate the analytical capabilities of the broader Reporting & Analytics team — without formal management responsibility
• Act as a thought partner to senior leadership on data strategy, analytical infrastructure, and insight delivery
• Represent the data perspective in cross-functional conversations, helping non-technical stakeholders understand what the data can and cannot support

What You Bring:

REQUIRED

• 8+ years of progressive analytical experience, with at least 2 years at Senior or Lead level in a data-rich environment
• Deep fluency in SQL; experience with Databricks and Delta Lake / Unity Catalog strongly preferred
• Strong working knowledge of healthcare claims data — medical and/or pharmacy — including ICD-10, CPT, NCPDP, and related financial fields
• Demonstrated ability to own large, ambiguous analytical problems with minimal direction
• Strong communication skills: able to present analytical findings to technical and non-technical audiences with equal clarity{