Data Analytics Engineer

Pelago is the world’s leading virtual clinic for Substance Use Management, providing guidance and treatment for members seeking to overcome substance use issues. The Analytics Engineer role involves building scalable data models and ensuring data quality for analytics across the company.

Responsibilities:

• Build the foundation for analytics
• Design, build, and maintain scalable dbt models for analytics and reporting
• Develop modular, well-documented transformation logic in Redshift
• Optimize performance and maintainability of transformation pipelines
• Implement testing, validation, and observability standards to ensure data quality
• Translate ambiguous business requirements into structured, reusable data models
• Define and maintain standardized KPIs and metric logic
• Own and evolve Pelago’s semantic layer to ensure consistency across teams
• Build reusable data marts for dashboards, experimentation, ROI analysis, and AI workflows
• Reduce metric inconsistencies and reporting fragmentation
• Work closely with Data Engineering to ensure reliable upstream pipelines
• Collaborate with Product, Clinical, Client Success, Finance, and Growth teams
• Support Data Analysts with clean, analysis-ready datasets
• Contribute to documentation, data governance, and analytics best practices
• Structure data for experimentation, personalization, ROI measurement, and AI initiatives
• Prepare datasets for downstream data science and machine learning workflows
• Identify opportunities to improve analytics velocity through better modeling and abstraction

Requirements:

• 3+ years of experience in analytics engineering, data analytics, or data modeling
• Advanced SQL skills and experience building production-grade data models
• Strong understanding of data warehousing concepts and dimensional modeling
• Experience with dbt and analytics engineering best practices
• Experience working in a modern data stack (Redshift, Snowflake, or similar)
• Proven ability to translate business needs into scalable data solutions
• Experience working in cross-functional, agile environments
• Experience with Looker or similar BI tools and semantic layer design
• Familiarity with healthcare data or regulated environments
• Experience supporting experimentation, ROI measurement, or product analytics
• Exposure to AI/ML data preparation or feature-ready modeling
• Experience implementing data quality testing and observability frameworks