Senior Analytics Engineer

Location: Waterloo,Ontario,Canada

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 Senior 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, and as a Senior Analytics Engineer, you’ll design and maintain high-quality data models that enable seamless analytics and drive impactful decisions. With a focus on Power BI, you’ll build dashboards and visualizations that unlock actionable insights for stakeholders across our organization and clients worldwide. This role is perfect for a data enthusiast who thrives at the intersection of engineering and analytics.

Your day-to-day responsibilities will include:

• Design and Implement Scalable Data Models: Build robust, reusable data models optimized for analytics, ensuring consistency and accuracy across all reporting layers. Collaborate with data engineering teams to understand source systems and define transformation requirements
• Develop and Optimize Power BI Solutions: Create interactive, visually compelling Power BI dashboards that provide actionable insights to internal teams and clients. Optimize Power BI datasets, reports, and visualizations for performance and usability.
• Transform Data into Actionable Insights: Partner with stakeholders to understand business needs and translate them into technical requirements. Deliver clear and insightful reports that inform critical business decisions in areas such as rider experience, operational efficiency, and financial performance.
• Streamline Data Pipelines: Work with data engineering to optimize ETL/ELT processes, ensuring clean, reliable data flows into analytics layers. Identify and implement best practices for data integration, transformation, and modeling.
• Promote Data Quality and Governance: Ensure data accuracy and consistency by implementing validation rules and conducting regular audits of data models. Advocate for and enforce governance standards that promote the proper use of data assets.
• Drive Automation and Process Improvement: Identify opportunities to automate reporting workflows, reducing manual effort and enabling scalable analytics. Champion process improvements and new tools that enhance the efficiency and effectiveness of analytics efforts.

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), Tableau
• Data Warehousing & Modeling: Redshift, DBT, PostgreSQL
• Programming & Transformation: SQL (data transformations and query optimization), Python
• ETL/ELT Orchestration: Airflow, DBT, or similar tools
• Development Practices: Agile methodologies, version control systems (e.g., Git)

Qualifications and Experience:

• 5+ years of experience in analytics engineering, business intelligence, or a related role, with a focus on data modeling and visualization.
• Strong experience designing and implementing scalable data models for analytics purposes.
• Advanced proficiency in Power BI, including DAX, dataflows, and report creation.
• Expertise in writing optimized SQL queries and managing data transformation processes.
• Strong commitment to maintaining accuracy, consistency, and usability of data.
• Proven ability to translate business needs into actionable technical solutions.
• Bachelor’s degree in Data Science, Computer Science, Business Analytics, or a related field.

Compensation and Benefits:

• Base Salary: $120K - $140K + 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 workspace 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 cloud-based on-demand transit software among the ten largest cities in the United States.  Our marquee clients include Philadelphia’s SEPTA, Los Angeles Metro, 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