Analytics Engineer

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

Job summary

A transportation technology firm in Southwestern Ontario is seeking an Analytics Engineer to develop data models and create impactful Power BI dashboards. You will collaborate with internal teams to ensure data accuracy and usability. The ideal candidate has 2-4 years of experience in analytics engineering, a strong background in SQL, and a degree in a relevant field. This position offers a competitive salary ranging from $85K to $120K, alongside flexible work schedules and various benefits.

Benefits

Flex-time work schedules

Catered lunches

Performance-based bonus

Stock options

Qualifications

• Minimum 2 - 4 years of experience in analytics engineering, business intelligence, or a related role.
• Proficient in Power BI and building reports.
• Solid SQL skills for querying and transforming data.

Responsibilities

• Develop clean, reliable, and reusable data models optimized for analytics.
• Design and publish dashboards and reports in Power BI.
• Work with internal users to gather reporting needs and insights.

Skills

Power BI

SQL

Python

Analytical thinking

Attention to detail

Education

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

Tools

Redshift

DBT

PostgreSQL

Git

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.

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.

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

Who we are

RideCo powers on-demand transit. Public transit agencies and fleet operators use RideCo’s cloud-based software platform to provide on-demand shared rides in dynamically routed buses and vans. RideCo is growing rapidly, and it is the most adopted on-demand paratransit and transit software among the 10 largest cities in the United States. Our marquee clients include Philadelphia’s SEPTA, RTC Las Vegas, San Antonio Metro, and Houston Metro.

RideCo’s software powers a diverse range of use cases, including paratransit, residential/suburban travel; first-mile-last-mile connections for transit hubs; and corporate employee transportation. The success of these services is supported by the industry's best customer service, including a 95% plus customer retention rate. We are investing to scale up and capture the growing demand for on-demand shared rides solutions.

More details at http://www.rideco.com

RideCo is proud to be an equal-opportunity employer. We hire the best talent and strive to build a meritocratic culture. In accordance with the Accessibility for Ontarians with Disabilities Act, accommodations are available upon request for candidates taking part in all aspects of the selection process. If you require special accommodation to complete any portion of the application or interview process, please mention this in your application.