Data Analytics Business Analyst – Power BI & SQL

SmartSearch; Ilkley; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

25 days holiday rising to 30 with each

Private Medical Insurance covering...

Company pension scheme

Life Assurance – 4x your annual salary

1 day paid volunteering per year

Enhanced maternity / paternity offers

Employee Assistance Programme

Cycle to work scheme

Access to a gym

Job summary

SmartSearch is seeking a Business Data Analyst to shape data and analytics initiatives through strong business analysis, stakeholder engagement, and requirements definition. Reporting to the Interim Director of Data and BI, you will translate business needs into clear, actionable requirements that support reporting, insight, and process improvement.

The successful candidate will have strong experience in requirements elicitation, user story development, stakeholder workshops, and process

Qualifications

• 5–8 years of experience in business analysis, with a focus on data and analytics projects.
• Strong experience gathering, analysing, and documenting business requirements, translating them into clear user stories and acceptance criteria.
• Proven ability to facilitate workshops, capture business processes, and create process maps to identify improvements and define future-state solutions.
• Intermediate SQL skills to query, validate, and analyse data for requirements gathering and validation.
• Comfort with Power BI to review reports, interpret outputs, and support stakeholders in using insights.

Responsibilities

• Lead requirements elicitation activities with stakeholders to understand business needs, challenges, and opportunities across data and analytics initiatives.
• Document clear business requirements, user stories, acceptance criteria, and supporting artefacts to enable effective delivery.
• Facilitate stakeholder workshops and interviews to gather insights, align priorities, and refine requirements.
• Produce process maps and analyse current and future-state workflows to identify improvements and support solution design.
• Work collaboratively with technical teams to ensure requirements are translated into practical data solutions.
• Use intermediate SQL to support data analysis, investigate issues, and validate outputs.
• Work with Power BI at a consumer level to review reports, interpret outputs, and support stakeholders in using insight effectively.
• Apply data modelling concepts to support discussions with technical teams and help shape analytics solutions.
• Build strong relationships with stakeholders to ensure data and reporting solutions meet operational needs.
• Support testing, validation, and continuous improvement activities to ensure solutions are fit for purpose.
• Contribute to Agile delivery practices, collaborating with cross-functional teams to prioritise work.

Skills

Requirements elicitation & user story

SQL (Intermediate)

Stakeholder workshops & processMapping

Power BI (consumer level)

Data modelling concepts

Agile delivery experience

Experience level 5–8 years

Education

BCS International Diploma in Business Analysis

IIBA CBAP/CCBA

PL-300

Tools

Power BI

Job description

SmartSearch is seeking a Business Data Analyst to shape data and analytics initiatives through strong business analysis, stakeholder engagement, and requirements definition. Reporting to the Interim Director of Data and BI, you will translate business needs into clear, actionable requirements that support reporting, insight, and process improvement.

The successful candidate will have strong experience in requirements elicitation, user story development, stakeholder workshops, and process