Data Engineer Analyst

Waterloo, Ontario, Canada | Full-time


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’ll be one of the pioneers shaping this transformation.

Data is at the heart of RideCo’s core offering, and drives the decisions we make in both our product and the services offered to our clients. As a Data Engineer Analyst, you will be responsible for building tools and processes to collect, transform, and generate insights and reports on the data needed to make these decisions. As a key technical and analytics resource for operations managers, you’ll have a vital role in shaping the design, performance, and success of our clients’ next-generation on-demand transportation services.  At RideCo, you will: 

  • Manage and launch new reporting capabilities: Spearhead the development of an end-to-end data management and analytics platform and new client-facing reporting dashboard. Work with operations managers to transform business requirements into concrete insights. Observe and foster best practices in business process design, implementation, and review. 

  • Use your creative aptitude to extract unique insights: Combine your creative thinking with your analytic skills to transform big data into actionable insights. Direct exploratory data initiatives to uncover business value using statistical and analytic techniques to drive project success and support the company reaching its corporate goals.

  • Generate and analyze operational performance reports: Build comprehensive performance analysis reports spanning rider user-experience, driver user-experience, marketing, operating efficiency, and unit economics.

  • Improve internal processes and tooling: Identify ways to further systematize our internal processes, including with new analysis and visualization tools. Share your ideas with team members and collaboratively champion internal process/tooling improvements.

  • Drive continuous improvement: Collaboratively develop weekly/monthly actions to drive continuous improvements, and to achieve the company’s data objectives (e.g. build new reports, database maintenance, etc) Work with the operations managers, and other stakeholders to execute on initiatives.

  • Automate: Identify areas of automation within the organization. Champion efforts to streamline processes and improve team productivity.


Your playground / what you’ll learn:

At RideCo you’ll get a chance to play, learn and build with the following tools and technologies, and as part of a cross-functional team that is the world’s foremost innovator in on-demand transit software.

  • Python
  • Microsoft Excel, Access and other Office tools
  • PostgreSQL, MSSQL, Oracle
  • Building schemas, data normalization, writing optimal SQL queries, debugging existing queries
  • Development Processes: Agile, continuous integration, Jenkins


Qualifications and Experience:


  • 3-5 years of experience in data analyst or engineering role(s)
  • A deep and intuitive understanding of database and SQL experience.


Undergraduate degree in Engineering / Data Science / Computer Science / Applied Mathematics / Statistics, or related discipline.


Compensation and benefits:

Base salary: $70K - 90K + performance-based bonus or stock options
Work-Life Balance: Flex time, work from home, vacation time
Set-up: Adjustable height desk, high-end computer/laptop, three monitors, ergonomic seating
Benefits Plan: Dental, prescription, disability, massage and more
Food & Fun: Gourmet coffee, teas, juice, snacks, team lunches


Who we are:

RideCo powers on-demand transit. Public transit agencies use RideCo's cloud-based software platform to provide on-demand shared rides in dynamically routed buses, vans, and cars. Our clients include some of the world’s largest transportation operators such as San Antonio Metro, Los Angeles Metro, San Diego County, Grab, and Calgary Transit.


Have you experienced getting frustrated with transfers and waiting while taking a public bus? Have you seen buses drive around in low-density areas with very few passengers on-board and wondered how inefficient that seems to be? You're likely aware of the first & last mile access challenges faced by transit hubs. We are solving these problems by re-imagining shared mobility. Imagine a world where vehicles have dynamic routes responsive to real-time trip demand. This 'dynamic shuttle' (or van/sedan) would pick you up, on-demand, at or near your doorstep and take you to your destination or transit hub. Along the way, it may pick-up other passengers going in your direction. Your experience will be seamless: less waiting, less walking, fewer transfers, shorter travel time, and timely pickups and drop-offs. RideCo's 'dynamic shuttle' platform enables this seamless experience and low-cost shared rides for vehicle fleet operators and their passengers. By seamlessly moving more people in fewer vehicles we are catalyzing a generational shift in how people get around cities and towns. This means commuters spend less time in transit and more time doing what they enjoy.


RideCo powers a diverse range of use cases, including residential/ suburban travel; first-mile-last-mile connections for transit hubs; and corporate employee transportation. We are investing to scale up and capture the growing demand for on-demand shared rides solutions.



Email your resume (or link to your LinkedIn profile) and cover letter to:

Email Subject: “Data Engineer Analyst”

In your cover letter or email, please write a few sentences outlining how you meet the requirements for this role.