Job description

About Lyra Health Lyra Health is a leading provider of evidence-based mental health care, serving more than 20 million people globally in partnership with employers and more than 100 million through health plan and partner relationships. The company has delivered more than 15 million sessions of mental health care, published more than 35 peer-reviewed studies, and delivered unmatched outcomes in terms of access, clinical effectiveness, and cost efficiency. Extensive peer-reviewed research confirms Lyra’s transformative care model helps people recover twice as fast and results in a 26% annual reduction in overall healthcare claims costs. Lyra is transforming access to life-changing mental health care through Lyra Empower, the only fully integrated, AI-powered platform combining the highest-quality care and technology solutions. 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 Lyra is the right place for you if you: 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. Preferred Qualifications 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. " 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. By applying for this position, you acknowledge that your personal information will be processed as per the Lyra Health Workforce Privacy Notice . Through this application, to the extent permitted by law, we will collect personal information from you including, but not limited to, your name, email address, gender identity, employment information, and phone number for the purposes of recruiting and assessing suitability, aptitude, skills, qualifications, and interests for employment with Lyra. We may also collect information about your race, ethnicity, and sexual orientation, which is considered sensitive personal information under the California Privacy Rights Act (CPRA) and special category data under the UK and EU GDPR. Providing this information is optional and completely voluntary, and if you provide it you consent to Lyra processing it for the purposes as described at the point of collection, for example for diversity and inclusion initiatives. If you are a California resident and would like to limit how we use this information, please use the Limit the Use of My Sensitive Personal Information form . This information will only be retained for as long as needed to fulfill the purposes for which it was collected, as described above. Please note that Lyra does not “sell” or “share” personal information as defined by the CPRA. Outside of the United States, for example in the EU, Switzerland and the UK, you may have the right to request access to, or a copy of, your personal information, including in a portable format; request that we delete your information from our systems; object to or restrict processing of your information; or correct inaccurate or outdated personal information in our systems. These rights may be subject to legal limitations. To exercise your data privacy rights outside of the United States, please contact globaldpo@lyrahealth.com . For more information about how we use and retain your information, please see our Workforce Privacy Notice ."

Requirements

Must-haves

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
Lyra is the right place for you if you:
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
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!
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 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).
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.

Nice-to-haves

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.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aipythonsql

Platform: lever
Effort: quick