Data Business Analyst – Fixed Term Contract

Role Overview

• Engaging with stakeholders to gather, define, and manage functional and non-functional requirements, supporting delivery through development, testing, and UAT activities.
• Conducting data profiling and analysis to support data validation, quality, and understanding for Data Engineering and Data Modelling activities.
• Supporting ETL processes by promoting best practices and validating data against Entity Relationship (ER) diagrams and data models.
• Creating and maintaining clear, concise documentation and artefacts to support data knowledge and solution understanding.
• Supporting Product Owners with stakeholder engagement, User Story and Task creation, data analysis, and solution delivery activities.
• Working closely with Data Modelling and Data Engineering teams to support the design and implementation of data solutions, including dimensionally modelled Data Warehouses and Data Lakes using the Microsoft Azure technology stack, including Azure Databricks and Azure Data Factory.
• Supporting testing activities through the creation of comprehensive test scenarios and test cases aligned to business requirements and user stories.
• Supporting Power BI Development and Support activities by:
• Gathering and documenting reporting requirements, including KPIs, metrics, filters, and business rules.
• Translating business requirements into clear reporting specifications.
• Validating report accuracy and consistency against underlying data sources.
• Performing functional testing of reports and dashboards, including filters, slicers, drill-down and drill-through functionality.
• Ensuring reporting outputs align with business requirements and agreed data models.
• Acting as a liaison between business stakeholders and Power BI developers to support successful delivery.
• Collaborating effectively with onshore teams, offshore teams, and external partners to deliver high-quality outcomes.
• Supporting wider team delivery activities, including:
• Providing effort estimates, tracking progress, and communicating status updates.
• Logging and managing defects with clear descriptions, priorities, and severity levels.
• Tracking defects through to resolution, validating fixes, and formally closing issues.
• Escalating critical risks, issues, or data integrity concerns in a proactive and timely manner.

Requirements

• Excellent communication and stakeholder management skills, with the ability to build effective working relationships across technical and business teams.
• Strong documentation skills and the ability to communicate complex information clearly to both technical and non-technical audiences.
• Strong experience using SQL for data analysis, validation, and troubleshooting.
• Excellent attention to detail with a strong focus on data quality, accuracy, and consistency.
• A good understanding of ETL processes, data warehousing concepts, and data lifecycle management.
• Familiarity with Entity Relationship (ER) diagrams and data modelling principles.
• Experience defining and executing test scenarios and test cases within Agile or similar delivery environments.
• Proven experience working with Power BI in a Business Analysis capacity, including stakeholder engagement, requirements gathering, report validation, and functional testing.
• The ability to manage multiple priorities effectively while working collaboratively across cross-functional teams.

Tech Stack

• Azure
• ETL
• SQL

Benefits

• A fully remote and flexible working set up
• 25 days annual leave, increasing by 1 day each year of service up to maximum of 30 days (plus Bank Holidays)
• 1 Privilege Day
• 4 x annual salary Life Assurance
• Market leading pension scheme through Legal & General
• Enhanced Family Friendly Policies
• Excellent learning, training, and career development opportunities
• 24/7 access to our Employee Assistance Programme
• A diverse and inclusive culture where everyone is respected and valued