Job Description: Our Customer Analytics office is seeking an Advisor, Analytics (Business Intelligence and Reporting) to join the team. The Advisor, Analytics will design, develop and maintain best-in-class reporting framework and interactive dashboards for enterprise-wide consumption of customer insights. This individual will also identify opportunities for increasing ridership and revenue, and work in a high-performing, diverse team feeding data insights to decision-makers across the organization. Job Responsibilities: Works with Marketing, I&IT and other key business stakeholders to integrate customer data sources Develops dashboards, reports and creates presentations in a format that effectively communicates the analysis to the target audience Thoughtfully and clearly articulates analytical trends, insights, and recommendations Produces intuitive and comprehensive PowerBI reporting dashboards by leveraging different forms of structured and unstructured data sources – including managing dashboards, data refresh, and access settings for published dashboards Works independently as the subject matter expert on all interactive and ad-hoc reporting frameworks for the Customer Analytics team Supports the Customer Analytics, Manager, the Customer Insights and Marketing team Generates recurring/ad-hoc reporting packages and scorecards on key performance indicators (KPIs) for the executive leadership Detail-oriented, with ability to simplify complex information for a non-technical audience Effectively communicates customer insights and commentary on ridership and fare revenue performance/trends, and customer behaviour Assists the team in presenting key findings and recommendations to business decision-makers Maintains high level of understanding of internal and external data platforms, with an ability to strategically integrate with appropriate reporting platforms Partners with cross-functional stakeholders to gather requirements on time-sensitive requests, and develop easily consumable reports Develops back-end connections to diverse data sources and corresponding front-end visualizations for holistic customer insights reporting Extracts data from relational databases (using SQL), or Hadoop environments (leveraging PySpark or SparkR) Contributes to the maintenance and enhancement of data governance, data quality and related policies Works with Marketing, Operations, and PRESTO to develop analytics Job Requirements: Completion of a degree in Math or Statistics (Data Analytics/Data Science), Engineering, Finance, Economics, or a related discipline – or a combination of education deemed equivalent Proficiency in Python/R, Power BI, including experience with distributed database and complex data sets Experience in working with customer behaviour, customer segmentation and profiling preferred Minimum three (3) years of experience in data analytics related work function(s) with at least two (2) years of experience in building interactive Power BI dashboards Minimum two years of experience in end-to-end development, online hosting and maintenance of Power BI reporting frameworks Proficiency in MS Office (Outlook, Word, Excel, PowerPoint, etc.) Intermediate/advanced level expertise in data manipulation through Python, Power Query and MS Excel Basic experience with cloud technologies (AWS/ MS Azure / GCP) preferred Job Details: Company: Metrolinx Vacancy Type: Full Time Job Location: Toronto, ON, CA Application Deadline: N/A Apply Here careers-trivia.net
Careers Trivia – Latest Jobs 2025