Analytics Engineer

Analytics Engineer

Waterloo - Hybrid Working

Full Time

Permanent

Grade 4

Role overview:

• Develop and maintain dbt models that transform raw data into trusted datasets for analytics and business intelligence
• Implement data quality tests and monitoring to ensure accuracy and reliability
• Optimise query performance using effective data modelling and materialisation strategies
• Establish and maintain documentation and data dictionaries for analytical models, KPI definitions and metrics frameworks
• Support self-service analytics by building reusable, high-quality data models
• Collaborate with cross-functional teams to translate business requirements into technical solutions
• Collaborate with data engineers to define requirements for new data sources and pipelines
• Conduct exploratory data analysis to identify trends, patterns, and anomalies in business performance
• Build interactive dashboards and reports that empower self-service analytics
• Design visualizations that clearly communicate complex data stories to both technical and non-technical audiences

What you'll bring:

• Strong SQL skills with experience in complex data transformations, CTEs, and window functions
• Expertise with dbt and modern analytics engineering tools
• Solid understanding of dimensional modelling and data warehousing concepts
• Experience with Git-based workflows for version control and collaboration for analytics
• Knowledge of data testing frameworks and quality assurance practices
• Experience with Snowflake, Databricks, or similar data platforms
• Proficiency in Omni, Looker or similar BI tools (Tableau, Power BI)
• Strong analytical thinking and problem-solving abilities
• Excellent communication skills with ability to present findings to diverse audiences

Experience Required:

• 2-4 years of experience in a data analyst or analytics engineer role
• Degree in Computer Science, Analytics, or a related technical field highly desirable
• dbt & Analytics platform certification beneficial

Every voice has a space at our table and we’re committed to making inclusion and diversity part of everything we do, including how we strengthen our workforce. We want to make sure you have a fair opportunity to show us your talents during our application process, so if you need any additional assistance with your application please email [email protected] and we’ll do our best to help.