Senior Analytics Engineer

Pantheon; Vancouver; On-site; CAD 111,000 - 166,000; Full time

Benefits offered by this job

Equity plan

Flexible time off

Medical insurance (Health, Dental, and

Vision coverage

Job summary

Pantheon is seeking a Senior Analytics Engineer to own end-to-end data modeling for business domains and to build scalable, self-serve data products that empower cross-functional teams. You will collaborate with Finance, Sales, Marketing, CS, and RevOps to translate business questions into reliable models and semantic layers.

You will work with Snowflake, dbt, Looker/LookML, and modern analytics workflows to ensure consistency and accuracy of metrics across the organization.

Qualifications

• 6–8 years in analytics, data engineering, or related field, with at least 4 years in analytics engineering.
• Advanced SQL and hands-on experience with dbt or similar transformation framework.
• Cloud data warehouse experience, ideally Snowflake.
• BI/semantic-layer modeling experience, ideally Looker (LookML) or Omni.
• Strong dimensional data modeling fundamentals (Kimball design, star schema).
• Proven ability to translate business questions into data models and communicate with stakeholders.
• Familiar with git and modern analytics development workflows (PRs and code review).

Responsibilities

• Own analytics modeling lifecycle for GTM/Lead-to-Customer or Post-Sales; build dbt models and marts.
• Develop semantic layer powering BI platform.
• Partner with Finance, Sales, Marketing, CS, RevOps to translate questions into models.
• Define and enforce consistent metrics definitions and segmentation across the org.
• Build self-serve data products for routine questions.
• Collaborate with Data Platform team to specify sources and validate data.

Skills

Advanced SQL

dbt transformation framework

Semantic/BI modeling

Stakeholder communication

Git and PR workflow

Dimensional data modeling

Tools

dbt

Snowflake

Looker LookML

Omni

Airflow

GitHub Actions

Job description

About Pantheon

Pantheon WebOps Platform powers the open web, running more than 300,000 sites in the cloud for customers including Google, Princeton, Salesloft and Doctors Without Borders. Every day, thousands of developers and marketers create, iterate, and scale WordPress and Drupal sites to reach billions of people globally. Pantheon's multitenant, container-based platform enables organizations to manage all of their websites from a single dashboard. Organizations such as Clorox and the United Nations drive results through accelerated development and real‑time publishing using Pantheon's collaborative workflows.

Senior Analytics Engineer

The Analytics Engineering team owns how Pantheon's data becomes trusted, self‑serve insight — from the data models built on our raw source tables to the semantic layer the whole company consumes. Sitting close to the business (under Finance), you will own a domain end‑to‑end and act as a partner who turns business questions into the right data models.

What You Need to Succeed

• Own the analytics modeling lifecycle for a business domain (GTM / Lead‑to‑Customer or Post‑Sales) — build and maintain dbt models and business marts on top of our source data in Snowflake.
• Develop and maintain the semantic layer that powers our BI platform.
• Partner directly with stakeholders across Finance, Sales, Marketing, CS, and RevOps to translate ambiguous business questions into the right model — prescribing or designing one when none exists.
• Define, document, and enforce consistent metric definitions and segmentation across the org (e.g., customer lifecycle stages, production lifecycle, ARR), establishing whether each lives in dbt or the semantic layer so metrics aren't defined twice.
• Build trustworthy self‑serve data products so business partners can answer routine questions without help.
• Collaborate with the Data Platform team where raw data is handed off — specify and request new sources, validate data, and raise quality issues upstream.

What You Bring to the Table

• 6–8 years of overall experience in analytics, data engineering, or a related field, including at least 4 years specifically in analytics engineering.
• Advanced SQL and hands‑on experience with dbt or a comparable transformation framework (models, tests, documentation).
• Cloud data warehouse experience, ideally Snowflake.
• BI / semantic‑layer modeling experience, ideally Looker (LookML) or Omni.
• Strong dimensional/data‑modeling fundamentals (Kimball design, star schema).
• Proven ability to translate business questions into data models — strong business acumen and stakeholder communication.
• Comfortable with git and a modern analytics development workflow (branch‑based PRs and code review).

Bonus Qualifications

• SaaS finance fluency — ARR, MRR, NRR (especially valuable given we sit under Finance).
• Depth in GTM/RevOps data (Salesforce) or post‑sales/CS data (Zendesk), depending on the domain.
• Familiarity with AI‑ or natural‑language‑driven analytics.
• Exposure to orchestration (Airflow), reverse ETL, or working alongside data engineering.
• CI/CD for analytics code (e.g., dbt tests running on PRs via GitHub Actions).

What We Offer

• Industry competitive compensation and equity plan.
• Flexible time off, sick days, and 13 paid holidays.
• Comprehensive medical insurance including Health, Dental and Vision.
• Paid parental leave (plus fertility, adoption and other family planning benefits).
• In‑office workspace (San Francisco & Chicago).
• Monthly allowance for wellness, reading and access to LinkedIn Learning for continued development.
• Events and activities both team‑based and company‑wide that inspire, educate and cultivate.

Pantheon is an equal opportunity employer and we welcome applications from all backgrounds regardless of race, color, religion, sex, national origin, ancestry, age, marital status, sexual orientation, gender identity, veteran status, disability, or any other classification protected by law. Pantheon complies with federal and local disability laws and makes reasonable accommodations for applicants and employees with disabilities. If you need a reasonable accommodation due to a disability for any part of the interview process, please contact [e-mail]. Pursuant to local and federal regulations, Pantheon will consider qualified applicants with arrest and conviction records for employment.

The base salary range for this position in Canada is $111,000 - $166,000 CAD per year. Our salary ranges are determined by role, level, and location. At Pantheon, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case.