Senior Specialist, Data Developer (Contract)

At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you are part of making sure our business is running optimally and safely―helping keep the economy on track. We provide the kind of paid training and opportunities that long-term careers are built on and we recognize hard workers who strive to make a difference. You will be able to thrive in our close-knit, safety-focused culture working together as ONE TEAM. The careers we offer are meaningful because the work we do matters. Join us! Job Summary The Senior Specialist, Data Developer designs, develops, and maintains enterprise-grade dashboards, governed data models, and automated analytics solutions. The role transforms complex financial and operational data from SAP (BW/HANA/S/4HANA), SAP Concur, Tradeshift, and other systems into accurate, scalable reporting assets. The Developer ensures data quality, supports governance standards, and collaborates with Finance, Accounts Payable, Procurement, and Operations stakeholders to deliver insights that drive decision‑making. Main Responsibilities Power BI Development · Design, develop, and optimize Power BI dashboards, KPI scorecards, and interactive visuals using best‑practice DAX and modeling techniques. · Build robust semantic models and star schemas to support accurate enterprise reporting. · Implement row‑level security (RLS), dataset governance, and workspace standards. · Translate business requirements into technical specifications and produce user‑ready reporting outputs. Data Integration · Integrate SAP BW/HANA/S/4HANA data using native connectors, ensuring accuracy and alignment with source structures. · Develop automated ingestion pipelines for SAP Concur (OData/API) and Tradeshift (REST API with OAuth). · Consolidate multi‑source datasets into unified views for AP and Finance performance reporting. · Ensure data refresh stability, data lineage clarity, and issue resolution across integrations. Automation and Distribution · Build automated reporting workflows using Power Automate, including scheduled distributions and export packages. · Enhance reporting cycle efficiency by reducing manual steps through automation. · Implement monitoring mechanisms for refreshes, workflows, and scheduled tasks. · Support leadership and operational teams with timely, high‑quality analytics packages. Governance and Operations · Apply governance standards across data models, KPIs, metadata, and documentation. · Manage BI content lifecycle using deployment pipelines (Dev/Test/Prod). · Maintain documentation for data models, refresh schedules, workflows, and BI processes. · Ensure compliance with organizational data governance, privacy, and security protocols. Stakeholder Collaboration and Support · Engage with Accounts Payable to assess reporting needs and design scalable, valued BI solutions. · Communicate insights, present data trends, and support leadership decision‑making. · Provide knowledge transfer to elevate self‑service analytics maturity across the organization. · Partner with cross‑functional teams to ensure proper adoption, change‑management, and solution alignment. Working Conditions The role has standard working conditions in an office environment with a regular workweek from Monday to Friday and is eligible to participate in CN’s hybrid work policy. Due to the nature of the role, the incumbent must be able to meet tight deadlines, handle pressure and stress. Requirements Experience Information and Technology · Between 3–7 years of business intelligence development experience, including at least 2 years focused on Power BI. · Hands‑on background in data modeling, ETL/ELT, and dashboard/report development. · Experience with Finance, Accounts Payable, or Operations datasets* *Any designation for these above would be considered as an asset Education/Certification/Designation · Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, or a related field · Certifications in BI, analytics, or data engineering* *Any designation for these above would be considered as an asset Competencies · Applies critical thinking · Innovates · Knows the business and stays current on industry needs · Collaborates with others and shares information · Develops self and others · Provides recognition · Leverages feedback and coaching to improve performance · Delegates and empowers others to create accountability · Solves problems to create value Technical Skills/Knowledge · Advanced proficiency with Power BI Desktop, Power BI Service, Power Query (M), DAX, and dataflows · Experience integrating SAP systems, REST APIs, and structured enterprise data · Strong SQL skills, knowledge of data warehousing concepts, and familiarity with automation tools such as Power Automate · Knowledge of Python, R, database development (e.g., Transact-SQL and PL/SQL), and the Service Reliability System (SRS)* · Fluently bilingual both written and verbal (English, French)* *Any knowledge for a...