ETIC, Insights Reporting, Senior Associate

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.

Data Literacy & Analysis

• 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.

QA & Process Excellence

• 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.

Communication & Storytelling

• 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.

Required Skills & Experience

Technical Skills

• 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.

Professional Skills

• 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.

Desirable Experience

• 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.