Lead Business Intelligence Analyst

The Team Leader Business Intelligence & Analytics will lead a team of 5–6 Business Analysts

and Senior Analysts delivering business analysis, reporting, dashboards and advanced

analytics for Retail and Consumer Packaged Goods operations. The role combines people

leadership, delivery governance, stakeholder management and hands-on technical oversight.

The incumbent will translate commercial priorities into a structured analytics roadmap, ensure

consistent KPI definitions and data quality, and deliver actionable insights across sales,

merchandising, pricing, promotions, customer, inventory and supply-chain functions.

Key Responsibilities

• Lead, coach and develop a team of 5–6 Business Analysts and Senior Analysts, setting clear

goals, allocating work and reviewing delivery quality.

• Own the analytics delivery portfolio, including demand intake, prioritisation, resource planning,

timelines, risks, dependencies and stakeholder communication.

• Partner with business leaders to translate strategic and operational questions into analytical

workstreams, KPIs, dashboards and measurable recommendations.

• Provide hands-on technical direction and conduct solution, code, query, data-model and

dashboard reviews.

• Drive analytics across Retail and CPG areas including sales, assortment, pricing, promotions,

customer behaviour, loyalty, store or channel performance, inventory, demand forecasting and

supply chain.

• Define and govern KPI frameworks, metric definitions, reusable datasets and reporting standards

across functions.

• Oversee the design and delivery of scalable Power BI dashboards, executive scorecards and self-

service analytics solutions.

• Guide the development and optimisation of SQL queries, Python solutions, Databricks pipelines

and Alteryx workflows.

• Ensure accuracy, reconciliation, lineage, access control, documentation and timely refresh of

business-critical data products.

• Present insights, business cases and recommendations to senior management using clear and

compelling data storytelling.

• Establish delivery standards, review mechanisms, reusable templates and best practices for

analysis, visualisation and documentation.

• Monitor team capacity, service levels and delivery metrics; remove blockers and escalate risks

when required.

• Build team capability through mentoring, knowledge sharing, training plans and succession

development.

• Collaborate with data engineering, IT, finance, sales, marketing, merchandising and supply-chain

teams to improve data availability and adoption.

• Identify opportunities to automate manual reporting, improve platform performance and reduce

compute or processing costs.

• Promote a culture of ownership, collaboration, continuous improvement and data-driven

decision-making.

Qualifications and Experience

• Bachelor’s or master’s degree in Data Science, Statistics, Mathematics, Computer Science,

Engineering, Business Analytics, Economics or a related field.

• 8+ years of experience in business intelligence, analytics, business analysis, data analytics or

decision support.

• Proven experience leading, mentoring and managing a team of Business Analysts and Senior

Analysts.

• Demonstrated ownership of multiple analytics projects, stakeholder expectations and delivery

priorities.

• Strong experience working with large, multi-source datasets, enterprise reporting environments

and data-quality controls.

• Significant Retail and CPG experience is required, with an understanding of commercial,

customer, merchandising, pricing, promotion, inventory and supply-chain metrics.

Technical Skills

• SQL: Advanced querying, joins, CTEs, window functions, stored procedures, data validation and

performance optimisation.

• Python: Strong working knowledge of pandas, data preparation, automation, reusable analysis

and analytical scripting.

• Power BI: Data modelling, DAX, Power Query, semantic models, row-level security, deployment,

refresh management and performance tuning.

• Databricks: Databricks SQL, notebooks, Spark SQL, PySpark, Delta Lake, workflows, job

monitoring, data pipelines and compute optimisation.

• Alteryx: Workflow design, data blending, transformation, macros, scheduling, automation and

production support.

• Retail and CPG analytics: Sales, pricing, promotions, assortment, customer segmentation,

loyalty, store or channel performance, inventory, forecasting and supply-chain analysis.

• Data practices: ETL concepts, dimensional modelling, KPI governance, data quality, lineage,

security, documentation and release controls.

• Delivery practices: Agile ways of working, backlog management, estimation, prioritisation, risk

management and stakeholder reporting.

Core Competencies

• People leadership, coaching and performance enablement.
• Strong business acumen with deep Retail and CPG domain understanding.
• Strategic thinking combined with hands-on analytical and technical judgment.
• Excellent stakeholder management, negotiation and executive communication skills.
• Ability to prioritise competing demands and deliver through a team in a fast-paced environment.
• Strong problem-solving, decision-making and escalation management.
• Commitment to data accuracy, governance, confidentiality and ethical use.
• Ownership, collaboration and a continuous-improvement mindset.Role & responsibilities

Preferred candidate profile