Analytics Engineer

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.

Your day-to-day responsibilities will include:

• 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: At RideCo, you’ll join a vibrant team that’s pushing the boundaries of on-demand transit. You’ll have the chance to learn and leverage the following tools and technologies, building valuable expertise across:

• 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: 

http://www.rideco.com

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.

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. #Li-Hybrid