Senior Analytics Engineer

7+ years experience in data engineering

Experience in development of pipelines to ingest and transform data from sources using REST APIs, AWS S3 and Airflow

Experience in building dbt models to transform data using Medallion architecture

Experience in designing and building dimensional data models from scratch with Type 2 SCDs and star schemas

Experience in maintaining data warehouses on SQL Server

Experience in designing and building at least one data warehouse on Snowflake from scratch

Be the Snowflake and dbt expert on the team, providing guidance on best practises

Make key design decisions for a brand new multi-dimensional data model

Make key architectural decisions for building a brand new data warehouse on Snowflake

Build and maintain pipelines to ingest data from Salesforce and various other data sources

Build and maintain dbt models to transform data using Medallion architecture for use by business intelligence tools

Work closely with our Business Intelligence team - monitoring and implementing enhancement requests for the data warehouse to meet the reporting demands of stakeholders

The successful candidate will also be given the opportunity to develop mentoring skills as we look to expand the team’s skillset to match those of our counterpart US team. As we work collaboratively with team members in different timezones, it is important that the candidate has strong interpersonal skills