Senior Analytics Engineer

Senior Analytics Engineer

We are thrilled to announce our expansion to Vancouver, Canada. This is a unique opportunity for talented professionals to join us from the start and play a crucial role in shaping the future of our company. If you strive for excellence, are motivated by new challenges, and want to be part of a global success story, we invite you to be a key player in our exciting Vancouver venture! You will be required to work in a hybrid capacity from our Vancouver offices.

About Pantheon

Pantheon is the WebOps platform for websites that yield extraordinary results. We believe in giving everyone the power of the internet. That's why we are passionate about assisting developers, IT, and marketing to develop, test, and release website changes faster and more reliably, allowing them to build and manage websites that add value to their organizations. Our cloud-native software allows secure management of a single website or thousands across multiple teams on one platform.

We have extensive knowledge and experience across the technologies we use at Pantheon. You'll have numerous opportunities to acquire and apply new skills and gain professional experience with exciting new data technologies like Snowflake, Data Lake House, Event-Driven Data Pipelines, Real-Time Event Management, Predictive/ML Modeling, and Microservices API.

The Role

The Data & Analytics team at Pantheon focuses on delivering actionable, reliable, and significant data products to the business. These data products will enable Pantheon to continue growth, retain customers, understand platform usage, and refine our business and platform efficiencies. We are seeking an Analytics Engineer who understands the importance of data to the company. This engineer will collaborate closely with Software Engineers, Data Engineers, Analytics Engineers, and Analysts to assist in modeling, transforming, storing, and validating data to be made accessible for self-service analytics.

Pantheon's core company values are Trust, Teamwork, Passion, and Putting Customers First. Within our engineering team, we value collaboration, character, autonomy, and a blame-free culture. We are active participants in several open-source communities and foster real relationships with many of our most engaged customers. If all of this sounds intriguing to you, read on!

Exciting Tasks You'll Undertake

• Collaborate with Software Engineers to refine Transforms as a Service, enabling consistent data transformations from the data lake to the data vault and data marts. This includes validation and data governance using dbt-cli.
• Work with new technologies like Snowflake, including Snowpark with Python, Google Cloud Platform, Airflow 2, dbt, Docker, and Kubernetes.
• Help Analysts and Product Owners build self-service data products across a three-tier user model.
• Collaborate with Analysts to develop Self-Service Analytics in Looker
• Work with Data Engineers to source and load new data sets as needed.

• Enhance and deliver data into the Data Vault with dbt-cli
• Develop Data Marts (Data Products) from the Data Vault
• Opportunity to develop API Microservice Modules to deliver real-time data to platform engineers
• Establish data validation testing strategy for dbt jobs utilizing a mix of Stored Procedures, dbt, or Python libraries as best fits the needs.
• Continually improve our standard of engineering excellence by implementing best practices for coding, testing, deploying, and communication
• Support the Data Org as a member of the on-call engineer rotation, contributing to the stability, reliability, and performance of the data and data infrastructure that drives Pantheon's success.

What You Bring to the Table

• 5+ years of experience in analytics engineering or related roles, with a focus on developing complex transformations with dbt
• You enjoy and have a record of developing data products from complex data sources.
• You are passionate about data
• You have experience with dbt, preferably dbt-cli
• You have programming experience with Python, preferably Python3
• Experience with GitHub or a similar version control system, and you understand how to utilize CI/CD with integration testing in an analytical environment.
• You have worked with Cloud Databases: Snowflake, BigQuery, FireBolt, or Redshift
• Experience with Visualization tools like Tableau, ThoughtSpot, or particularly Looker
• Terms like Kimball Dimensional Model, Data Lake, Data Vault, and Data Marts are familiar to you
• You are a clear communicator, capable of conveying your contributions and ideas with clarity while remaining open and respecting the contributions and ideas of others.
• Take pride in what you can do as a part of a team.

Based in San Francisco, Pantheon is a platform where marketers and developers construct, host, and manage their high-value Drupal and WordPress websites. The secret to Pantheon's engineering success is not just our innovative scaling and performance tools, but our passionate, creative, and collaborative team.

What We Offer

We offer all the usual perks and benefits, but what we can truly offer you is a fantastic work environment driven by an extraordinary 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-the-line equipment
• Monthly allowance for wellness, reading, and access to LinkedIn Learning for continuous development
• Events and activities both team-based and company-wide that inspire, educate, and build connections

Pantheon is an equal opportunity/affirmative action employer, and we welcome applications from all backgrounds regardless of race, color, religion, sex, nationality, ancestry, age, marital status, sexual orientation, gender identity, veteran status, disability, or any other protected classification under law. Pantheon complies with federal and local disability laws and makes reasonable accommodations for applicants and employees with disabilities. If you require a reasonable accommodation due to a disability for any part of the interview process, please contact [email protected]. In accordance with 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.