Senior Analytics Engineer: AI-Driven Data & BI

Pelago; New York (NY); Presencial; USD 165.000 - 185.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Equity package

Full Medical, Dental, & Vision

401k Plan

Unlimited PTO

10 paid holidays

Parental leave

Flexible working environment

Learning and Development stipend

Wellness Reimbursement Program

Reproductive & Family Planning Care

Substance Use Support

Descripción de la vacante

Pelago, a leading substance use care and mental health provider, seeks an Analytics Engineer to design scalable data models and reusable assets. You will own dbt models, establish semantic definitions, and partner with Commercial, Marketing, and Health Services to deliver analysis-ready data for dashboards and experiments.

You will collaborate with Data Engineering and Product, promoting rigorous testing, clean lineage, and DRY practices.

Formación

• 5+ years in analytics engineering, BI, data analytics, or data modeling.
• Expert SQL and fluency with dbt, Git, and the full analytics development lifecycle, with software engineering discipline: DRY code, meaningful tests, and clear lineage.
• Strong data modeling and warehousing fundamentals, including clean, well-documented tables with clear grain that work for both analysts and AI.
• Experience building and governing metric definitions through a semantic layer, in partnership with analysts, data engineers, and product teams.
• A track record of turning business needs into models and dashboards that stakeholders actually use.
• Hands-on experience building AI-driven workflows or skills.
• Comfort operating autonomously while things change.

Responsabilidades

• Build and maintain dbt models in Redshift, designed from the business need backward rather than from the raw data forward.
• Apply software engineering practices to our transformation layer: DRY code, meaningful tests, clear lineage, and documentation.
• Turn ambiguous questions from our Commercial, Marketing, and Health Services teams into reusable data models and dashboards, built for both analysts and AI.
• Define and govern consistent metrics through our semantic layer, and keep testing whether they're still the right way to look at the business.
• Support experimentation and campaign measurement so we know what's working and why.
• Partner with Data Engineering and Product to understand source data, and with analytics peers to deliver analysis-ready data.
• Build reusable AI-driven workflows that change how the data team works.
• Find and fix problems in the data before they become problems in the business.

Conocimientos

Analytics engineering

SQL proficiency

AI-driven workflows

Autonomy

Data modeling

Semantic layer knowledge

Analytics lifecycle

Herramientas

dbt

Git

Looker

Cube

Descripción del empleo

Pelago, a leading substance use care and mental health provider, seeks an Analytics Engineer to design scalable data models and reusable assets. You will own dbt models, establish semantic definitions, and partner with Commercial, Marketing, and Health Services to deliver analysis-ready data for dashboards and experiments.

You will collaborate with Data Engineering and Product, promoting rigorous testing, clean lineage, and DRY practices.