Sr. Data Engineer II
TrueMLSalary not specified
- Full Time
- Senior (5 to 8 years)
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Healthcare, Mental Health, Data & AnalyticsIndustries
Requirements
Candidates should 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. They should possess advanced SQL skills, with proven experience in writing complex, performant queries and optimizing them in a data warehouse environment like Redshift. 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 is required. 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 is necessary, as is demonstrable expertise in data modeling, data transformation, and ensuring data quality and reliability in production systems. Experience with dbt is highly desirable, and familiarity with BI tools (e.g., Looker, Metabase) is a plus.
Responsibilities
The Senior Analytics Engineer II will design, build, and optimize data models and queries to transform raw data into useful, actionable, and performant business metrics. They will 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. This role involves optimizing and maintaining the data warehouse (Redshift) for performance, scalability, and reliability, proactively identifying, diagnosing, and resolving data quality, reliability, and performance issues across the data lifecycle. The Senior Analytics Engineer II will 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, and partner with the data team and cross-functional stakeholders to understand evolving business needs, prioritize data initiatives, and contribute to the data strategy. They will also contribute to the design and implementation of testing frameworks and monitoring solutions for data pipelines.
Skills
Data Modeling
SQL
Python
ETL/ELT
Data Pipeline Architecture
Redshift
Data Quality
Performance Optimization
Alma
Digital platform connecting clients with therapists
About Alma
Alma connects individuals seeking mental health services with a variety of therapists through its digital platform, helloalma.com. The platform primarily serves clients looking for therapy for issues like anxiety, depression, personal growth, and relationship challenges. Alma's approach focuses on making therapy more affordable by partnering with insurance companies, allowing clients to save an average of 77% on therapy costs. This affordability is a key aspect that sets Alma apart from other mental health services. Additionally, Alma supports therapists by offering resources for continuing education and professional development, ensuring they are well-prepared to assist their clients. The company emphasizes the importance of the client-therapist relationship, aiming to match clients with therapists who best meet their individual needs. Alma operates on a membership model, where therapists pay a fee to access the platform's resources and client base.
New York City, New YorkHeadquarters
2018Year Founded
$214.5MTotal Funding
SERIES_DCompany Stage
HealthcareIndustries
1,001-5,000Employees