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
Senior Full Stack Analytics Developer at Manulife developing analytics solutions and innovative data visualization tools. Collaborating with diverse teams to improve investment decision - making processes.
Data & Analytics Engineer Co - op/Internship with BCI supporting implementation of Data & Analytics projects. Creating reports and driving data literacy while working with a dynamic team.
Analytics Engineer designing and implementing data platforms at Pebl. Contributing to data ecosystems and improving engineering practices with AWS services.
Adobe Analytics Engineer supporting digital data collection and marketing technology integrations at Northern. Collaborating with a talented team to enhance digital experiences and ensure privacy compliance.
Senior Analytics Engineer at Tempo, building and maintaining data foundations for GTM and corporate reporting. Collaborating on datasets, reports, and improving data model usability.
Analytics Engineer at Tucows utilizing advanced analytics expertise to extract insights from raw data. Collaborating across teams to drive data - driven decision - making and optimize data processes.
Staff Analytics Engineer at Affirm responsible for building and owning a Financial Subledger Data Platform. Ensuring data integrity and collaborating across Finance and Engineering teams.
Senior Analytics Developer building analytical foundation from scratch for People Analytics at Wealthsimple. Designing data pipelines and ensuring data governance practices are in place.
Senior Analytics Engineer building complex data models and insights at Coconut Software. Mentoring team members and supporting data - driven business strategies with advanced analytics.