ETIC, Insights Reporting, Senior Associate

Line of Service

Industry/Sector

Specialism

Management Level
Senior Associate

Job Description & Summary
At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals.

In data analysis at PwC, you will focus on utilising advanced analytical techniques to extract insights from large datasets and drive data-driven decision-making. You will leverage skills in data manipulation, visualisation, and statistical modelling to support clients in solving complex business problems.

We areseekinga highly skilledInsightsReporting Specialistto support the creation of high-quality reporting outputs for large-scale research and analytics projects. The role requires advanced Excel capability, strong data literacy, and the ability to translate complex datasets into clear, impactful reporting dashboards and narrative insights.


This position suits someone who is analytical, detail-oriented, and passionate about creating efficient and automated reporting processes using Excel, AI tools, and other data manipulation methods.

TheInsightsReporting Specialist will play a critical role in deliveringaccurate, engaging reporting outputs that help clients and internal teams understand complex data quickly and effectively. This role is central to driving efficiency and insights through advanced Excel work, automation, and strong storytelling.

Key Responsibilities

Reporting Production & Data Handling

• Build andmaintaincomplex Excel-based reporting toolsand dashboards using advanced formulas, structured references, and dynamic layouts.
  

• Perform robustdata manipulationusing Excel and other tools to prepare, clean, join, and restructure datasets.
  

• Conducttwo-dimensional lookups, advanced sorts, filters, data merges, and transformative operations toconsolidateinputs from multiple sources.
  

• Design and produce high-qualityExcel charts, visualisations, and dashboardsto meet client and internal reporting needs.
  
  

• Demonstrate strongdata literacy, understanding data fundamentals, structures, joins, and quality considerations.
  

• Carry outgeneral data analysissuch as descriptive analysis, trends, comparisons, and exceptions.
  

• Interpret data patterns and work with analysts to integrate context and explain results clearly.
  
  

• Conduct thoroughquality assurance (QA)checks across all reporting outputs to ensure accuracy and consistency.
  

• Maintain strong version control and documentation of reporting processes.
  

• Identifyopportunities toimprove efficiency through AI, automation, and advanced Excel techniques, contributing to continuous process improvement.
  
  

• Translate complex data findings intoclear, concise narrativesappropriate for business stakeholders.
  

• Present data in a structured, story-led format that highlights key insights and implications.
  

• Collaborate with analysts, project managers, and delivery teams to understand reporting requirements and ensure outputs meet expectations.
  
  

• Advanced Excelexpertise, including:
  

• Nested formulas, LET/LAMBDA functions, dynamic arrays, two-way lookups
  

• INDEX/MATCH/XLOOKUP
  

• Sorting, filtering, conditional logic, text manipulation
  

• Pivot tables and pivot charts
  

• Advanced Excel charting and dashboard techniques
  
  

• Design and produce high-qualityExcel charts, visualisations, and dashboardsto meet client and internal reporting needs, this includes complex manipulation of chartsin order tosupport chart customisation features.
  

• Strongdata manipulationskills and comfort working with structured datasets from multiple sources.
  

• Demonstrateddata literacy, including understanding of data types, structures, metadata, and common data issues.
  

• Experience producing well-structured, scalable reporting outputs for recurring delivery cycles.
  

• Proven experience usingAI tools(e.g., ChatGPT, Copilot, AI Excel tools) to build efficiencies, generate formulas, enhance QA, or automate tasks.
  
  

• Strong analytical thinking and problem-solving skills.
  

• Excellent written and verbal communication skills, with the ability to translate data into meaningful insights.
  

• High attention to detail and commitment to accuracy.
  

• Ability to manage multiple tasks and deliver high-quality outputs under tight timelines.
  

• A proactive mindset with a drive for innovation, automation, and process standardisation.
  
  

• Experience with basic scripting or automation tools (e.g., Alteryx, or VBA).
  

• Experience in research, analytics, or reporting-focused delivery environments.
  

• Understanding of data visualisation best practices and principles.
  
  

Required Skills

Optional Skills
Accepting Feedback, Accepting Feedback, Active Listening, Algorithm Development, Alteryx (Automation Platform), Analytical Thinking, Analytic Research, Big Data, Business Data Analytics, Communication, Complex Data Analysis, Conducting Research, Creativity, Customer Analysis, Customer Needs Analysis, Dashboard Creation, Data Analysis, Data Analysis Software, Data Collection, Data-Driven Insights, Data Integration, Data Integrity, Data Mining, Data Modeling, Data Pipeline + 38 more

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship

Government Clearance Required

Job Posting End Date