Analytics Data Engineer

Location: Canada – Remote

Compensation - $130,000-$150,000 CAD
Overview / Objective

We are seeking an Analytics Data Engineer to join our client's Sports Analytics & Engineering Practice. This role is focused on turning ingested data into trusted, high-value analytical assets that power dashboards, insights, and decision-making across digital products, marketing, and fan engagement.

You will own the analytics layer of the data platform, building dimensional models and transformation logic that serve as a single source of truth for analysts, data scientists, and BI teams.
Key Responsibilities

- Design and build scalable data transformation pipelines using SQL, DBT, and Jinja templating

- Develop and maintain dimensional data models optimized for analytics and BI consumption

- Own the analytics data layer in DBT, enabling self-service analytics for business users

- Collaborate with product, analytics, and BI teams to translate business requirements into data models

- Enhance and maintain analytics codebases including DBT models, macros, tests, and documentation

- Implement data quality checks, tests, and governance-aligned transformations

- Optimize SQL for performance using partitioning, clustering, and materialized views

- Ensure semantic consistency and metric definitions across dashboards and reports

- Apply software engineering best practices including version control, CI/CD, and peer code reviews

- Support Agile development and collaborate with offshore teams for delivery and reviews

Required Qualifications

- Bachelors or Masters degree in Computer Science, Statistics, Mathematics, or a related field

- 5+ years of experience in analytics-focused data engineering

- 3+ years of deep hands-on experience with DBT, including advanced models, macros, and packages

- Strong expertise in dimensional modeling and data warehousing concepts

- Proficiency in SQL performance tuning and large-scale analytical query optimization

- Experience working with Amazon Redshift and modern cloud data platforms

- Familiarity with Python and/or Jinja templating for analytics engineering

- Experience aligning data models with governance, privacy, and access-control requirements

- Agile experience and comfort working with extended offshore teams

- Strong ownership mindset, attention to detail, and passion for building clean, trusted data products

Originally posted on Himalayas