The role designs, develops, and maintains human resources dashboards, governs data models, and automates analytics solutions. The role transforms complex human resources data from various systems into accurate, scalable reporting assets. The incumbent ensures data quality, supports governance standards, and collaborates with various stakeholders to deliver insights that drive decision‑making.
Power BI Development – 40%
- Design, develop, and optimize Power BI dashboards, KPI scorecards, and interactive visuals using best‑practice Data Analysis Expressions (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 Management – 20%
- Collaborate with I&T to integrate data, maintain data models and ensure accuracy and alignment with source structures.
- Consolidate multi‑source datasets into unified views.
- Collaborates with I&T to ensure data refresh stability, data lineage clarity, and issue resolution.
Automation and Distribution – 20%
- 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 stakeholders with timely, high‑quality analytics tools.
Governance – 10%
- Apply governance standards across data models, KPIs, metadata, and documentation.
- 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 – 10%
- Collaborate with peers to engage with stakeholders to assess reporting needs and design scalable, valued BI solutions.
- Collaborate with peers to 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.
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 Human Resources datasets*
Education/Certification/Designation
- Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, or a related field
- Certifications in BI, analytics, or data engineering*
Competencies
- Applies critical thinking
- Knows the business and stays current on industry needs
- Collaborates with others and shares information
- 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)*
Decision Making & Impacts
The incumbent enhances the organization’s analytics capabilities by enabling data‑driven decision‑making, ensuring data governance compliance, and delivering accurate, timely, and actionable reporting solutions that support Human Resources.
Level of Interaction/Influence
The role regularly collaborates with stakeholders, mainly within HR. The incumbent influences reporting standards, data quality practices, and solution adoption across Human Resources.
Employees Supervised/Organizational Structure
The role has no supervisory responsibility.
This position is posted as a Grade 9.
About CN
CN is a premium railroad that sustainably generates value for our customers, shareholders, employees, and stakeholders with an unwavering commitment to safety and service. Essential to the economy, to the customers, and to the communities it serves, CN safely transports more than 300 million tons of natural resources, manufactured products, and finished goods throughout North America every year. CN's network connects Canada's Eastern and Western coasts with the U.S. South through a 20,000-mile rail network. CN and its affiliates have been contributing to community prosperity and sustainable trade since 1919. CN powers the North American economy and is committed to programs supporting social responsibility and environmental stewardship.
At CN, we are dedicated to building North America's safest, most inclusive and sustainable railroad, which includes reflecting the communities in which we operate. Research shows that candidates often don't apply unless they feel they fit the job posting at 100%. To all potential applicants, even if you don't meet every job requirement listed in a posting, we still encourage you to apply. If you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations), please get in touch with our team at [email protected].
As an equal opportunity employer, qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, and other protected status as required by applicable law.
Please monitor your email on a regular basis as communication to applicants is done via email.
