Analytics Engineer

RideCo; Southwestern Ontario; On-site; CAD 85,000 - 120,000; Full time

Job summary

A leading transportation technology firm in Ontario is looking for an Analytics Engineer to drive data transformation and build impactful dashboards. You'll develop data models, create Power BI reports, and work closely with stakeholders to provide actionable insights. The role offers a competitive salary and numerous perks, including flexible schedules and a comprehensive benefits plan.

Benefits

Flex-time work schedules

Catered lunches

Social events

Casual dress code

Complimentary commuter rides

Qualifications

• Minimum 2 - 4 years of experience in analytics engineering or business intelligence with focus on data modeling and visualization.
• Proficient in Power BI: experience in building reports and data models.
• Strong SQL skills for querying and transforming data.

Responsibilities

• Develop clean, reliable, and reusable data models optimized for analytics.
• Design and publish dashboards and reports for decision-making.
• Work with internal users to gather reporting needs and create visualizations.

Skills

Power BI

SQL

Python

Data modeling

Analytical thinking

Education

Bachelor’s degree in Data Science, Computer Science, Business Analytics, or related field

Tools

Redshift

DBT

PostgreSQL

Job description

This is an opportunity in the exciting and fast-growing transportation technology industry. Public transit is being transformed from a system of static, scheduled fixed-routes, to a dynamic on-demand network, and you will be one of the pioneers shaping this transformation.

As an Analytics Engineer at RideCo, you’ll play a key role in driving this change, helping to build the data foundation that powers our innovative solutions. This is more than a job; it’s a chance to be part of a team leading the charge toward smarter, faster, and more efficient transit solutions. Data is the pulse of RideCo’s operations and decision-making. As an Analytics Engineer, you’ll build clear, impactful dashboards and well-structured data models that support day-to-day operations and long-term strategy. If you're passionate about transforming data into meaningful insights and love working in Power BI, we’d love to meet you.

Day-to-day responsibilities

• Build Effective Data Models: Develop clean, reliable, and reusable data models optimized for analytics, ensuring consistency and accuracy across all reporting layers.
• Create Power BI Dashboards and Reports: Design and publish dashboards and reports that drive decision-making across internal teams and clients.
• Collaborate with Stakeholders: Work with internal users to gather reporting needs and translate them into insightful, actionable visualizations.
• Ensure Data Accuracy and Quality: Validate data and perform regular checks to ensure consistency, accuracy, and usability.
• Optimize for Performance: Tune datasets and reports for speed and efficiency, applying best practices in Power BI development.
• Support Data Governance: Contribute to maintaining documentation and consistency in definitions, calculations, and usage across reports.

Your Toolbox / What You’ll Master

• Business Intelligence & Visualization: Power BI (datasets, reports, and dashboards)
• Data Warehousing & Modeling: Redshift, DBT, PostgreSQL
• Programming & Transformation: SQL (data transformations and query optimization), Python
• Development Practices: Agile methodologies, version control systems (e.g., Git)

Preferred Qualifications and Experience

• Minimum 2 - 4 years of experience in analytics engineering, business intelligence, or a related role, with a focus on data modeling and visualization.
• Proficient in Power BI: experience building reports, data models, and writing DAX expressions
• Solid SQL skills for querying and transforming data
• Strong analytical thinking and attention to detail
• Proven ability to communicate insights clearly to both technical and non-technical audiences
• Bachelor’s degree in Data Science, Computer Science, Business Analytics, or a related field.

Compensation and Benefits

• Base Salary: $85K - $120K + performance-based bonus + stock options
• Work-Life Balance & Additional Perks: Flex-time work schedules, vacation time, catered lunches, social events, casual dress code
• Benefits Plan: Medical, dental, prescription, life / health spending accounts and more
• Work Environment: Located in KW's most desirable work space in the heart of Uptown Waterloo
• Commuter Program: Complimentary rides to and from work in Waterloo Region