Data Engineer

Waterloo, Ontario, Canada | Full-time


Role Summary:

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, 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 Project and Operations managers, you’ll have a vital role in shaping the design, performance, and success of our clients’ next-generation on-demand transportation services. 


  • Manage and launch new reporting capabilities: 
    • Design and implement scalable data pipelines that power operational reports and empower business analysts 
    • Spearhead the development of an end-to-end data management and analytics platform and new client-facing reporting dashboard. Observe and foster best practices in business process design, implementation, and review. 
    • Maintain existing and develop new tooling for data warehousing and reporting
    • Be able to monitor and debug failures quickly and effectively
    • Define and document ground truth definitions of metrics and datasets
    • Be accountable for data privacy and access control
    • Integrate (ingest, model, load, transform) data from external, heterogeneous sources and combine them with internal data to produce insights
  • Improve and automate internal processes and tooling: identify ways to further systematize and automate our internal processes; communicate insights and analyses via 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.

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 (Django, Django Rest Framework)
  • Tableau
  • PostgreSQL, MSSQL, Oracle
  • Data normalization and modelling, writing optimal SQL queries and stored procedures, query profiling and optimization
  • Development Processes: Agile, continuous integration, Jenkins, git/gerrit
  • Microsoft Excel, Access and other Office tools

Required Qualifications and Experience:

  • 3-5 years of experience in data analyst or engineering role(s)
  • Experience with/able to learn Django ORM
  • Administrative experience working with Tableau 
  • A deep and intuitive understanding of databases and SQL 
  • Education:Undergraduate degree in Engineering / Data Science / Computer Science / Applied Mathematics / Statistics, or related discipline 

Compensation and benefits:

  • Base salary: $80K - 120K + performance-based bonus or stock options
  • Work-Life Balance: Flex time, work from home, vacation time
  • Benefits Plan: Dental, prescription, disability, massage and more 

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 and vans. Our clients include some of the world’s largest transportation operators such as Los Angeles Metro, San Antonio Metro, 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.