Senior Analytics Engineer II

Alma Mental Health; United States; Remote; USD 175,000 - 190,000; Full time

Job summary

Alma Mental Health is seeking a Senior Analytics Engineer to lead the design and optimization of data systems for organizational insights. The role involves developing ETL processes, ensuring data quality, and supporting data governance, contributing to better mental health care access. Join a remote-first company committed to improving therapy experiences for providers and clients.

Benefits

Health insurance plans through Aetna

401K plan

Monthly therapy and wellness stipends

Flexible PTO

Comprehensive parental leave plans

Monthly work-from-home stipend

11 paid holidays

Qualifications

• 5+ years of experience in data engineering or analytics engineering.
• Advanced SQL skills; experience in writing complex queries.
• Strong Python experience for ETL processes.

Responsibilities

• Design and optimize data models and queries.
• Lead the development of the data pipeline architecture.
• Collaborate with stakeholders to define data requirements.

Skills

Python

SQL

Data Warehousing

Data Modeling

ETL/ELT

Data Quality

Tools

Redshift

dbt

Singer.io

Job description

Alma is on a mission to simplify access to high-quality, affordable mental health care. We do this by making it easy and financially rewarding for therapists to accept insurance and offer in-network care. When a provider joins Alma, they gain access to a suite of tools that not only help them better run their business, but also grow it sustainably and develop as a provider. Alma is available in all 50 states, with over 20,000 therapists in our growing network. Anyone looking for a therapist can browse Alma’s free directory. Alma has raised $220.5M in funding from Insight Partners, Optum Ventures, Tusk Venture Partners, Primary Venture Partners, First Round Capital, Sound Ventures, BoxGroup, Cigna Ventures, and Rainfall Ventures. Alma was also named one of Inc’s Best Workplaces in 2022 and 2023.

Website Job Board Values Candidate Interview Guide Senior Analytics Engineer II

Alma is seeking a mission-oriented Senior Analytics Engineer to join our team. This person will take a leading role in designing, building, and optimizing Alma’s information systems that collect, manage, and convert raw data into business metrics for use by analysts and stakeholders across the company. This person will play an integral role in making performant and reliable data accessible to the organization so it can evaluate and operate effectively and successfully.

What you’ll do:

• Design, build, and optimize data models and queries to transform raw data into useful, actionable, and performant business metrics.
• Lead the development and enhancement of Alma’s data pipeline architecture, leveraging Python for custom ETL/ELT processes, including the creation and maintenance of Singer taps and other data ingestion solutions.
• Optimize and maintain our data warehouse (Redshift) for performance, scalability, and reliability.
• Proactively identify, diagnose, and resolve data quality, reliability, and performance issues across the data lifecycle.
• Collaborate with stakeholders to define requirements and implement robust processes for ingesting data from diverse internal and external sources.
• Champion and implement data governance best practices and ensure compliance with data policies.
• Partner with the data team and cross-functional stakeholders to understand evolving business needs, prioritize data initiatives, and contribute to the data strategy.
• Contribute to the design and implementation of testing frameworks and monitoring solutions for data pipelines.

Who you are:

• You have 5+ years of progressive experience in data engineering or analytics engineering, with a strong emphasis on building and optimizing data pipelines and data warehouses.
• You possess advanced SQL skills, with proven experience in writing complex, performant queries and optimizing them in a data warehouse environment like Redshift.
• You have a deep understanding of data warehousing concepts (e.g., dimensional modeling, ETL/ELT patterns) and extensive hands-on experience with data warehouse technologies, particularly Redshift, including performance tuning and optimization.
• You have strong, hands-on experience with Python for data engineering, including developing custom ETL/ELT scripts, working with data pipeline frameworks (e.g., Singer.io), and interacting with APIs.
• You have demonstrable expertise in data modeling, data transformation, and ensuring data quality and reliability in production systems.
• Experience with dbt is highly desirable; familiarity with BI tools (e.g., Looker, Metabase) is a plus.
• You are passionate about building scalable, maintainable, and production-ready data solutions.
• You feel a passion for Alma's mission – to improve the experience of therapy for providers and their clients and simplify access to care.

Tech Stack: Python, SQL, Redshift, dbt, Singer.io; (Familiarity with: Stitch, Lightdash, Metabase, Hightouch)

Benefits:

• We’re a remote-first company
• Health insurance plans through Aetna (medical and dental) and MetLife (vision), including FSA and HSA plans
• 401K plan (ADP)
• Monthly therapy and wellness stipends
• Monthly co-working space membership stipend
• Monthly work-from-home stipend
• Financial wellness benefits through Northstar
• Pet discount program through United Pet Care
• Financial perks and rewards through BenefitHub
• EAP access through Aetna
• One-time home office stipend to set up your home office
• Comprehensive parental leave plans
• 11 paid holidays, 1 Alma Mental Health Day, and 1 Alma Volunteering Day
• Flexible PTO

Salary Band: $175,000 - $190,000

Alma’s compensation philosophy is driven by our company value of building equity. To best ensure pay equity, we typically bring in new hires near the middle of our listed salary bands and we do not negotiate our compensation (i.e. all people hired at the same level & role are brought in at the same salary, equity, and benefits). The recruiter you work with can provide more details on our philosophy.

All Alma jobs are listed on our careers page. We do not use outside applications or automated text messaging in our recruiting process. We will not ask for any sensitive financial or identification information throughout the recruiting process. Any communication during the recruitment process, including interview requests or job offers, will come directly from a recruiting team member with a helloalma.com email address.

Learn more about how Alma handles applicant data by reading Alma'sApplicant Privacy Notice.