Power BI Developer

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.

We are seeking a highly analytical and results-driven Power BI Developer to join our Customer Success team. This role will be critical in transforming complex, multi-source data into meaningful dashboards, reports, and analytics tools that inform operational decisions, support planning initiatives, and enhance the client experience. The successful candidate will have a strong background in business intelligence, data modelling, and performance reporting, with a passion for analytics and project management.

Your day-to-day responsibilities will include:

Power BI Development:

• Design, develop, and publish visually compelling, interactive dashboards and reports in Power BI tailored to client-specific KPIs such as ridership trends, on-time performance, service productivity.
• Create intuitive, drill-down capable visuals for internal teams (planning, operations, finance) and executive leadership.
• Develop scheduled refresh cycles, row-level security, and data access controls to ensure reliable, secure, and scalable reporting infrastructure.
• Write clean, optimal DAX measures of varying complexity to meet the needs of the business to derive meaningful insights from data.
• Clean and transform the data in Power Query to ensure complete data integrity for the end users.
• Build robust data models that support cross-functional insights and adhere to best practices in data normalization, relationship handling, and performance tuning.
• Incorporate third-party tools to enhance visualization that provides a better customer experience.
  
  
  

Stakeholder and Client Collaboration:

• Partner with data engineering, customer success, salesforce admin, and solution engineering teams to gather reporting requirements and define key metrics.
• Translate business needs into clear data visualizations that support both high-level strategy and operational execution.
• Conduct training and knowledge-sharing sessions for end-users to maximize adoption and self-service reporting capabilities.
• Attend training and transition meetings with clients as needed, assisting them with migrating their reporting needs to Power BI, and utilizing self-serve capabilities of our reporting service through shared Power BI datasets or directly with datamarts hosted in Amazon Redshift.
  
  
  

Data Governance & Quality Assurance:

• Implement data validation and error-checking to ensure high data accuracy and consistency.
• Document data sources, models, metrics definitions, and Power BI assets for transparency and knowledge continuity.
• Demonstrate continuous learning of the ever-changing Power BI environment, staying up-to-date with the latest updates and features.
  
  
  

Qualifications and Experience:

Requirements:

• Bachelor’s degree in Data Analytics, Computer Science
• 2-4 years of experience as a Power BI developer or in a similar data analytics/business intelligence role.
• Strong proficiency in:
• Power BI Desktop and Power BI Service
• DAX and Power Query (M language)
• SQL (T-SQL, PostgreSQL, or similar)
• Experience working with large, time-series datasets and multiple data formats (CSV, JSON, APIs).
• Excellent communication skills with the ability to present technical information to non-technical audiences.
• Strong analytical thinking and problem-solving
• Extremely detail-oriented to create clean, decluttered data visualizations, with a focus on data quality
• Effective communication and visualization design
• Ability to manage multiple Power BI development projects simultaneously
• Team-oriented with a collaborative mindset
• Located in Waterloo Region (This role requires in-office attendance at least 3 days a week)
  
  

Preferred:

• Familiarity with DAX Studio and Tabular Editor
• Experience in the public transit or transportation industry is a plus.
• Familiarity with R, Python, or other scripting languages for data processing.
• Understanding of data governance, security roles, and user access management in Power BI.
  
  
  

Compensation and Benefits:

• Base Salary: $75K - $100K + 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
  
  
  

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 microtransit software among the 10 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.