Senior Analytics Engineer II

Summary

Join Alma, a company simplifying access to affordable mental healthcare, as a Senior Analytics Engineer II. You will play a key role in designing, building, and optimizing Alma’s data systems, transforming raw data into actionable business metrics. This involves leading data pipeline development using Python, optimizing the data warehouse (Redshift), ensuring data quality, and collaborating with stakeholders. You will also champion data governance best practices and contribute to the overall data strategy. Alma offers a remote-first work environment and a comprehensive benefits package. The ideal candidate possesses 5+ years of experience in data engineering or analytics engineering, advanced SQL skills, and expertise in data warehousing and Python.

Requirements

• 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
• 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

Responsibilities

• 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

Preferred Qualifications

Experience with dbt is highly desirable; familiarity with BI tools (e.g., Looker, Metabase) is a plus

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