Role Purpose & Context
Role Summary
The Senior Global Performance Analysis Assistant is here to lead specific workstreams within our bigger consulting projects. You'll take on tricky performance puzzles, figuring out the 'why' behind the numbers and then helping our internal clients—the business teams—understand what they need to do differently. Frankly, you're the one who turns raw, messy data into a compelling story that drives real change. You'll often be the bridge between what the data says and what our leaders need to hear to make tough calls.
When you do this job well, departments actually improve, costs drop, or revenue goes up because of your insights. Get it wrong, or fail to communicate clearly, and we risk making bad strategic decisions, wasting money, or missing big opportunities. The challenge? Dealing with vague requests, incomplete data, and sometimes, a bit of internal politics. The reward, though, is seeing your recommendations get adopted and watching the business genuinely improve because of your hard work and clear thinking. It's pretty satisfying, honestly.
Reporting Structure
- Reports to: Lead Analyst, Internal Consulting
- Direct reports: None (but you'll mentor 1-2 junior analysts)
- Matrix relationships:
Senior Performance Analyst, Internal Consultant (Performance), Business Performance Specialist,
Key Stakeholders
Internal:
- Department Directors (e.g., Sales, Marketing, Operations)
- Cross-functional Project Leads
- Finance Business Partners
- Junior Analysts (as a mentor)
External:
- External data providers (occasionally, for benchmarking)
- Technology vendors (when evaluating new tools)
Organisational Impact
Scope: Your work directly influences how our business units operate and perform. You'll provide the insights that guide strategic adjustments, process improvements, and resource allocation. Essentially, you help us avoid costly mistakes and spot opportunities for growth, making us more efficient and profitable globally. You're a key player in ensuring our internal consulting engagements deliver tangible value.
Performance Metrics
Quantitative Metrics
- Metric: Project On-Time Delivery
- Desc: Percentage of owned analysis projects and workstreams completed by the agreed deadline.
- Target: >90%
- Freq: Quarterly project reviews
- Example: You committed to deliver the Q2 Sales Performance Deep Dive by 15 June. You delivered it on 14 June, including all requested revisions. That's a win.
- Metric: Actionable Recommendations Rate
- Desc: Percentage of your analysis reports or presentations that lead to a documented business action, decision, or a new strategic discussion.
- Target: >75%
- Freq: Post-project review, stakeholder feedback
- Example: Your analysis on supply chain inefficiencies led to the Operations Director launching a new process optimisation programme. That counts.
- Metric: Mentorship Impact
- Desc: At least one junior analyst you've mentored receives a promotion or a top performance rating within an 18-month period, demonstrating your impact on their growth.
- Target: 1+ mentee success story
- Freq: Annual performance reviews, peer feedback
- Example: Sarah, who you've been coaching on SQL, just got promoted to Performance Analyst, and she credits your guidance for her improved skills and confidence.
- Metric: Accuracy & Robustness of Analysis
- Desc: The number of times your core findings or models are challenged and found to be incorrect or based on flawed assumptions by senior stakeholders.
- Target: <5% challenge rate
- Freq: Post-presentation feedback, peer review
- Example: You presented the Q1 Marketing ROI analysis to the Marketing Director, and they didn't find any holes in your methodology or data. Spot on.
Qualitative Metrics
- Metric: Stakeholder Trust & Influence
- Desc: How often senior stakeholders proactively seek your input, consult you on new initiatives, or ask you to pressure-test their ideas.
- Evidence: You're invited to early-stage planning meetings; leaders ask for your 'gut check' on new proposals; your opinions are genuinely sought before decisions are made.
- Metric: Clarity of Communication
- Desc: Your ability to translate complex analytical findings into clear, concise, and compelling narratives that non-technical audiences can easily understand and act upon.
- Evidence: Stakeholders consistently comment on the clarity of your presentations; they can summarise your key findings accurately; you can simplify complex concepts without 'dumbing them down'.
- Metric: Proactive Problem Identification
- Desc: Your knack for spotting potential performance issues or opportunities before they become critical, and bringing them to the attention of relevant teams.
- Evidence: You flag an emerging trend in customer churn before it impacts revenue; you identify an efficiency gap in a process that no one else had noticed; you suggest new areas of analysis without being asked.
- Metric: Mentorship & Knowledge Sharing
- Desc: Your effectiveness in guiding junior team members, sharing your expertise, and helping to build the overall analytical capability of the department.
- Evidence: Junior analysts consistently seek your advice; you regularly contribute to internal training or best practice documentation; your mentees show clear improvement in their analytical skills.
Primary Traits
- Trait: Forensic Skepticism
- Manifestation: You're the person who instinctively questions every number, even if it comes from a 'trusted' source. You'll ask, 'What's missing here?' or 'Does this actually make sense?' You'd rather recalculate a key metric from scratch than blindly trust a summary report that feels a bit off. You're constantly looking for the hidden assumption or the data anomaly.
- Benefit: Honestly, our recommendations influence millions of pounds in decisions. One misplaced decimal point or a flawed data source isn't just an error; it's a potential disaster. We need you to catch that multi-million-pound mistake in the forecast *before* it gets to the CFO. Your scepticism is our first line of defence against bad decisions.
- Trait: Structured Thinker
- Manifestation: When someone drops a vague problem like 'Figure out why our European sales are down,' you don't panic. Instead, you immediately start breaking it down into logical, mutually exclusive, and collectively exhaustive (MECE) pieces. You'll sketch out an issue tree, considering regions, product lines, sales channels, customer segments, and market conditions, before you even open Excel. You bring order to chaos.
- Benefit: Without a structured approach, you'll 'boil the ocean' – chasing irrelevant data, missing key drivers, and ultimately delivering a muddled answer too late. This trait ensures we tackle problems systematically, consider all angles, and get to the root cause efficiently. It's how we avoid analysis paralysis and deliver focused, impactful insights.
- Trait: Intellectual Humility
- Manifestation: You're more committed to finding the right answer than to being right yourself. If the data proves your initial hypothesis wrong, you'll openly say, 'My initial thinking was off, and here's what the numbers actually show.' You actively seek out dissenting opinions and encourage others to pressure-test your analysis, knowing it makes the final output stronger.
- Benefit: In internal consulting, trust is everything. If you're seen as someone who always has to be right, or who ignores data that contradicts their view, you'll lose credibility fast. This trait builds trust with our internal clients and leads to more accurate, unbiased insights. It's the antidote to confirmation bias, which can be fatal when you're advising senior leaders.
Supporting Traits
- Trait: Diplomatic Communicator
- Desc: You can explain incredibly complex analytical findings to a non-technical Director without them glazing over. You're also able to deliver tough news – like 'your pet project is underperforming' – in a way that's clear, data-driven, and doesn't alienate the stakeholder. It's about being direct but respectful.
- Trait: Resilient
- Desc: You'll bounce back quickly when a project gets suddenly cancelled, a brilliant recommendation is rejected for political reasons, or you spend a whole day cleaning a truly horrific dataset. You don't take it personally; you just pivot to the next challenge.
- Trait: Proactive Curiosity
- Desc: You don't just answer the question asked. You dig deeper, explore the 'question behind the question,' and often uncover insights the stakeholder didn't even know they needed. You're always looking for connections and patterns.
Primary Motivators
- Motivator: Solving Complex Puzzles
- Daily: You get a real buzz from taking a messy, ambiguous business problem and systematically breaking it down, finding the hidden connections in the data, and ultimately arriving at a clear, defensible answer.
- Motivator: Driving Tangible Impact
- Daily: You're not content with just producing reports; you want to see your analysis actually lead to changes in how the business operates, whether it's saving money, improving processes, or boosting revenue.
- Motivator: Mentoring and Developing Others
- Daily: You genuinely enjoy helping junior analysts grow their skills, sharing your knowledge, and seeing them 'click' with a new concept or solve a problem they were stuck on.
Potential Demotivators
Honestly, this role isn't for everyone. If you need a perfectly clean dataset to start with, or if you expect every single piece of your analysis to be implemented exactly as you recommend, you might find it frustrating. The reality is messier than the job posting suggests.
Common Frustrations
- The Data Janitor Reality: Expect to spend a significant chunk of your time (40-60%) finding, cleaning, and structuring data before you can even begin the 'interesting' analysis. It's not glamorous, but it's essential.
- Shifting Goalposts: You'll deliver a brilliant analysis answering the original question, only for the project sponsor to say, 'That's interesting, but now I'm more curious about this other thing...' It happens.
- Political Crossfire: Your objective data will sometimes be used as a weapon in battles between department heads. You might feel pressured to spin numbers to support a pre-existing agenda. Learning to present objective truth diplomatically is a survival skill.
- The Vague Ask: The dreaded email from a senior leader that says, 'Can you pull some numbers on customer churn?' with no specifics on timeframe, segment, or definition. This often forces you into a frustrating cycle of clarification.
- Last-Minute Fire Drills: The Friday 4 PM 'urgent' request for a complete performance deep-dive, needed for a Monday 9 AM meeting, will regularly destroy your weekend plans, especially at quarter-end. It's just part of the consulting life.
What Role Doesn't Offer
- A perfectly predictable 9-to-5 schedule (some weeks are intense, others are calmer).
- Absolute control over project outcomes (you influence, but don't always decide).
- A role solely focused on 'pure' data science (there's a lot of business context and communication involved).
ADHD Positives
- The constant variety of projects and problem-solving keeps things fresh and engaging, which can be great for focus.
- The need for rapid context-switching between different analyses can play to strengths in adaptability and quick thinking.
- High-pressure, urgent requests can sometimes create hyperfocus, leading to incredibly productive bursts.
ADHD Challenges and Accommodations
- The 'data janitor' aspect (cleaning messy data) can be repetitive and challenging for sustained attention; we can break these tasks into smaller, time-boxed chunks.
- Managing multiple, shifting priorities requires strong organisational tools and clear communication; we use structured project management boards (Jira, Asana) and daily stand-ups.
- We encourage the use of noise-cancelling headphones and offer flexible work arrangements to minimise distractions and create optimal working environments.
Dyslexia Positives
- Strong pattern recognition skills are invaluable for spotting trends and anomalies in complex datasets.
- Often excel at 'big picture' thinking and connecting disparate pieces of information, which is crucial for strategic analysis.
- Excellent verbal communication skills can be a huge asset when presenting findings and influencing stakeholders.
Dyslexia Challenges and Accommodations
- Extensive documentation and report writing can be demanding; we use grammar and spell-checking tools (e.g., Grammarly Premium) and offer peer review for all written outputs.
- Reading large volumes of text-heavy internal documents might be challenging; we encourage the use of text-to-speech software and provide summaries where possible.
- We focus on the clarity and impact of your message, not just perfect spelling or grammar. We value your insights above all.
Autism Positives
- Exceptional attention to detail, which is critical for catching errors and ensuring data accuracy.
- A strong preference for logic and data-driven conclusions, leading to objective and unbiased analysis.
- Ability to deeply focus on complex analytical problems for extended periods, delivering thorough and robust solutions.
Autism Challenges and Accommodations
- Navigating unspoken social cues and internal politics can be tricky; we aim for direct, clear communication and provide explicit feedback. Your manager will help you navigate stakeholder dynamics.
- Unexpected changes in project scope or priorities can be unsettling; we strive for transparency and provide as much advance notice as possible for shifts.
- Sensory considerations in an open-plan office; we offer quiet zones, flexible seating, and allow for headphones to manage sensory input.
Sensory Considerations
Our main office is typically an open-plan environment, which means a moderate level of background noise and activity. We do have quiet zones, focus rooms, and phone booths available. Visual stimuli are generally standard office lighting and computer screens. Social interaction is frequent, especially in meetings and collaborative sessions, but we also respect periods of deep, focused work.
Flexibility Notes
We offer hybrid working, with a mix of office and remote days, which can help in creating a comfortable and productive environment tailored to individual needs. We're always open to discussing reasonable adjustments to help you do your best work.
Key Responsibilities
Experience Levels Responsibilities
- Level: Senior Global Performance Analysis Assistant (Level 003)
- Responsibilities: Lead specific analytical workstreams from start to finish within larger internal consulting projects. This means taking ownership of the problem definition, data gathering, analysis, and presenting the findings.
- Design and implement bespoke analytical models and dashboards to answer complex business questions, often with ambiguous requirements. You'll need to figure out the best approach, not just follow a template.
- Conduct in-depth root cause analysis for performance deviations, digging into 'why' something happened, not just 'what' happened. You'll use frameworks like 5 Whys or Fishbone diagrams to get to the bottom of things.
- Mentor 1-2 junior analysts, providing guidance on data cleaning, analytical techniques, SQL queries, and effective presentation skills. You'll review their work and help them get unstuck.
- Present your findings and recommendations to mid-to-senior level internal clients (e.g., Department Directors, Project Leads). You'll need to articulate complex ideas clearly and persuasively, often defending your methodology.
- Pressure-test assumptions and challenge existing business processes or metrics when your data suggests they're flawed. This means being comfortable pushing back politely with evidence.
- Contribute to the continuous improvement of our internal consulting methodologies and best practices. If you spot a better way to do something, we want to hear about it and help you implement it.
- Supervision: You'll typically have bi-weekly check-ins with your Lead Analyst or Manager, but you'll be largely autonomous on the day-to-day execution of your workstreams. You're expected to manage your own time and project deliverables, escalating only when you hit significant roadblocks or need strategic input.
- Decision: You have full technical decision authority within the scope of your assigned workstreams (e.g., choosing the best analytical tools, selecting methodologies, defining data sources). You can recommend budget spend up to £5K for specific tools or data sets, but anything above that needs approval. You'll consult your Lead Analyst on major timeline changes or significant scope creep, but you're expected to manage most project adjustments yourself.
- Success: Success at this level means consistently delivering high-quality, actionable insights that lead to measurable business improvements. You'll be recognised for your ability to tackle complex problems independently, influence stakeholders with data, and effectively mentor junior team members. Your work will be seen as reliable and impactful.
Decision-Making Authority
- Type: Analytical Methodology Selection
- Entry: Follows pre-defined methodologies; consults supervisor for any deviation.
- Mid: Chooses appropriate standard methodologies for routine problems; consults manager for novel situations.
- Senior: Designs and selects optimal methodologies for complex, ambiguous problems; consults Lead Analyst on highly strategic or novel approaches.
- Type: Project Scope & Deliverables
- Entry: Executes tasks within defined scope; escalates any scope creep.
- Mid: Manages scope for individual tasks; proposes minor adjustments to manager.
- Senior: Defines scope for specific workstreams; negotiates with stakeholders on minor adjustments; consults Lead Analyst on major changes.
- Type: Data Source Selection
- Entry: Uses approved, pre-identified data sources.
- Mid: Identifies and uses appropriate data sources from a known list; flags potential new sources to manager.
- Senior: Identifies, evaluates, and recommends new or alternative data sources for complex analysis; assesses data quality and reliability independently.
- Type: Recommendations to Stakeholders
- Entry: Supports the team's recommendations; does not present independently.
- Mid: Presents findings and recommendations for routine analysis; manager reviews before presentation.
- Senior: Develops and presents data-driven recommendations to mid-to-senior stakeholders independently; Lead Analyst provides input on highly sensitive recommendations.
ID:
Tool: Automated Reporting Suite
Benefit: Imagine AI scripts pulling data, generating standard charts, and even drafting initial bullet-point summaries for your routine weekly or monthly performance reports. You'll spend less time on manual updates and more time interpreting the 'so what?' behind the numbers. It's like having a tireless assistant for your recurring tasks.
ID:
Tool: Anomaly Detection Engine
Benefit: Instead of manually scanning endless spreadsheets for unusual spikes or drops, our machine learning models continuously monitor key KPIs. They'll automatically flag statistically significant anomalies you might miss, shifting your focus from 'what happened?' to 'why did it happen?'—and crucially, 'what should we do about it?'
ID:
Tool: Accelerated Context Gathering
Benefit: Starting a new project often means wading through mountains of internal documents or external market research. Use a Large Language Model (LLM) to rapidly summarise these vast texts, getting you up to speed on a new business area or project in minutes, not days. Think of it as a super-fast research assistant.
ID: ✍️
Tool: First-Draft Narrative Creator
Benefit: Once your analysis is done, feed the key data points, charts, and tables into an AI tool. Prompt it to generate a first draft of your executive summary or presentation narrative, focusing on creating a clear, logical story from your findings. You'll then refine it, adding your unique insights and polish, saving hours on initial drafting.
15-25 hours weekly
Weekly time savings potential
4+ core AI tools already in use
Typical tool investment
Competency Requirements
Foundation Skills (Transferable)
Beyond the technical stuff, there are some core human skills you'll absolutely need to thrive here. These aren't 'nice-to-haves'; they're fundamental to how we operate and deliver value to our internal clients.
- Category: Communication & Influence
- Skills: Active Listening: Genuinely hearing and understanding stakeholder needs, even when they're not articulated perfectly. It's about listening to understand, not just to reply.
- Concise Presentation: Boiling down complex analysis into clear, impactful messages for senior leaders. No jargon, just the 'so what?' and the 'now what?'.
- Data Storytelling: Building compelling narratives around your data that persuade and drive action, rather than just presenting numbers.
- Diplomacy & Persuasion: Delivering difficult truths or challenging assumptions in a way that maintains relationships and encourages collaboration, not conflict.
- Category: Problem-Solving & Critical Thinking
- Skills: Structured Problem Decomposition: Breaking down large, ambiguous business problems into smaller, manageable, and logical components (e.g., using MECE frameworks).
- Root Cause Identification: Moving beyond symptoms to uncover the true underlying drivers of performance issues or opportunities.
- Hypothesis Testing: Formulating clear hypotheses and designing analyses to rigorously prove or disprove them with data.
- Bias Awareness: Recognising and mitigating cognitive biases (your own and others') that can distort analysis and decision-making.
- Category: Adaptability & Resilience
- Skills: Ambiguity Management: Comfortably working with incomplete information or vague requests, and proactively seeking clarification without getting flustered.
- Prioritisation Under Pressure: Effectively managing multiple competing 'urgent' demands and re-prioritising your workload as business needs shift.
- Learning Agility: Quickly picking up new tools, methodologies, or business domains as projects evolve.
- Constructive Feedback Incorporation: Actively seeking and applying feedback to improve your work, even when it's challenging to hear.
- Category: Collaboration & Mentorship
- Skills: Cross-functional Collaboration: Working effectively with diverse teams (Sales, Marketing, Operations) to gather data, validate findings, and implement recommendations.
- Knowledge Sharing: Proactively sharing best practices, lessons learned, and new techniques with your team.
- Coaching & Development: Guiding junior analysts through complex problems, reviewing their work, and helping them build their analytical capabilities.
- Conflict Resolution (Minor): Helping to mediate small disagreements or misunderstandings within a project team to keep things moving forward.
Functional Skills (Role-Specific Technical)
These are the specific methodologies, frameworks, and tools you'll be using day-to-day. You won't just know them; you'll be able to apply them expertly to solve real business problems.
Technical Competencies
- Skill: Root Cause Analysis (RCA)
- Desc: Systematically identifying the true underlying causes of a problem, not just the obvious symptoms. You'll use frameworks like the 5 Whys, Fishbone (Ishikawa) Diagrams, and Fault Tree Analysis to move beyond surface-level explanations and get to the core issue.
- Level: Advanced
- Skill: Balanced Scorecard (BSC) & OKRs
- Desc: Designing, implementing, and managing performance frameworks that connect day-to-day activities to strategic objectives across various perspectives (financial, customer, internal process, learning/growth). You'll help teams set meaningful Objectives and Key Results.
- Level: Advanced
- Skill: Process Mapping & Optimisation (BPMN)
- Desc: Visually diagramming complex business processes (using BPMN or similar) to identify bottlenecks, redundancies, and opportunities for improvement. You'll apply Lean/Six Sigma principles to streamline workflows and reduce waste, often recommending specific changes.
- Level: Advanced
- Skill: Financial Modelling & Variance Analysis
- Desc: Building robust models to forecast performance and conducting detailed analysis of deviations between actuals, budget, and forecast. This means decomposing variances into drivers like volume, price, mix, and efficiency to explain 'what happened' and 'why'.
- Level: Advanced
- Skill: Benchmarking (Internal & External)
- Desc: The disciplined process of comparing the performance of business units, processes, or metrics against internal high-performers or external best-in-class competitors. You'll use this to identify performance gaps and set realistic, aspirational targets.
- Level: Advanced
- Skill: Stakeholder Analysis & Management
- Desc: Identifying key stakeholders for a project, understanding their influence and interests (e.g., using a Power/Interest Grid), and developing strategies to gain buy-in, manage expectations, and navigate potential conflicts for your consulting engagements.
- Level: Advanced
Digital Tools
- Tool: Microsoft Excel
- Level: Expert
- Usage: Building robust, scalable analytical models with Power Query (M) and Power Pivot (DAX). You'll use VBA for automation and create complex, auditable spreadsheets for others to use.
- Tool: SQL (Snowflake, BigQuery)
- Level: Advanced
- Usage: Writing complex CTEs, window functions, and stored procedures to extract, transform, and analyse data from our company data warehouses. You'll also profile and debug data quality issues directly at the source.
- Tool: BI & Visualisation (Tableau / Power BI)
- Level: Expert
- Usage: Developing complex, interactive dashboards and reports from scratch. You'll use Level of Detail (LOD) expressions, custom calculations, and connect to multiple data sources to tell a clear story. You'll also mentor others on best practices.
- Tool: Enterprise Planning (Anaplan / Workday Adaptive Planning)
- Level: Power User
- Usage: Building simple modules and reports within the platform. You'll understand the impact of driver changes on financial outcomes and use the platform to support variance analysis and forecasting discussions.
- Tool: Collaboration & Documentation (Confluence / MS Teams / SharePoint)
- Level: Admin/Owner
- Usage: Structuring project sites, creating documentation templates (e.g., A3 reports, project charters), and managing team workflows in tools like Jira or Asana to ensure projects run smoothly and knowledge is shared.
- Tool: Presentation (PowerPoint / Think-Cell)
- Level: Expert
- Usage: Mastering the 'storytelling' aspect of presentations. You'll build compelling narratives, create data-driven charts (often with Think-Cell), and anticipate audience questions to deliver high-impact presentations to senior leaders.
Industry Knowledge
- Area: Internal Consulting Methodologies
- Desc: A deep understanding of the typical phases of a consulting engagement (problem definition, data collection, analysis, recommendation, implementation support) and the tools used at each stage.
- Area: Business Performance Management
- Desc: Solid grasp of key performance indicators (KPIs) across different business functions (Sales, Marketing, Finance, Operations) and how they interrelate to drive overall company performance.
- Area: Data Governance & Quality
- Desc: Understanding the importance of data quality, data lineage, and basic data governance principles to ensure the reliability and trustworthiness of your analysis.
Regulatory Compliance Regulations
- Reg: GDPR (General Data Protection Regulation)
- Usage: Understanding how to handle personal data in your analysis, ensuring all data processing complies with privacy regulations, especially when dealing with customer or employee performance data. You'll know when to anonymise or aggregate data.
- Reg: Internal Data Security Policies
- Usage: Strictly adhering to our company's internal policies for data access, storage, and sharing. You'll know who can see what data and how to protect sensitive information, especially when working with confidential performance metrics.
Essential Prerequisites
- A proven track record (5+ years) in a performance analysis, business intelligence, or internal consulting role, where you've independently led analytical projects.
- Demonstrable expert-level proficiency in Excel and advanced SQL for complex data extraction and manipulation.
- Experience designing and building interactive dashboards in Tableau or Power BI from scratch, including complex calculations.
- A solid understanding of financial concepts and experience with financial modelling or variance analysis.
- The ability to clearly communicate complex analytical findings to non-technical audiences, both verbally and in writing.
- Experience mentoring or guiding junior team members, even if informally.
Career Pathway Context
These are the skills you should already have under your belt. Think of them as the foundation that lets you hit the ground running and immediately contribute at a senior level. If you're missing a few, you might be better suited for a Mid-Level Performance Analyst role first, or you'll need to show us how you've gained equivalent experience through other means.
Qualifications & Credentials
Emerging Foundation Skills
- Skill: Prompt Engineering & LLM Integration
- Why: Critical within 6 months—this is already happening, not future. Competitors are using tools like GPT to draft reports in 10 minutes that used to take 2 hours. Analysts who figure this out will outproduce peers 3:1.
- Concepts: [{'concept_name': 'Context Windows & Token Limits', 'description': 'Understanding how much information an LLM can process at once and how to manage it for complex queries.'}, {'concept_name': 'Temperature Settings', 'description': "Knowing how to adjust an LLM's 'creativity' for different tasks, from factual summaries to brainstorming."}, {'concept_name': 'RAG Architectures', 'description': 'Implementing Retrieval Augmented Generation to connect LLMs to our proprietary internal data, ensuring accurate and relevant outputs.'}, {'concept_name': 'Output Validation & Hallucination Detection', 'description': "Developing robust methods to verify LLM outputs and identify when the AI is 'making things up'."}, {'concept_name': 'Prompt Chaining', 'description': 'Breaking down complex analytical tasks into a series of smaller, linked prompts to guide the LLM through multi-step reasoning.'}]
- Prepare: This week: Set up GitHub Copilot or a similar AI coding assistant and use it for every piece of code you write.
- This month: Build one automated report summary or initial analysis brief using an LLM API (e.g., OpenAI, Claude) with some of our internal data.
- Month 2: Experiment with RAG architectures to query internal documentation or past project reports more effectively.
- Month 3: Document your productivity gains and share your learnings (and challenges!) with the team during a knowledge-sharing session.
- QuickWin: Start using Claude or ChatGPT to draft email summaries, generate code comments, or brainstorm initial analytical approaches today—no formal approval needed, immediate benefit.
- Skill: Advanced Data Storytelling & Visualisation
- Why: Important within 12 months. As data becomes more complex, the ability to simplify and convey insights effectively becomes paramount. Static charts won't cut it. Leaders need dynamic, interactive stories that clearly articulate the 'so what?' and 'now what?'.
- Concepts: [{'concept_name': 'Narrative Design Principles', 'description': 'Structuring your analysis into a clear, compelling story arc with a beginning, middle, and actionable end.'}, {'concept_name': 'Interactive Visualisation Best Practices', 'description': 'Designing dashboards that allow stakeholders to explore data themselves, answering their own follow-up questions intuitively.'}, {'concept_name': 'Cognitive Load Management', 'description': 'Creating visuals that minimise mental effort for the audience, ensuring key insights are immediately apparent.'}, {'concept_name': 'Emotional Intelligence in Presentation', 'description': "Tailoring your presentation style and content to the audience's mood, priorities, and potential biases."}, {'concept_name': 'Micro-interactions & Animations', 'description': "Using subtle visual cues to guide the audience's attention and highlight important data points."}]
- Prepare: This week: Pick one of your recent reports and try to rewrite the executive summary as a compelling 3-minute verbal pitch.
- This month: Redesign an existing static dashboard into a more interactive version in Tableau or Power BI, focusing on user experience.
- Month 2: Read 'Storytelling with Data' by Cole Nussbaumer Knaflic and apply at least three principles to your next presentation.
- Month 3: Present your redesigned dashboard to a peer and get feedback on its clarity and impact. Look for opportunities to present to a wider audience.
- QuickWin: Before your next presentation, practice explaining your key findings to a friend or family member who knows nothing about the business. If they get it, you're on the right track.
Advancing Technical Skills
- Skill: Advanced SQL Optimisation & Data Modelling
- Why: As our data warehouses grow, inefficient queries can grind everything to a halt. You'll need to not just write SQL, but write *performant* SQL and understand how data is structured for optimal analysis.
- Concepts: [{'concept_name': 'Indexing Strategies', 'description': 'Understanding how database indexes improve query speed and when to recommend new ones.'}, {'concept_name': 'Query Execution Plans', 'description': 'Learning to read and interpret query plans to identify bottlenecks and optimise performance.'}, {'concept_name': 'Data Normalisation & Denormalisation', 'description': 'Knowing when to normalise data for integrity versus denormalise for analytical performance.'}, {'concept_name': 'Partitioning & Clustering', 'description': 'Understanding how these techniques improve query efficiency on large datasets.'}]
- Prepare: This week: Review the execution plan for your most frequently used complex SQL query and identify one area for improvement.
- This month: Take an online course on advanced SQL performance tuning (e.g., on Udemy or DataCamp).
- Month 2: Propose a small data model improvement to our data engineering team based on your analytical needs.
- Month 3: Lead a session for junior analysts on writing more efficient SQL queries.
- QuickWin: Always use `EXPLAIN` or `EXPLAIN ANALYZE` on your complex queries to see how they're actually running. It's a game-changer.
- Skill: Python for Advanced Analytics & Automation
- Why: While Excel and SQL are foundational, Python offers unparalleled power for statistical analysis, machine learning, and automating repetitive tasks. It's becoming the go-to language for deeper insights and efficiency.
- Concepts: [{'concept_name': 'Pandas for Data Manipulation', 'description': 'Mastering data cleaning, transformation, and aggregation with the Pandas library.'}, {'concept_name': 'NumPy for Numerical Operations', 'description': 'Efficiently performing complex mathematical operations on large arrays of data.'}, {'concept_name': 'Scikit-learn for Predictive Modelling', 'description': 'Applying basic machine learning algorithms (e.g., regression, clustering) to identify patterns and make predictions.'}, {'concept_name': 'API Integration', 'description': 'Connecting Python scripts to various internal and external APIs to pull data or automate workflows.'}]
- Prepare: This week: Start a free Python for Data Analysis course on a platform like DataCamp or Coursera.
- This month: Automate one small, repetitive Excel task you currently do manually using a Python script.
- Month 2: Build a simple regression model in Python to predict a business outcome (e.g., sales based on marketing spend).
- Month 3: Share your Python code with the team and demonstrate its utility for a specific analytical problem.
- QuickWin: Install Anaconda and Jupyter Notebooks today. Start by writing a simple script to read a CSV, clean a column, and save it back. You'll be amazed how quickly you pick it up.
Future Skills Closing Note
This isn't about becoming a full-blown data scientist or software engineer overnight. It's about strategically adding tools to your belt that will make you a more effective, efficient, and impactful Senior Performance Analysis Assistant. We'll support your learning journey every step of the way.
Education Requirements
- Level: Minimum
- Req: A Bachelor's degree in a quantitative field such as Economics, Finance, Business, Mathematics, Statistics, or Computer Science.
- Alts: We're open to candidates with equivalent practical experience (typically 8+ years in a highly analytical role) where you can demonstrate the same level of rigorous analytical thinking and problem-solving skills.
- Level: Preferred
- Req: A Master's degree in a related field (e.g., MBA with a specialisation in Analytics, MSc in Data Science or Business Analytics).
- Alts: While not strictly required, a Master's can give you an edge, especially if it includes a strong focus on business strategy or advanced analytical techniques. Again, equivalent experience is always considered.
Experience Requirements
You'll need roughly 5-8 years of hands-on experience in a dedicated performance analysis, business intelligence, or internal consulting role. This isn't just about being 'around' data; it's about having independently led and delivered complex analytical projects from problem definition right through to presenting actionable recommendations to senior stakeholders. We're looking for someone who has a proven track record of using data to drive measurable business improvements and who has experience mentoring junior team members.
Preferred Certifications
- Cert: Lean Six Sigma Green Belt
- Prod: Various accredited providers
- Usage: Demonstrates a structured approach to process improvement and problem-solving, which is highly relevant to optimising business performance.
- Cert: Tableau Certified Associate or Professional
- Prod: Tableau
- Usage: Validates your expertise in a key visualisation tool we use daily, ensuring you can build effective and impactful dashboards.
- Cert: SQL Certifications (e.g., Microsoft Certified: Azure Data Fundamentals)
- Prod: Microsoft, Oracle, etc.
- Usage: Confirms your advanced SQL skills, which are fundamental for data extraction and manipulation in this role.
- Cert: Project Management Qualification (e.g., PRINCE2 Foundation)
- Prod: Various
- Usage: Shows you understand how to manage projects effectively, which is key when leading analytical workstreams and dealing with deadlines and stakeholders.
Recommended Activities
- Regularly attend industry webinars and conferences on data analytics, business intelligence, and internal consulting best practices.
- Actively participate in online communities or forums related to our tech stack (e.g., Tableau community, SQL user groups) to stay current and share knowledge.
- Take advanced online courses in areas like Python for data science, advanced statistical modelling, or data storytelling.
- Seek out opportunities to mentor junior colleagues and present your work to wider internal audiences.
- Read business books and articles on strategy, operations, and financial performance to deepen your commercial acumen.
Career Progression Pathways
Entry Paths to This Role
- Path: Progression from Performance Analyst (L2)
- Time: 2-3 years as an L2
- Path: External Senior Analyst / Consultant
- Time: Direct entry with 5-8 years relevant experience
- Path: Experienced Business Analyst (from a specific function)
- Time: Direct entry with 6-9 years experience in a highly analytical business role (e.g., Senior Finance Analyst, Senior Marketing Analyst)
Career Progression From This Role
- Pathway: Lead Analyst / Internal Consultant (Level 004)
- Time: 3-5 years as a Senior Performance Analysis Assistant
Long Term Vision Potential Roles
- Title: Principal Consultant, Business Performance (Level 005)
- Time: 5-8 years from Senior Assistant
- Title: Director, Global Performance & Strategy (Level 006)
- Time: 8-12 years from Senior Assistant
- Title: Chief Performance Officer / Head of Internal Consulting (Level 007)
- Time: 12-15+ years from Senior Assistant
Sector Mobility
The skills you'll gain here are highly transferable. You could move into dedicated Business Intelligence leadership, Data Science management, or even transition into operational roles within specific business units (e.g., Head of Sales Operations) where your analytical and strategic capabilities would be invaluable. The internal consulting experience is a fantastic springboard for many different career paths.
How Zavmo Delivers This Role's Development
DISCOVER Phase: Skills Gap Analysis
Zavmo maps your current competencies against all requirements in this job description through conversational assessment. We evaluate your foundation skills (communication, strategic thinking), functional skills (CRM expertise, negotiation), and readiness for career progression.
Output: Personalised skills gap heat map showing strengths and priorities, estimated time to competency, neurodiversity accommodations.
DISCUSS Phase: Personalised Learning Pathway
Based on your DISCOVER results, Zavmo creates a personalised learning plan prioritised by impact: foundation skills first, then functional skills. We adapt to your learning style, pace, and neurodiversity needs (ADHD, dyslexia, autism).
Output: Week-by-week schedule, each module linked to specific job responsibilities, checkpoints and milestones.
DELIVER Phase: Conversational Learning
Learn through conversation, not boring modules. Zavmo uses 10 conversation types (Socratic dialogue, role-play, coaching, case studies) to build competence. Practice difficult QBR presentations, negotiate tough renewals, and handle churn conversations in a safe AI environment before facing real clients.
Example: "For 'Stakeholder Mapping', Zavmo will guide you through analysing a complex enterprise account, identifying key decision-makers, and building an engagement strategy."
DEMONSTRATE Phase: Competency Assessment
Zavmo automatically builds your evidence portfolio as you learn. Every conversation, practice scenario, and application example is captured and mapped to NOS performance criteria. When ready, your portfolio supports OFQUAL qualification claims and demonstrates competence to employers.
Output: Competency matrix, evidence portfolio (downloadable), qualification readiness, career progression score.