Pearl Health
Democratizing access to value in healthcare
Senior Data Analyst, Analytics Engineering
Location
New York + 1 moreAll locations: New York, Massachusetts
Posted
10 days ago
Salary
$105K - $160K / year
Bachelor Degree3 yrs expEnglishAmazon RedshiftAWSBig QueryCloudPythonSQL
Job Description
• 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.
Job 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.
- 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.
Benefits
- We offer a competitive benefits package. More on our careers page.
