Data Analytics and Reporting Analyst

Posted 5 Days Ago
Chicago, IL, USA
In-Office
35-38 Hourly
Mid level
Professional Services
The Role
Analyze adoption, usage, colleague experience, sentiment, and business impact data to support firm-wide transformation initiatives. Build and maintain Power BI dashboards, automated reports, and performance monitoring solutions. Conduct deep-dive analyses, optimize reporting processes, and translate complex data into executive-ready insights and recommendations. Collaborate with global stakeholders across functions and organizational levels to measure program outcomes and identify improvement opportunities.
Summary Generated by Built In

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.

Requirements
  • 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
The compensation range for this role is $35-$38 per hour. This position is being hired on an initial contract/temporary basis. While there may be an opportunity for consideration for regular employment in the future, any such opportunity will be based on business needs, performance, and mutual fit, and is not guaranteed

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.

Skills Required

  • 2-5 years of experience in analytics, reporting, business intelligence, or a related field within a global organization
  • 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
  • Advanced Excel skills, including Power Query and complex data modeling
  • Power BI skills, including DAX, data modeling, dashboard design, and report deployment
  • Data wrangling, cleansing, and transformation experience
  • 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 experience
  • Data visualization and storytelling skills
  • Executive reporting and presentation development skills
  • Requirements gathering and stakeholder management skills
  • Digital adoption and behavioral analytics experience
  • Colleague experience and survey analysis experience
  • Strong problem-solving and analytical thinking
  • Ability to translate complex data into actionable executive-level insights and recommendations
  • VBA or macros for legacy Excel automation
  • Experience with SharePoint, Workday, and Microsoft 365 reporting ecosystems
  • Familiarity with APIs and data integrations
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Zürich
3,000 Employees
Year Founded: 1964

What We Do

Egon Zehnder is the world’s preeminent leadership advisory firm, inspiring leaders to navigate complex questions with human answers. Our 600 consultants across 66 offices and 36 countries are former industry and functional leaders who collaborate seamlessly to deliver the full power of the Firm to every client, every time. We believe that together we can transform people, organizations and the world through leadership.

Similar Jobs

In-Office
Chicago, IL, USA
43351 Employees
75K-90K Annually

Comcast Logo Comcast

Senior Account Executive

Digital Media • Information Technology • News + Entertainment
Hybrid
Chicago, IL, USA
115000 Employees
69K-119K Annually

Comcast Logo Comcast

Engineer 4, Network Engineering, Comcast Business

Digital Media • Information Technology • News + Entertainment
Hybrid
Chicago, IL, USA
115000 Employees
104K-157K Annually

Comcast Logo Comcast

Senior Account Executive

Digital Media • Information Technology • News + Entertainment
Hybrid
Homewood, IL, USA
115000 Employees
69K-119K Annually

Similar Companies Hiring

ABN AMRO Clearing USA LLC Thumbnail
Information Technology • Professional Services • Financial Services
Chicago, IL
215 Employees
Fora Thumbnail
Agency • On-Demand • Professional Services • Sales • Software • Travel • Hospitality
New York, NY
250 Employees
Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
150 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account