Senior Data Engineer

Overview

At Life Stance Health, we strive to help individuals, families, and communities with their mental health needs. Everywhere. Every day. It’s a lofty goal; we know. But we make it happen with the best team in mental healthcare.

Thank you for taking the time to explore a career with us. As the fastest growing mental health practice group in the country, now is the perfect time to join our team!

• Belonging:
  We cultivate a space where everyone can show up as their authentic self.

• Empathy:
  We seek out diverse perspectives and listen to learn without judgment.

• Courage:
  We are all accountable for doing the right thing - even when it's hard - because we know it's worth it.

• One Team:
  We realize our full potential when we work together towards our shared purpose.

As a full-time employee of Life Stance Health, the following benefits are offered: medical, dental, vision, AD&D, short and long-term disability, and life insurance. Additional benefits include a 401k retirement savings with employer match, paid parental leave, paid time off, holiday pay and an Employee Assistance Program.

The Senior Data Engineer will play a key role in building, maintaining, and optimizing cloud-based data solutions that support data-driven decision-making s role requires expertise in AWS data services (Glue, Redshift, Lambda, S3, Kinesis), SQL, Python, Apache Spark, and Postgre

SQL, with a focus on scalability, performance optimization, and real-time processing.

You will work closely with data analysts, business intelligence teams, and software engineers to ensure data integrity, governance, and efficiency, while also serving as a production support lead for troubleshooting and maintaining high availability of our data infrastructure.

$110,/annually, plus annual bonus potential

• Scalable Data Infrastructure – Design and optimize AWS-based data pipelines for structured and unstructured data processing.

• Real-time & Batch Processing – Develop robust ETL/ELT pipelines leveraging Apache Spark, AWS Glue, and Kinesis.

• Production Support & Issue Resolution – Lead real-time monitoring, troubleshooting, and optimization of data pipelines.

• Data Warehousing & Performance Optimization – Optimize Postgre
  
  SQL, Redshift, and S3-based data lakes for high performance.

• Cost-efficient Data Engineering – Improve cost-efficiency and scalability of cloud data infrastructure.

• Data Governance & Compliance – Implement security, compliance, and governance frameworks aligned with HIPAA, GDPR, and SOC
  2.

Production Support & Issue Resolution

• Provide primary data engineer for real-time production support, ensuring minimal downtime of mission-critical data pipelines. Rotate the role and on call requirements.

• Monitor, troubleshoot, and optimize data pipeline failures, query performance bottlenecks, and data discrepancies using AWS Cloud Watch, Redshift, and Postgre
  
  SQL.

• Automate Root Cause Analysis (RCA) reporting, reducing resolution time by 30%+ through proactive alerting and system monitoring.

• Implement best practices in IAM roles, encryption, and regulatory compliance (HIPAA, GDPR) to ensure data security and governance.

• Design, develop, and maintain scalable ETL pipelines using AWS Glue, Lambda, Redshift, S3, and Postgre
  
  SQL.

• Optimize query performance through partitioning, indexing, query tuning, and materialized views, achieving significant performance improvements.

• Implement CI/CD pipelines for automated deployments using AWS Code Pipeline, Terraform, and Cloud Formation to improve system stability and deployment efficiency.

• Support streaming data pipelines using Kafka, Kinesis, or Spark Streaming for real-time data ingestion and processing.

• Assist in scaling, performance tuning, and automation to optimize data platform efficiency.

• Collaborate with business intelligence teams and analysts to develop high-quality data models that support analytics and decision-making.

• Build interactive dashboards and reports using Power BI, Tableau, or Looker to enable real-time insights for stakeholders.

• Automate…