Business Intelligence Strategist / Lead Data Analyst

Red Kite Recruitment Group; England; On-site; GBP 60,000 - 80,000; Full time

Job summary

A national recruiting firm is seeking a Business Intelligence Strategist / Lead Data Analyst to spearhead their data and reporting strategy. Responsibilities include engaging with stakeholders, building data warehouses, and transforming the reporting culture. Essential qualifications include advanced SQL expertise and experience working with non-technical stakeholders. This role offers an opportunity to develop a data-driven culture and mentor junior analysts.

Qualifications

• Hands-on experience designing and implementing data warehouses and ETL pipelines.
• Ability to define requirements and deliver insights to non-technical stakeholders.
• Experience navigating evolving requirements.

Responsibilities

• Engage with stakeholders to define requirements and reporting solutions.
• Lead transition to a robust data warehouse.
• Develop operational and advanced reports.

Skills

Advanced SQL expertise

Experience with non-technical stakeholders

Mentoring or managing experience

Tools

Power BI

Tableau

SSRS

Job description

Overview

NATIONAL BUSINESS REQUIRES PROACTIVE BUSINESS INTELLIGENCE STRATEGIST / LEAD DATA ANALYST TO SPEARHEAD DATA AND REPORTING STRATEGY, BUILDING A DATA-DRIVEN CULTURE FROM THE GROUND UP WITH A DATA WAREHOUSE-FIRST MINDSET.

TITLE: Business Intelligence Strategist / Lead Data Analyst

SALARY: £(phone number removed)

LOCATION: Office Based near Wakefield

Responsibilities

• Engage with non-technical stakeholders to identify business challenges, define requirements, and create effective reporting solutions.
• Lead the transition from reporting on production databases to a robust data warehouse as the single source of truth.
• Design and build new ETL/data pipelines to replace outdated nightly rebuild processes.
• Oversee the selection of a BI platform and manage the migration of reports, integrating them into internal systems ( 300 users) and customer-facing portals (thousands of users).
• Shift the reporting culture from Excel-heavy, tabular outputs to streamlined dashboards and KPI-focused insights.
• Develop a range of reports, from operational to advanced dashboards, including financial and forecasting models.
• Establish data standards and governance to ensure consistency and reliability across all reports.
• Explore AI/ML opportunities to enhance analytics capabilities.
• Mentor and guide a junior data analyst to support their development and contributions.

Essential Experience

• Advanced, hands-on SQL expertise.
• Proven experience designing and implementing data warehouses and ETL pipelines.
• Demonstrated ability to work with non-technical stakeholders to define requirements and deliver actionable insights.
• Comfortable navigating ambiguous or evolving requirements.
• Pragmatic approach, prioritizing timely, effective solutions over perfectionism.
• Experience mentoring or managing team members.

Preferred Experience

• Experience with SSRS
• Knowledge of embedded reporting solutions.
• Familiarity with API-driven data integration.
• Proficiency with modern BI tools (e.g., Power BI, Tableau, Looker, Metabase).
• Understanding of AI/ML applications in business intelligence.