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