Pelago Logo

Pelago

Sr. Analytics Engineer

Reposted 7 Days Ago
In-Office
New York City, NY, USA
165K-185K Annually
Senior level
In-Office
New York City, NY, USA
165K-185K Annually
Senior level
Design and own scalable dbt data models and semantic layers, define and govern company-wide metrics, build data quality and observability practices, enable analytics for experimentation and AI workflows, and align cross-functional stakeholders while mentoring analytics engineers.
The summary above was generated by AI

Pelago is the leading specialty substance use care provider, built on the belief that effective treatment means matching care intensity to what each member actually needs rather than defaulting to the most expensive intervention. Our programs guide members through every stage of the substance use spectrum, from unhealthy habits to active use disorders, delivering personalized treatment for tobacco, alcohol, opioid, cannabis, and stimulant use based on individual health, habits, genetics, and goals.

With Sona, our voice-first AI Mental Health Specialist, Pelago now applies that same clinically-driven model to mental health, pairing deep clinical expertise with technology to expand access without compromising care quality. We believe technology should make clinical care more precise and more human, not replace the judgment behind it.

Pelago has scaled to helping hundreds of employers and health plans and has already helped more than 750,000 members better manage their substance use. If you're passionate about AI and making an impact on the health of others, join us and make it happen!

About Our Data Team:

Our Data team sits at the center of how Pelago makes decisions. As we scale, we're building a data function that doesn't just report on the business — it shapes it.

We transform complex healthcare and product data into clean, reliable, well-documented models that power reporting, experimentation, AI initiatives, and day-to-day decision-making across the company. The Senior Analytics Engineer is a key force multiplier on that mission.

Overview of the Role:

We’re hiring an Analytics Engineer who loves building scalable data models, thinking deeply about business logic, and creating reusable data assets. In this role, you’ll help shape how data is structured and defined across Pelago—ensuring consistency, quality, and usability for everything from dashboards to experimentation to future machine learning use cases. This is a business intelligence role with an analytics engineering toolkit. Reporting to our Director of Analytics, you'll partner with our Commercial, Marketing, and Health Services teams to understand what they need, and then own the dbt and semantic layers that deliver it. We want someone who asks why a number looks the way it does and stays with a problem until it's actually solved.

What You'll Do:
  • 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.
The Background We Are Looking For:
  • 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.

Nice to Have:

  • Experience with Cube, Looker, or similar semantic-layer and BI tools.
  • A background in healthcare or other regulated data.
  • Experience measuring marketing campaigns, experiments, or engagement.
What you’ll love about us:

We have a whole host of perks for our people! From life essentials to nice-to-haves, there are more than a few good reasons to love working with us. We strive to ensure Pelago employees have equitable access to healthcare, wellbeing, time away, and then some.

  • Generous and meaningful equity package 
  • Full Medical, Dental, & Vision coverage 
  • 401k Plan
  • Unlimited PTO Policy, 10 paid holidays, & company wide “Me Time” Days
  • Paid maternity, paternity & new parent leave
  • Flexible working environment
  • Annual Learning and Development stipend to support continued learning and career development
  • Wellness Reimbursement Program 
  • Access to Reproductive & Family Planning Care 
  • Substance Use Support for employees and family members 

At this time, we are unable to offer visa sponsorship for this position. 

The provided range reflects our US target salary range for this full-time position, which is part of our broader total compensation package, including incentive bonus program, stock options, comprehensive benefits, and incentive pay applicable to eligible roles. Individual pay within the range will vary based on a variety of factors like role-related experience and education, internal pay equity, and other relevant business factors. At Pelago, we are committed to an equitable and fair pay philosophy and review total compensation for our employees at least twice a year.

Base Pay Range
$165,000—$185,000 USD

Similar Jobs

2 Days Ago
Easy Apply
Remote or Hybrid
New York, NY, USA
Easy Apply
137K-231K Annually
Senior level
137K-231K Annually
Senior level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Architect and own Samsara’s marketing data and AI foundation, including Databricks pipelines, data models, semantic layers, and self-service analytics infrastructure. Lead cross-functional initiatives, ensure data quality and reliability, build and evaluate production LLM and agent systems, automate workflows with AI, and mentor engineers and analysts. Partner with Marketing, Sales, BI, and Data Science teams to turn ambiguous business needs into scalable data products.
Top Skills: BigQueryClaude CodeCursorDatabricksDbtLlmsPythonSalesforceSnowflakeSQLStreamlit
3 Days Ago
Hybrid
New York, NY, USA
175K-205K Annually
Senior level
175K-205K Annually
Senior level
Beauty • Enterprise Web • Fintech • Payments • Software
Own the architecture and standards of the company’s dbt project, building scalable models across staging, intermediate, and mart layers. Partner with product, design, and engineering teams to evolve data models, validate metrics, and maintain data quality. Develop AI-assisted testing, documentation, and access workflows; collaborate on Segment, Fivetran, and Airflow pipelines; and drive privacy, governance, and warehouse best practices.
Top Skills: AirflowDbtEtl/EltFivetranHexMatiaSegmentSnowflakeSQL
14 Days Ago
In-Office
New York, NY, USA
182K-242K Annually
Senior level
182K-242K Annually
Senior level
Cloud • Information Technology • Machine Learning
Own analytics engineering for the machine infrastructure supply chain team. Build and maintain semantic layers, trusted data models, metrics, dashboards, and analytics-ready datasets using dbt and modern data platforms. Analyze inventory trends, optimize stock levels, investigate discrepancies, and develop supply chain KPIs. Partner with data engineering, finance, product, operations, planners, and buyers while improving inventory planning, replenishment, ERP processes, and warehouse efficiency.
Top Skills: AirflowBashBigQueryCi/CdDagsterDbtDeltaErp SystemsFlinkHudiIcebergJuliaKafkaOmniPaimonPythonRRedshiftSnowflakeSparkSQLStarrocksTableau

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account