Analytics Engineer

Role Overview

The international data team is undergoing a complete transformation of their data architecture, migration from a legacy SQL server, Azure Data Factory, SSAS and Power BI stack to Snowflake, dbt, Airflow, Tableau and Sigma.

This opportunity will give the successful candidate a chance to share knowledge about best practices with Snowflake and dbt with the team, as well as a chance to build data infrastructure from scratch.

Key Responsibilities:

• 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

• Work collaboratively with team members in different timezones

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 time zones, it is important that the candidate has strong interpersonal skills.

Requirements:

• 3+ 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 maintaining dimensional data models with Type 2 SCDs and star schemas

• Experience in maintaining data warehouses on SQL Server

• Experience working with Snowflake, dbt and Tableau is essential