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