Sr. Data Engineer

Lyrahealth; United States; On-site; USD 120,000 - 150,000; Full time

Job summary

Lyrahealth is seeking a talented Sr. Data Engineer to build and scale the data infrastructure that powers our analytics and research platforms. Your work will significantly impact mental health care quality.

The ideal candidate is passionate about data and has at least 4 years of experience in engineering data solutions, expertise in Python and SQL, alongside strong skills in modern data tools like Snowflake and Apache Airflow.

This role offers robust opportunities for growth, collaboration across teams, and the chance to foster positive changes in people’s lives.

Qualifications

• 4+ years of experience as a Data Engineer.
• Proven track record of writing high-quality, production-ready Python.
• Expertise in SQL-based data modeling and transformation frameworks.
• Strong experience with modern ingestion tools and ELT pipelines.
• Hands-on experience building robust, fault-tolerant pipelines using Apache Airflow.
• Experience with Snowflake Cloud Data Warehouse Architecture.
• Strong foundational knowledge of relational databases and data warehousing principles.

Responsibilities

• Join a team of innovative engineers building core data infrastructure.
• Design and implement a robust data warehouse.
• Develop and maintain efficient data pipelines.
• Write code every day!

Skills

Python

SQL

Data modeling

Data governance

Apache Airflow

Data pipelines

Data visualization

Snowflake

Data quality assurance

DevOps

Tools

Fivetran

Airbyte

Tableau

Terraform

Job description

About the Role:

We are looking for an exceptional Sr. Data Engineer to join our team and help shape the future of mental health care. We care deeply about making a difference in people's lives, and we hope that you do too!

At Lyra Health, data is not just a byproduct of the business, it powers the analytics and research platforms that drive product development and measure life‑changing clinical outcomes. As a critical pillar of Lyra's data strategy, you will build and scale our data enterprise that empowers our teams to make better decisions and our patients to live happier, healthier lives.

To thrive in this role, you should be enthusiastic about taking ownership of your work, spearheading cross‑functional projects, and providing guidance and mentorship to other members of the team.

Why Lyra?

• Thrive on working with brilliant teammates to solve complex, meaningful problems
• Are passionate about making a social impact and supporting people at their most challenging moments
• Enjoy cross‑functional collaboration with physicians, therapists, data scientists, data analysts and product managers

Responsibilities

• Join a team of innovative engineers building and scaling the core data infrastructure, pipelines, and services that power our products
• Design and implement a robust data warehouse to support a wide range of analytics and operational use cases
• Develop and maintain efficient data pipelines and curated data sets by working closely with stakeholders to gather requirements and translate them into technical solutions
• And of course—write code every day!

Qualifications

• 4+ years of experience as a Data Engineer
• Proven track record of writing high‑quality, production‑ready Python and delivering impactful, scalable data projects
• Expertise in SQL‑based data modeling and transformation frameworks (e.g. dbt), with a focus on schema management, performance, and data governance
• Strong experience with modern ingestion tools: configuring, deploying on data integration platforms (e.g. Airbyte), commercial ELT pipelines (e.g. Fivetran), and database replication methods like Change Data Capture (CDC)
• Strong orchestration background: hands‑on experience building robust, fault‑tolerant pipelines using Apache Airflow (including custom alerting, advanced logging, and automated retry mechanisms)
• Experience with modern data visualization and analytics tools such as Sigma or Tableau
• Strong knowledge of Snowflake Cloud Data Warehouse Architecture, including native ingestion patterns (e.g. Snowpipe for continuous streaming) and open table formats (e.g. Apache Iceberg)
• Strong knowledge of Snowflake administration including familiarity with maintaining security compliance, role based access control (RBAC), external authentication methods, and managing downstream data consumption in external platforms
• A "QA-First" engineering mindset: strong experience in end‑to‑end data quality assurance, regression testing, and data validation, capable of troubleshooting data discrepancies, and performance‑tuning complex pipelines
• Strong foundational knowledge of relational databases, core data warehousing principles, and dimensional modeling techniques
• Experience working with sensitive data (such as PII/PHI) within healthcare or similarly regulated environments, implementing robust data masking or redaction processes
• Familiarity with DevOps principles and infrastructure automation using Terraform
• A thoughtful approach to balancing high‑quality engineering standards with tight deadlines
• Excellent communication skills with a talent for building consensus and distilling complex technical problems into clear, actionable business priorities

Equal Opportunity Statement

We are an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex (including pregnancy), national origin, age, disability, genetic information or any other category protected by law.