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 – 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. Requirements 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* *considered an asset Education/Certification/Designation · Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, or a related field · Certifications in BI, analytics, or data engineering* *considered an asset Competencies · 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 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)* *considered an asset Organizational Impact 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.