About the role

  • Analytics Data Engineer turning ingested data into trusted analytical assets for dashboards and insights. Collaborating with various teams to enhance data models and support decision-making.

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

Requirements

  • Bachelor’s or Master’s degree in Computer Science, Statistics, Mathematics, or a related field
  • 5 years or more of experience in analytics-focused data engineering
  • 3 years or more 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

Benefits

  • Bonuses
  • Paid Time Off policy
  • Region specific benefits

Job type

Full Time

Experience level

Mid levelSenior

Salary

$130,000 - $155,000 per year

Degree requirement

Bachelor's Degree

Tech skills

Amazon RedshiftCloudPythonSQL

Location requirements

RemoteCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.