Analytics Engineer II

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    ---  Analytics Engineer II Alma is seeking a mission-oriented Analytics Engineer to join our team. This person will work to build out and maintain Alma’s information systems that collect, manage and convert raw data standardized models for use by analysts and stakeholders across the company.  This person will play an integral role in making data accessible to the organization so it can evaluate and operate effectively and successfully. What you’ll do: Build models and queries to transform data into standardized formats that power our business analytics. Maintain and develop Alma’s data pipeline architecture 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. Implement data governance best practices and ensure compliance with data policies. Work with the data team and cross-team stakeholders to evaluate the priorities and needs of the company.   Who you are: You have 3+ 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 strong understanding of data warehousing and business intelligence tools. Experience with dbt is highly desirable; familiarity with BI tools (e.g., Looker, Metabase) is a plus. You enjoy exploring data sets and have technical expertise in data transformation and data modeling. You have some experience with Python 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) 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) Lifestyle Spending Account for health, wellness, and family care 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 PerkSpot EAP access through Aetna One-time home office stipend to set up your home office Inclusive family and medical leave plans 12 paid holidays and 1 Alma Give Back Day Flexible PTO  Salary Band: $124,600- $160,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's Applicant Privacy Notice.