Reporting Analyst

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.

As a Reporting Analyst on our Customer Success team, you will play a critical role in transforming data into actionable insights that drive client satisfaction, operational performance, and strategic decision-making. You will work closely with Business Analysts, Project Managers, Data Engineers, and the Technical Services team to design, deliver, and present reports that measure key success metrics across multiple stakeholders and customer touchpoints.

This central role within our Customer Success team ensures high data integrity and delivers the reporting capabilities necessary to optimize operations and guide strategic decision-making.

Your day-to-day responsibilities will include

• Lead the customer discovery process to understand their existing reports, usage, and RideCo initial reports required for launch to ensure continuity of operations for the customer.
• Map RideCo’s reporting suite to the customer’s legacy reports and systems, identifying key areas that require report modifications, new development, or customer change management customer education and change management.
• Design, create and maintain automated, scalable Power BI reports for internal and external clients, utilizing Power BI practices in DAX.
• Track KPIs and collaborate on defining new metrics that better align with client success and long-term retention goals.
• Generate custom and ad-hoc reports post-launch to address emerging operational needs and client requests.
• Standardize reporting by continuously eliminating redundant dashboards to build a more robust package of standard reports.
• Provide support for Redshift, guiding customers on querying data, communicating data changes that impact models, and troubleshooting technical issues.
• Develop internal reports tailored for cross-customer analysis and broad performance benchmarking.
• Collaborate cross-functionally with Data Engineering, Business Analysts, and Project Managers to understand data models, facilitate seamless knowledge transfer, provide technical support, and prioritize reporting requests requiring data model updates.
• Other duties and projects as assigned.

Preferred Qualifications

• Degree in Management Engineering / Applied Mathematics / Statistics / Finance / Business / Planning, or related discipline.
• 2+ years experience in a data analyst, reporting analyst, or customer success analytics role.
• Expert level proficiency in Microsoft Power BI is required with the ability to create clean, actionable reports, designed in close collaboration with business stakeholders.
• Experience with Redshift and DAX, experience with DAX Studio and Tabular Editor is an advantage.
• Strong communication skills with the ability to effectively convey findings in a clear manner to technical and non-technical stakeholders.
• Proactive self-starter with strong attention to detail, excellent interpersonal, project management and organizational skills.

Compensation and Benefits

• Base Salary: $80K - $95K + performance-based bonus + stock options
• Work-Life Balance & Additional Perks: Flex-time work schedules, vacation time, bi-weekly 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 within the Waterloo region
• Location: Waterloo Region, Ontario (position requires minimum 3 day in-office attendance)

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 cloud-based on-demand transit software among the ten largest cities in the United States. Our marquee clients include Philadelphia’s SEPTA, 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.

Why is this role open? Existing Vacancy

RideCo is committed to a fair and transparent recruitment process. We do not use artificial intelligence (AI) or automated decision-making tools to screen, evaluate, or select candidates. All applications are reviewed and assessed by our hiring team.