Senior Specialist Human Resources Data Insights

CN; Montreal (administrative region); Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

CN is seeking a BI-focused HR analytics professional to design, develop, and maintain Power BI dashboards, governance of data models, and automated analytics solutions. The role transforms complex human resources data from multiple systems into accurate, scalable reporting assets to drive decision-making.

You will collaborate with Technology and business stakeholders to ensure data quality, implement RLS and semantic models, and deliver user-ready outputs.

Qualifications

• Power BI development, data modeling, ETL/ELT
• Experience with SAP integration and REST APIs
• Strong SQL and data warehousing knowledge
• Programming with Python and R
• Fluently bilingual English/French

Responsibilities

• Design, develop, and optimize Power BI dashboards, KPI scorecards, and visuals using DAX and modeling techniques
• Build semantic models and star schemas to support enterprise reporting
• Implement row-level security, dataset governance, and workspace standards
• Translate business requirements into technical specs and deliver user-ready reporting outputs
• Collaborate with Technology to integrate data and ensure accuracy
• Consolidate multisource datasets into unified views
• Build automated reporting workflows using Power Automate for scheduled distributions
• Apply governance across data models, KPIs, metadata and documentation
• Collaborate with stakeholders to assess reporting needs and promote self-service analytics

Job description

Job Summary

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.

Main Responsibilities

Power BI Development

• Design, develop, and optimize Power BI dashboards, KPI scorecards, and interactive visuals using bestpractice Data Analysis Expressions (DAX) and modeling techniques.
• Build robust semantic models and star schemas to support accurate enterprise reporting.
• Implement rowlevel security (RLS), dataset governance, and workspace standards.
• Translate business requirements into technical specifications and produce userready reporting outputs.

Data Management

• Collaborate with Technology to integrate data, maintain data models and ensure accuracy and alignment with source structures.
• Consolidate multisource datasets into unified views.
• Collaborates with Technology to ensure data refresh stability, data lineage clarity, and issue resolution.

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 stakeholders with timely, highquality analytics tools.

Governance

• 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

• 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 decisionmaking.
• Provide knowledge transfer to elevate selfservice analytics maturity across the organization.
• Partner with crossfunctional teams to ensure proper adoption, changemanagement, 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 model. The role involves managing priorities and delivering work within established timelines, with support from the team to ensure sustainable and effective workload management.

Experience

Information and Technology

• Between 3-7 years of business intelligence development experience, including at least 2 years focused on Power BI.
• Handson background in data modeling, ETL/ELT, and dashboard/report development.
• Experience with Human Resources datasets*
• Candidates with an equivalent combination of education, training, and experience will be considered
• Any requirement marked with (*) will be considered an asset (not mandatory).

Education/Certification/Designation

• Bachelor's Degree in Computer Science, Information Systems, Data Analytics, or a related field
• Certifications in BI, analytics, or data engineering*
• Candidates with equivalent practical experience, education, or training will be considered
• Any requirement marked with (*) will be considered an asset (not mandatory).

Competencies

• We Care About Each Other
• We Strive for Excellence
• We Succeed Together
• We Lead Responsibly
• Stakeholder management
• Reading the environment
• Build trust
• Listening
• Interpersonal flexibility

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 requirement marked with (*) will be considered an asset (not mandatory).