Pelago Logo

Pelago

Sr. Analytics Engineer

Posted 8 Days Ago
Be an Early Applicant
In-Office
New York, NY, USA
165K-185K Annually
Senior level
In-Office
New York, NY, USA
165K-185K Annually
Senior level
Build and maintain dbt data models in Redshift, applying software engineering practices, testing, documentation, and clear lineage. Translate business questions into reusable models, dashboards, and governed semantic metrics for analysts and AI initiatives. Support experimentation and campaign measurement, collaborate with data engineering and product teams, develop AI-driven workflows, and proactively resolve data quality issues.
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

19 Days Ago
Easy Apply
In-Office
Easy Apply
149K-205K Annually
Senior level
149K-205K Annually
Senior level
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Build and maintain scalable GTM data pipelines, marts, semantic models, and dashboards supporting headcount planning, quota attainment, pipeline, and sales effectiveness. Partner with GTM analysts and stakeholders to establish reliable metrics, enable data tools, document systems, and develop AI-powered natural-language data querying capabilities. Translate complex data concepts for executives and engineers while ensuring high-quality, maintainable data products.
Top Skills: BigQueryDbtGitHexSalesforceSnowflakeSQL
22 Days Ago
In-Office
New York, NY, USA
200K-240K Annually
Senior level
200K-240K Annually
Senior level
Fintech • Payments • Real Estate • Software • Financial Services
Lead analytics engineering by developing scalable data models, defining analytics requirements, establishing company-wide data quality standards, and delivering reliable data products. Partner with analysts, engineers, product managers, and other stakeholders to improve data accessibility and decision-making. The role requires advanced SQL, Snowflake, dbt, BI tools, data modeling, testing, documentation, version control, and CI/CD experience, along with fintech industry knowledge.
Top Skills: Ci/CdData WarehousesDbtModeSigma ComputingSnowflakeSQLTableauVersion Control
27 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 marketing data infrastructure, including Databricks pipelines, Gold Layer tables, semantic models, and trusted analytics foundations. Lead cross-functional data initiatives, translate ambiguous business needs into scalable solutions, ensure data quality and reliability, and mentor engineers and analysts. Build, evaluate, and monitor production LLM and agent systems, automate marketing workflows with AI, and deliver high-quality Python and SQL solutions supporting Marketing, Sales, and R&D.
Top Skills: Ai AgentsBigQueryClaude CodeCursorData WarehousesDatabricksDbtEtl/EltLakehousesLlmsPythonSalesforceSemantic LayersSnowflakeSQLStreamlit

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