Job Details Permanent Full Time (CUPE 1329) Posting Status Restricted to current Town of Oakville employees Closing Date Applications for this position must be received at oakville.Ca by no later than 11:59 p.M. on October 1, 2026. This job posting is for an existing vacancy and therefore will be filled accordingly. Reporting to the Manager, Planning & Administrative Services, the Transit Data & Analytics Specialist is responsible for the development, maintenance, and continuous improvement of Transit's data management, business intelligence, reporting, forecasting systems and decision-support capabilities. Job Responsibilities Transit Data Systems, Business Intelligence & Automation Develops, maintains and continuously improves Transit’s business intelligence, reporting, performance measurement and analytical reporting setting to support operational, financial, regulatory and strategic business requirements. Designs and maintains analytical datasets, dashboards, scorecards, reporting frameworks, forecasting tools and automated reporting processes that consolidate data from PRESTO, APC, fare collection systems, scheduling systems, financial systems and other Transit applications, ensuring information is reliable, accessible and conveys meaningful business information. Develops current-year and long-term ridership and revenue forecasts to support annual budget development, year-end reviews, service planning, performance monitoring and Oakville Transit’s long-term growth strategy. Uses established methodologies and business assumptions, in addition to developing analytical models,



automated processes and reporting methodologies to monitor trends, prepare projections and identify operational trends, ridership patterns, revenue performance, customer service trends and emerging business issues. Identifies opportunities to automate manual reporting, improve system efficiencies and enhance the quality, consistency and accessibility of Transit data, forecasting tools, analytical frameworks and decision-support solutions used by Transit management. Participates in transit technology implementation projects, including testing, validation, reporting requirements, system integrations, and post-implementation performance monitoring. Data Integration & Quality Assurance Develops and maintains reporting-ready data models and analytical datasets by extracting, validating, cleansing, transforming, reconciling, and integrating information from multiple Transit and corporate systems. Identifies data gaps, anomalies, inconsistencies, and incomplete records and applies appropriate business rules, assumptions, and validation techniques to ensure information is accurate, reliable, and suitable for reporting, forecasting, visualization, and decision-support purposes. Evaluates source-system data generated by Transit business systems and determines the appropriate methods to filter, standardize, enrich, aggregate, and structure information for analytical and reporting purposes. Maintains data definitions, metadata, reporting logic, calculation methodologies, and documentation to support sustainable reporting practices and knowledge

📌 Transit Data And Analytics Specialist (Oakville)
🏢 Coastal Cardiology PC
📍 Oakville