Senior Analytics Engineer - Product

Pantheon; Vancouver; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in the WebOps sector is looking for an Analytics Engineer to enhance their data transformation strategy. This role involves designing data models, collaborating with stakeholders, and developing insightful dashboards. Ideal candidates will have strong SQL skills and a background in data science or analytics. Join a team that values trust, teamwork, and passion while enjoying a competitive compensation package and a supportive work environment.

Benefits

Industry competitive compensation and equity plan

Paid Time Off (PTO)

Paid Sick Leave (PSL)

Full medical coverage

Top-of-line equipment

Monthly allowance for wellness

Access to LinkedIn Learning

Qualifications

• 5+ years of experience with dbt or similar data transformation frameworks.
• Experience with product analytics data and tools, particularly Segment.

Responsibilities

• Design, build, and maintain dbt models for data transformation.
• Develop reports and visualizations in BI tooling (Looker).
• Establish and maintain data quality standards and documentation.

Skills

SQL

Analytical Thinking

Problem Solving

Communication

Education

Bachelor's degree in Computer Science

Bachelor's degree in Data Science

Bachelor's degree in Statistics

Tools

dbt

Looker

Snowflake

Jira

Job description

About Pantheon

Pantheon is the WebOps platform for websites that deliver extraordinary results. We believe in putting the magic of the internet in everyone’s hands. That’s why we’re so passionate about helping developers, IT and marketing develop, test, and release website changes faster and more reliably so they can build and maintain websites that create value for their organizations. Our cloud native software makes it easy to securely manage a single website or thousands of websites across multiple teams in one platform.

Pantheon’s core company values are Trust, Teamwork, Passion, and Customers First. At Pantheon, we work hard and play harder, valuing individuality, humor, and balance. We're enthusiastic participants in several open-source communities and have real relationships with many of our most active customers. If all of this sounds interesting to you, read on!

The Role

We're seeking an Analytics Engineer who will play a crucial role in our data transformation strategy. In this position, you'll develop the data models that serve as the foundation for our business intelligence and self-serve analytics capabilities. You'll work at the intersection of data engineering and business analysis, with a particular focus on product analytics. This role is central to our strategy of building a more data-literate organization where insights are accessible to everyone who needs them.

• Your primary responsibility will be designing, building, and maintaining dbt models that transform raw data (especially from our product analytics stack) into accessible, reliable insights.
• You'll work directly with stakeholders across the organization to understand their needs, then translate those requirements into well-structured data models and intuitive dashboards that drive decision-making.
• Develop reports and visualizations in our BI tooling (currently Looker) that provide actionable insights for stakeholders
• Help establish and maintain data quality standards and documentation
• Identify areas where poor data quality indicates unclear business processes and recommend improvements
• Contribute to our growing self-serve analytics capabilities by creating reusable, well-documented data assets
• Help upskill business users in data literacy and tool usage

What You Need to Succeed

• Strong SQL skills and experience with data modeling concepts
• Proficiency with software development practices, including Git, code review, and CI/CD
• Comfort with command line interfaces (CLI) and developer workflows
• Ability to translate business requirements into data models and analytics solutions
• Strong analytical thinking and problem-solving skills
• Excellent communication skills and ability to work with both technical and non-technical stakeholders
• Bachelor's degree in Computer Science, Data Science, Statistics, or related field (or equivalent work experience desired)

Bonus Point: Experience working with product analytics data and tools, particularly Segment

What you Bring to the Table

• 5+ Years of experience with dbt (data build tool) or similar data transformation frameworks
• Familiarity with Snowflake or other cloud data warehouses

Experience with Amplitude, Segment, or similar product analytics platforms

• Knowledge of Jira or similar project tracking tools
• Previous work in a business intelligence or analytics role
• Experience with visualization tools and dashboard design
• Understanding of dimensional modeling and data warehousing concepts

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
• Paid Time Off (PTO), Paid Sick Leave (PSL) and 11 Paid Company Holidays
• Full medical coverage (Extended health care, dental, vision)
• Top-of-line equipment
• 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/affirmative action 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.

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.

#LI-PY1