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, PostgreSQLProgramming & Transformation : SQL (data transformations and query optimization), PythonDevelopment 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 expressionsSolid SQL skills for querying and transforming dataStrong analytical thinking and attention to detailProven ability to communicate insights clearly to both technical and non-technical audiencesBachelor’s degree in Data Science, Computer Science, Business Analytics, or a related field.Compensation and Benefits :
Base Salary : $85K - $120K + performance-based bonus + stock optionsWork-Life Balance & Additional Perks : Flex-time work schedules, vacation time, catered lunches, social events, casual dress codeBenefits Plan : Medical, dental, prescription, life / health spending accounts and moreWork Environment : Located in KW's most desirable work space in the heart of Uptown WaterlooCommuter Program : Complimentary rides to and from work in Waterloo Region