Senior Analytics Engineer
About the role
The Analytics Engineering team at Pantheon owns how data becomes trusted, self-serve insight. This includes building and maintaining dbt models and business marts on top of raw source data in Snowflake, developing and maintaining the semantic layer that powers our BI platform, partnering with stakeholders across Finance, Sales, Marketing, CS, and RevOps to translate business questions into data models, defining and documenting consistent metric definitions, and collaborating with the Data Platform team to specify and request new sources, validate data, and raise quality issues.
Responsibilities
- Own the analytics modeling lifecycle for a business domain (GTM / Lead-to-Customer or Post-Sales)
- 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
- Define, document, and enforce consistent metric definitions and segmentation across the org
- 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
Requirements
- 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 OmniStrong
- 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)
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)
Benefits
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 is provided, along with paid parental leave and fertility, adoption, and other family planning benefits. In-office workspace is available in San Francisco and Chicago, and there's a monthly allowance for wellness, reading, and access to LinkedIn Learning for continued development. Events and activities both team-based and company wide inspire, educate, and cultivate growth.
Pay
$135,000 - $225,000 USD per year
Schedule
N/A