9 days ago
Base Salary
$165k - $185k/yr
Responsibilities
- Build and maintain dbt models in Redshift based on business needs.
- Apply software engineering practices including DRY code, meaningful tests, lineage, and documentation to the transformation layer.
- Translate ambiguous stakeholder questions into reusable data models and dashboards for analysts and AI use cases.
- Define and govern consistent metrics through the semantic layer.
- Support experimentation and campaign measurement.
- Partner with Data Engineering, Product, and analytics teams to deliver analysis-ready data.
- Build reusable AI-driven workflows for the data team.
- Identify and resolve data quality problems before they affect the business.
Requirements
- 5+ years of experience in analytics engineering, business intelligence, data analytics, or data modeling.
- Expert SQL skills and fluency with dbt, Git, and the analytics development lifecycle.
- Strong data modeling and data warehousing fundamentals, including well-documented tables with clear grain.
- Experience building and governing metric definitions through a semantic layer.
- Demonstrated ability to turn business needs into models and dashboards used by stakeholders.
- Hands-on experience building AI-driven workflows or skills.
- Ability to work autonomously in a changing environment.
- Preferred experience with Cube, Looker, or similar semantic-layer and BI tools.
- Preferred background in healthcare or other regulated data.
- Preferred experience measuring marketing campaigns, experiments, or engagement.
Benefits
- Generous equity package.
- Full medical, dental, and vision coverage.
- 401k plan.
- Unlimited PTO, 10 paid holidays, and company-wide Me Time Days.
- Paid maternity, paternity, and new parent leave.
- Flexible working environment.
- Annual learning and development stipend.
- Wellness reimbursement program.
- Access to reproductive and family planning care.
- Substance use support for employees and family members.
- Full-time position in the United States.
About Pelago
Pelago provides a virtual clinic for substance use management, combining digital programs, live counseling, CBT, and medication-assisted treatment for alcohol, tobacco, opioid, cannabis, and stimulant use. It sells to employers and health plans as a confidential benefit for members, delivered through an integrated care platform. Founded in 2017 and headquartered in New York, the privately held company closed a Series C round in 2024 and publishes peer-reviewed outcomes on clinical impact and medical cost savings.