Senior Data Analyst, Analytics Engineering

Pearl Health • New York, NY

19h • $105,000 - $160,000

About The Position

As a Senior Data Analyst at Pearl, you will bridge the gap between raw data and business value by designing and maintaining the trusted data models that power critical decisions across clinical outcomes and P&L. You have spent time "in the trenches" as a Data Analyst or BI Engineer—you don't just build models to be "correct"; you build them to be usable, understanding how downstream users in BI Tools will interact with your work. You will partner with Data Science, Product, and Engineering to architect a self-service data environment. Rather than just answering ad-hoc queries, you will codify business logic into clean, documented datasets that empower the entire organization to explore practice engagement, patient spend, and network analytics with confidence. You will drive team best practices by managing pull requests, conducting rigorous code reviews, and maintaining documentation within a Git-based workflow, applying software engineering principles—like automated testing and CI/CD—to ensure our pipelines are robust and scalable.
Who we are. . .
Pearl Health is powering the future of healthcare. We help primary care providers and organizations to deliver quality healthcare to the patients who need it most, when they need it most — and get rewarded for keeping patients healthy.
Our technology, services, and financial tools enable better, more proactive care, decrease total cost of care across patient panels, and optimize performance in value-based care models for Traditional Medicare and Medicare Advantage.
We are a team of physicians and public health experts (Stanford, Harvard, Mount Sinai), technologists (athenahealth, Amazon, Meta, Flatiron), healthcare innovators (Centivo, Aledade, Stellar, Arcadia), and experienced risk management professionals (CVS/Aetna, Humana, Oscar) who believe that primary care providers are the key to addressing our healthcare system’s biggest challenges.
Since its founding in 2020, Pearl has expanded to partner with thousands of primary care providers in practices and organizations across 44 states. Our investors include Andreessen Horowitz, Viking Global Investors, AlleyCorp, and SV Angel.
What Senior Data Analyst means to us
Partner with our technical lead to design flexible and scalable data models that capture the ontological relationships of our healthcare data, balancing immediate business needs with long-term architectural health.
Translate complex company goals into governed, reusable data models in dbt and Snowflake, serving as the "source of truth" for downstream BI tools (Hex).
Execute the design and development of robust data transformation pipelines. You will focus on modularity, performance optimization, and maintainability, ensuring our data assets scale with our data volume.
Move beyond simple schema design by implementing automated testing (data freshness, schema validation, null checks) and observability. You will ensure that stakeholders trust the data implicitly.
Partner with Data Engineering to define ingestion requirements and with Product/Customer Success to scope analytical needs, turning vague business problems into concrete technical requirements.
Collaborate with technical lead to identify technical debt and architectural opportunities, proposing solutions that align our data infrastructure with our 6-month OKRs.

Requirements

• Bachelor's or Master's degree in a quantitative field (e.g., Statistics, Mathematics, Computer Science, Economics, or related field).
• 3-5 years of experience in delivering analytics across the data pipeline: data ingestion, data architecture/schema design (including dimensional modeling), data transformation, data analysis, and reporting data to business stakeholders (including data visualization)
• Proven track record building end-to-end data transformations for business stakeholders; direct experience using DBT and cloud-based warehousing (e.g., Snowflake, BigQuery, or Redshift) is required.
• Demonstrated ability to design data schemas that maximize dataset utility by analyzing input data, understanding business and technical needs, and structuring staging tables, functional data marts, or conceptual data marts to capture ontological relationships.
• Advanced proficiency in SQL (comfortable with window functions, CTE organization for readability, and performance optimization) with a track record of working with legacy logic and migrating it to a standardized framework. Python proficiency for data manipulation is a plus but not required.
• Excellent communication, presentation, and facilitation skills, with the ability to explain complex concepts clearly and concisely.
• Familiarity with AWS cloud architectures.

Nice To Haves

• Healthcare or insurance experience, and/or experience working in a startup is preferred.
• Thoughtful collaborator with a passion for building analytical systems while balancing the tradeoffs between speed and thoroughness in development and scalability.

Responsibilities

• Partner with our technical lead to design flexible and scalable data models that capture the ontological relationships of our healthcare data, balancing immediate business needs with long-term architectural health.
• Translate complex company goals into governed, reusable data models in dbt and Snowflake, serving as the "source of truth" for downstream BI tools (Hex).
• Execute the design and development of robust data transformation pipelines. You will focus on modularity, performance optimization, and maintainability, ensuring our data assets scale with our data volume.
• Move beyond simple schema design by implementing automated testing (data freshness, schema validation, null checks) and observability. You will ensure that stakeholders trust the data implicitly.
• Partner with Data Engineering to define ingestion requirements and with Product/Customer Success to scope analytical needs, turning vague business problems into concrete technical requirements.
• Collaborate with technical lead to identify technical debt and architectural opportunities, proposing solutions that align our data infrastructure with our 6-month OKRs.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level