ETIC, Insights Reporting, Senior Associate

Line of Service
Advisory

Industry/Sector
Technology

Specialism
Advisory - Other

Management Level
Senior Associate

Job Description & Summary
Job Description
We are seeking a highly skilled Insights Reporting Specialist to 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.

The Insights Reporting Specialist will play a critical role in delivering accurate, 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 and maintain  complex Excel-based reporting tools  and dashboards using advanced formulas, structured references, and dynamic layouts. 
  

• Perform robust  data manipulation  using Excel and other tools to prepare, clean, join, and restructure datasets. 
  

• Conduct  two-dimensional lookups , advanced sorts, filters, data merges, and transformative operations to consolidate inputs from multiple sources. 
  

• Design and produce high-quality  Excel charts, visualisations, and dashboards  to meet client and internal reporting needs. 
  
  

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

• Carry out  general data analysis  such as descriptive analysis, trends, comparisons, and exceptions. 
  

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

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

• Maintain strong version control and documentation of reporting processes. 
  

• Identify opportunities to  improve efficiency through AI, automation, and advanced Excel techniques , contributing to continuous process improvement. 
  
  

• Translate complex data findings into  clear, concise narratives  appropriate 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 Excel expertise , 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-quality  Excel charts, visualisations, and dashboards  to meet client and internal reporting needs, this includes complex manipulation of charts in order to support chart customisation features. 
  

• Strong  data manipulation  skills and comfort working with structured datasets from multiple sources. 
  

• Demonstrated  data 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 using  AI 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, Agile Scalability, Amazon Web Services (AWS), Analytical Thinking, Apache Airflow, Apache Hadoop, Azure Data Factory, Communication, Creativity, Data Anonymization, Data Architecture, Database Administration, Database Management System (DBMS), Database Optimization, Database Security Best Practices, Databricks Unified Data Analytics Platform, Data Engineering, Data Engineering Platforms, Data Infrastructure, Data Integration, Data Lake, Data Modeling, Data Pipeline {+ 27 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements
Not Specified

Available for Work Visa Sponsorship?
No

Government Clearance Required?
No

Job Posting End Date