Senior Specialist People Analytics

Canadian National Railway Company•Edmonton, AB

1d•Hybrid

About The Position

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.

Requirements

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
Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, or a related field
Certifications in BI, analytics, or data engineering
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
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)

Nice To Haves

considered an asset

Responsibilities

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.
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.
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.
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.
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.