Data Analytics and Reporting Analyst (Fixed Term Contract)

Egon Zehnder; Montreal (administrative region); On-site; CAD 70,000 - 110,000; Full time

Job summary

Egon Zehnder is seeking a Data Analytics and Reporting Analyst on the go.transform team to turn data into actionable insights that inform transformation decisions, measure adoption and impact, and support scaling of new tools and workflows across the Firm.

You will design and maintain dashboards, analyze adoption metrics, and prepare executive-ready reporting across Power BI, SharePoint, Workday, and Microsoft 365, collaborating with global teams to drive business improvements.

Qualifications

• 2–5 years of analytics, reporting, BI, or related field in a global organization.
• Proven experience designing, building and managing reporting workstreams.
• Strong analytical, reporting, visualization, and user-research skills.
• Advanced proficiency in Power BI and Excel.
• Experience collaborating with global teams and stakeholders at multiple levels.
• Excellent written and verbal communication skills.

Responsibilities

• Conduct deep-dive analyses to support go.transform decision-making.
• Analyze colleague experience, adoption metrics, and application usage data.
• Design, develop, and maintain dashboards and automated reporting.
• Measure program impact, digital adoption, and colleague sentiment.
• Develop executive-ready insights and communications across platforms including Power BI, SharePoint, Workday, and Microsoft 365.

Skills

Advanced Excel

Power BI

Data wrangling

SQL

Python

Power Automate

Power Query

Data modelling

Data visualization

Tools

SharePoint

Workday

Microsoft 365

Job description

The Opportunity

As a Data Analytics and Reporting Analyst on the go.transform team, you will help turn data into actionable insights that inform transformation decisions, measure adoption and business impact, identify opportunities for improvement, and support the successful scaling of new tools, processes, and ways of working across the Firm

About the Team

The go.transform team leads Egon Zehnder’s firm-wide transformation agenda, partnering across functions to design, implement, and scale new ways of working. The team focuses on driving adoption of strategic initiatives, leveraging data and insights to track progress, measure impact, and support continuous improvement. Current priorities include AI and Copilot enablement, workflow optimization, knowledge management, and broader business transformation efforts. The team works closely with business stakeholders to translate strategy into practical, measurable outcomes that enhance productivity, collaboration, and client impact.

What You’ll Do

Essential Duties and Responsibilities

• Conduct deep-dive analyses to support go.transform decision-making and identify opportunities for improvement.
• Analyze colleague experience, behavioral adoption metrics, and application usage data.
• Design, develop, and maintain dashboards, automated reporting, and performance monitoring solutions.
• Measure program impact, digital adoption, and colleague sentiment across key initiatives.
• Develop executive-ready insights, reporting, and communications for leadership across platforms including Power BI, SharePoint, Workday, and Microsoft 365.

• 2-5 years of experience in analytics, reporting, business intelligence, or a related field within a global organization.
• Proven experience designing, building, and managing reporting and analytics workstreams.
• Strong analytical, reporting, visualization, and user research capabilities.
• Advanced proficiency in Power BI and Excel.
• Experience working with global teams and stakeholders across multiple functions and organizational levels.
• Excellent written and verbal communication skills.

Key Skills & Capabilities

Technical

Advanced Excel, including Power Query and complex data modelling

Power BI, including DAX, data modelling, dashboard design, and report deployment

Data wrangling, cleansing, and transformation

SQL for data extraction and analysis

Power Automate for workflow and reporting automation

Python for analytics, automation, and data processing

Reporting automation and process optimization

Data visualization and storytelling

Business & Stakeholder

Executive reporting and presentation development

Requirements gathering and stakeholder management

Digital adoption and behavioral analytics

Colleague experience and survey analysis

Strong problem-solving and analytical thinking

Ability to translate complex data into actionable, executive-level insights and recommendations

Desirable

VBA / Macros for legacy Excel automation

Experience with SharePoint, Workday, and Microsoft 365 reporting ecosystems

Familiarity with APIs and data integrations

About Egon Zehnder

Egon Zehnder is the world’s preeminent leadership advisory firm, inspiring leaders to navigate complex questions with human answers. We help organizations get to the heart of their leadership challenges and offer honest feedback and insights to help leaders realize their true being and purpose.

We are built on a foundation that supports partnership in the truest sense of the word and aligns our interests with the interests of our clients. Our 560 consultants across 64 offices and 36 countries are former industry and functional leaders who collaborate seamlessly across geographies, industries and functions to deliver the full power of the Firm to every client, every time.

We partner closely with public and private corporations, family-owned enterprises, and non-profit and government agencies to provide executive search, leadership solutions, CEO search and succession, and board advisory.

We believe that together we can transform people, organizations and the world through leadership.

Due to high volume, we will only be contacting applicants who meet all of the minimum requirements listed in the job description. Only those applicants who align most closely with our minimum and preferred qualifications will be contacted for an interview. The Recruiting team at Egon Zehnder will retain your application materials and may contact you regarding future opportunities.

Sommaire du poste

En tant qu’analyste en analyse de données et en production de rapports au sein de l’équipe go.transform, vous contribuerez à transformer les données en informations exploitables qui éclaireront les décisions de transformation, permettront de mesurer l’adoption et l’impact sur les affaires, d’identifier les possibilités d’amélioration et de soutenir la mise en œuvre à grande échelle de nouveaux outils, processus et modes de travail à l’échelle de l’entreprise.

Présentation de l’équipe

L’équipe go.transform dirige le programme de transformation à l’échelle de l’entreprise d’Egon Zehnder, en collaborant avec toutes les fonctions pour concevoir, mettre en œuvre et déployer à grande échelle de nouveaux modes de travail. L’équipe s’attache à favoriser l’adoption d’initiatives stratégiques, en tirant parti des données et des informations pour suivre les progrès, mesurer l’impact et soutenir l’amélioration continue. Les priorités actuelles comprennent la mise en œuvre de l’IA et de Copilot, l’optimisation des flux de travail, la gestion des connaissances et des efforts plus larges de transformation de l’entreprise. L’équipe travaille en étroite collaboration avec les intervenants opérationnels afin de traduire la stratégie en résultats concrets et mesurables qui améliorent la productivité, la collaboration et l’impact auprès des clients.

Tâches et responsabilités essentielles

• Effectuer des analyses approfondies pour appuyer la prise de décision au sein de go.transform et cerner les possibilités d’amélioration.
• Analyser l’expérience des collègues, les indicateurs d’adoption comportementale et les données d’utilisation des applications.
• Concevoir, développer et assurer la maintenance de tableaux de bord, de rapports automatisés et de solutions de surveillance du rendement.
• Mesurer l’impact des programmes, l’adoption du numérique et le sentiment des collègues à l’égard des initiatives clés.
• Élaborer des analyses, des rapports et des communications destinés à la haute direction sur diverses plateformes, notamment Power BI, SharePoint, Workday et Microsoft 365.

Qualifications minimales

• 2 à 5 ans d’expérience en analyse, en production de rapports, en intelligence d’affaires ou dans un domaine connexe au sein d’une organisation internationale.
• Expérience avérée dans la conception, la mise en place et la gestion de projets liés à la production de rapports et à l’analyse.
• Solides compétences en analyse, en production de rapports, en visualisation et en recherche sur les utilisateurs.
• Maîtrise avancée de Power BI et d’Excel.
• Expérience de collaboration avec des équipes internationales et des intervenants issus de multiple fonctions et niveaux hiérarchiques.
• Excellentes compétences en communication écrite et orale.

Compétences et aptitudes clés

Techniques

Maîtrise avancée d’Excel, y compris Power Query et la modélisation complexe de données

Power BI, y compris la modélisation de données, la conception de tableaux de bord et le déploiement de rapports

Préparation, nettoyage et transformation des données

SQL pour l’extraction et l’analyse des données

Power Automate pour l’automatisation des flux de travail et de la production de rapports

Python pour l’analyse, l’automatisation et le traitement des données

Automatisation de la production de rapports et optimisation des processus

Visualisation des données et narration de données

Affaires et parties prenantes

Élaboration de rapports à l’intention de la haute direction et de présentations

Cueillette des exigences et gestion des parties prenantes

Adoption du numérique et analyse comportementale

Expérience des collègues et analyse des sondages

Solides compétences en résolution de problèmes et en réflexion analytique

Capacité à traduire des données complexes en informations et recommandations exploitables à l’intention de