Job SummaryThe incumbent is responsible for collaborating with various members of the Mechanical team to bring operational data to life. By analyzing alert thresholds, wayside detector readings, failure trends, and other metrics, the role improves the reliability of locomotives and rolling stock. The position contributes to the Mechanical Reliability team, which includes Car and Locomotive, Locomotive Subject Matter Expert (SME), Fleet leaders, Original Equipment Manufacturers (OEM), Wayside Detector and Machine Vision teams, and Senior Mechanical Leaders.Job SummaryThe incumbent is responsible for collaborating with various members of the Mechanical team to bring operational data to life. By analyzing alert thresholds, wayside detector readings, failure trends, and other metrics, the role improves the reliability of locomotives and rolling stock. The position contributes to the Mechanical Reliability team, which includes Car and Locomotive, Locomotive Subject Matter Expert (SME), Fleet leaders, Original Equipment Manufacturers (OEM), Wayside Detector and Machine Vision teams, and Senior Mechanical Leaders.Main ResponsibilitiesData ManagementDesign, develop, and implement Extract, Transform, Load (ETL) processes to gather data from various sources, including databases, Application Programming Interfaces (APIs), and flat filesLoad transformed data into data warehouses, data lakes, or other storage solutions to ensure accessibility and usabilityApply data cleaning, transformation, and enrichment techniques to prepare data for analysis and reportingDrive the collection of new data and the refinement of existing data resourcesValidate existing data sources by performing quality and audit checksCollaborate with internal and external teams to identify improvement opportunitiesAnalysis and ReportingIdentify trends, performance, safety, and productivity opportunities by applying data science techniquesDevelop, maintain,
and analyze performance metrics and reports that support data-driven decision-making processesSet alert thresholds by defect and fleetAnalyze and interpret the results from analytical tools and explain the meaning to the appropriate management levelsDevelop best practices for instrumentation and experimentationCommunicate and present findings to teams and management at all levelsWorking ConditionsThe role has standard working conditions in an office workplace with a regular workweek from Monday to Friday. The incumbent must be available to work night shifts and weekends when necessary. The role involves managing priorities and delivering work within established timelines, with support from the team to ensure sustainable and effective workload management. The role requires minimal travel (10%) within Canada and the United States (U.S.).RequirementsExperienceData AnalyticsMinimum 3 years of experience working with data analytics tools, including Structured Query Language (SQL), Tableau, Power BI, Excel and Systems, Applications, and Products (SAP)Machine Learning and Computer Vision Experience*Experience with Databricks, Azure Data Factory, Informatica Claire, Palantir Foundry, and ETLCandidates with an equivalent combination of education, training, and experience will be consideredAny requirement marked with (*) will be considered an asset (not mandatory).Education/Certification/DesignationBachelor's Degree in Statistics, Mathematics, Data Science, Engineering, or equivalent experienceCandidates with equivalent practical experience, education, or training will be consideredCompetenciesWe Care About Each OtherWe Strive for ExcellenceWe Succeed TogetherWe Lead ResponsiblyAbstract reasoning skillsAI Literacy and data orientationThink broadlyDepth of analysisBusiness acumenTechnical Skills/KnowledgeKnowledge of one or more scripting languages including Python, Pandas, or equivalent to perform required research and analysis
📌 Senior Specialist Data Analytics (Ottawa)
🏢 CN
📍 Ottawa