Senior Analytics Engineer

Transformcap; New York (NY); On-site; USD 90,000 - 120,000; Full time

Job summary

A healthcare technology company in New York is seeking a data analytics professional to lead the development of data models and analytics tools. The role involves building dashboards and collaborating with various teams to utilize data for business decisions. Candidates should possess strong expertise in relational databases, ETL workflows, and business intelligence tools. They should thrive in a fast-paced environment with a mission-driven mindset.

Qualifications

• Advanced expertise with relational databases and data warehouse solutions.
• Strong familiarity with data governance and architecture concepts.
• Experience with business intelligence tools for developing dashboards.

Responsibilities

• Design and build clean, optimized data models and semantic layers.
• Build and maintain dashboards, reports, and analytics tools.
• Work with data engineering on scalable data workflows.

Skills

Relational database expertise

ETL/ELT workflows

Business intelligence tools

Excel analysis

Python scripting

Problem-solving skills

Collaboration mindset

Tools

JavaScript

Airflow

Dimensional modeling

Job description

About Alaffia & Our Mission

Every year, U.S. health plans lose billions to improper payments and administrative waste. That wasted spending ultimately trickles down across the healthcare ecosystem, driving up costs for plans, providers, and patients alike. We’re here to change that paradigm.

Alaffia is a new kind of claims operations partner for health plans. Using expert clinicians and transparent AI, we deliver deeper insights, smarter automation, and consistently better outcomes across the entire lifecycle of claims. With Alaffia, health plans can cut wasted spending more effectively than ever — and provide their members the most affordable care.

We’re a high-growth, venture-backed Series B healthtech startup based in NYC and are actively scaling our company. Join us in helping to build a healthcare system that works better for everyone.

*This position requires current authorization to work in the United States. Unfortunately, we are not in a position to sponsor work visas at this time.

About the Role & What You’ll Be Doing

We’re looking for someone who will lead the charge to build the data and analytics foundation of how Alffia makes business decisions to further grow and expand our footprint in healthcare.

Your Responsibilities

• Full-stack analytics engineering: Design and build clean, optimized data models and semantic layers that translate business requirements and raw data into structured, actionable insights.
• Enable data-driven decision‑making: Build and maintain dashboards, reports, and self‑serve analytics tools with user‑facing data documentation and data ontology and a high standard of data freshness, and accuracy, ensuring teams across the org can easily access the right data to drive business outcomes.
• Develop scalable data workflows: Work closely with our data engineering team to ensure data models and ETL/ELT pipelines are efficient, reliable, repeatable and well‑documented.
• Optimize performance & cost: Continuously refine analytical queries and data transformations to reduce latency, improve efficiency, and manage costs effectively.
• Foster data enablement & collaboration: Work cross‑functionally with commercial, engineering, product, and operations teams to ensure they can leverage data to drive business decisions.
• Establish and maintain reporting SOPs for internal and external needs: including custom report builds, one‑off analyses, and investigations into anomalies or unexpected trends

Key Skills & Qualifications

• Advanced expertise with relational database and data warehouse solutions, with the ability to write and optimize complex queries, build views, and ideally, have experience working with large healthcare claims data sets.
• Proficiency with ELT/ETL workflows for building scalable data pipelines that feed into BI models and reports.
• Strong familiarity with data warehouse governance and architecture, for example, dimensional modeling and warehouse concepts (star/snowflake schemas, slowly changing dimensions, etc.) to ensure data is structured, reliable, and easy to access.
• Experience with implementing, enabling, and using business intelligence tools (e.g., Hex) to develop dashboards and reports for a variety of stakeholders including customers, operational teams, as well as investors.
• Strong attention to detail to ensure the data product is fresh and accurate for informing business decisions.
• Ability to thrive in a fast‑paced, high‑impact environment, balancing technical rigor with business needs.
• Strong problem‑solving and interpersonal skills and a collaborative mindset to work across different teams and functions.
• Comfortable with advanced Excel for analysis, reconciliation, and prototyping reports when needed.
• Working knowledge to build and maintain reports using JavaScript or Python.

Nice To Have

• Experience working in a startup or high‑growth environment, comfortable with ambiguity and evolving requirements.
• Prior work at a payer, health tech company, or healthcare analytics vendor.
• Exposure to EDI formats (e.g., X12 837/835) or other healthcare data standards.
• Proficiency with ELT/ETL workflows for building scalable data pipelines that feed into BI models and reports.
• Experience with scheduling/orchestration tools (e.g., Airflow, Dagster, Prefect).

Our Culture

Alaffia was born out of our founders’ personal connection to the inefficiency of the U.S. healthcare system. We are deeply mission‑driven, with an abiding belief that technology can help create a better future for everyone — and we’re looking for others who share our passion for change to join the team.