Pantheon Platform Logo

Pantheon Platform

Senior Analytics Engineer

Posted 11 Days Ago
Remote
Hiring Remotely in United States
135K-225K Annually
Senior level
Remote
Hiring Remotely in United States
135K-225K Annually
Senior level
Own end-to-end analytics modeling for a business domain: build and maintain dbt models and business marts on Snowflake, develop the BI semantic layer, define consistent metrics, create self-serve data products, and partner with Finance, Sales, Marketing, CS, and RevOps. Validate upstream data with the Data Platform team and translate ambiguous business questions into production-ready data models.
The summary above was generated by AI

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 including Clorox and the United Nations drive results through accelerated development and real-time publishing using Pantheon’s collaborative workflows. 

The Role

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'll 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

We have all the usual perks and benefits but what we can really offer you is a fantastic work environment powered by an amazing team.

  • 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 [email protected]. Pursuant to local and federal regulations, Pantheon will consider qualified applicants with arrest and conviction records for employment.

After an offer is made and accepted, E-verify will be utilized to establish your identity and employment eligibility as required by the U.S. Department of Homeland Security.

To review the Employee and Applicant's Privacy Policy, click here.

Visa Sponsorship is not available at this time.
The US base salary range for this position in the United States is $135,000 - $188,000 USD 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.

Similar Jobs

5 Days Ago
Remote
United States
164K-193K Annually
Senior level
164K-193K Annually
Senior level
Healthtech • Social Impact • Software • Telehealth
Design, build, and optimize modular dbt pipelines and data models; translate ambiguous product requirements into production-grade data assets; diagnose query performance and lower warehouse compute costs (including migration to Snowflake); enforce code hygiene, data security, testing, and peer review; mentor junior engineers and adopt AI-assisted development tools to speed test generation and legacy discovery.
Top Skills: BigQueryDbtGitRedshiftSnowflakeSQL
14 Days Ago
Remote
United States
140K-175K Annually
Senior level
140K-175K Annually
Senior level
Agency • Consumer Web • eCommerce • Social Media
Owner of the analytics foundation: design and maintain BigQuery/dbt models, pipelines, and Looker Studio reporting; build AI workflows and web apps on GCP; integrate marketing, e-commerce, and fulfillment data; ensure GCP ops, security, and reliability; use AI-assisted tools daily and collaborate with business and client stakeholders.
Top Skills: Ad PlatformsBigQueryClaude CodeCloud FunctionsCloud RunCloud SchedulerCursorDbtDbt CloudGa4GCPGeminiGemini Enterprise Agent PlatformGitIamLlm ApisLooker StudioNext.JsPub/SubPythonReactSecretsService AccountsShopifySQLVertex AiWorkflows
5 Days Ago
Remote
United States
145K-170K Annually
Senior level
145K-170K Annually
Senior level
Fintech • Financial Services
Design, build, and maintain scalable dimensional data models, semantic layer, and production transformation pipelines. Collaborate with Data Engineering, Data Science, BI, DevOps, and Product to enable AI-ready data, ensure data quality and governance, support ML feature delivery, and coach analytics team members for robust, production-ready data products.
Top Skills: DatafoldDbtFivetranPythonRedshiftSnowflakeSQLTableau

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account