QE Functional Tester – Data & Analytics (Lead II - Software Testing)

UST; Leeds; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

UST is seeking a Data & Analytics Test Engineer to validate data pipelines and ensure data quality across Azure-based platforms. You will design and execute automated tests, work with data engineers and product teams, and support CI/CD practices in a DataOps context.

The role requires strong SQL, Python/PySpark skills and experience with Azure Databricks, ADF and ADLS Gen2, in a hybrid setup with several Leeds-area locations.

Qualifications

• Experience testing data solutions built on Azure Databricks, ADF, ADLS Gen2, and related Azure services.
• Proficiency in SQL for data validation and complex data analysis.
• Experience with Python/PySpark for test automation and large-scale data testing.

Responsibilities

• Analyse requirements to create test scenarios, cases and plans for Data & Analytics solutions.
• Validate ingestion, transformation, aggregation, and reporting processes across Azure services.
• Perform end-to-end functional testing of data pipelines for accuracy and completeness.

Skills

Data warehouse testing

Azure Databricks

Azure Data Factory

Azure Data Lake Storage

SQL

Python/PySpark

ETL/ELT testing

Data governance

CI/CD testing

Agile/Scrum

Data modeling concepts

GIT/Azure DevOps

Tools

Azure Databricks

ADF

ADLS Gen2

GitHub

Azure DevOps

Job description

Role Description

Location

West Yorkshire-Multiple locations (Hybrid – 3 days onsite, mandatory)

Employment Type

Permanent | Fixed-Term Contract

Start Date

Immediate

Key Responsibilities

• Analyse business and functional requirements to create comprehensive test scenarios, test cases, and test plans for Data & Analytics solutions.
• Validate data ingestion, transformation, aggregation, and reporting processes across Azure Data Factory, Azure Databricks, and downstream reporting platforms.
• Perform end-to-end functional testing of data pipelines, ensuring data accuracy, completeness, consistency, and business rule compliance.
• Execute data validation, reconciliation, regression, and user acceptance testing across source, staging, curated, and reporting layers.
• Collaborate with Data Engineers, Product Managers, Business Analysts, and Architects to understand requirements and define test coverage.
• Design and execute automated data validation and reconciliation tests to improve testing efficiency and coverage.
• Support continuous testing practices within CI/CD and DataOps pipelines.
• Investigate defects, perform root cause analysis, and work closely with engineering teams to ensure timely resolution.
• Ensure traceability between requirements, test scenarios, defects, and release deliverables.
• Contribute to quality engineering best practices and continuous improvement initiatives.

Skillset

• Strong experience in Data Warehouse, Data Lake, and Lakehouse testing.
• Hands-on experience testing data solutions built on Azure Databricks, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS Gen2), and related Azure services.
• Proficiency in SQL for data validation, reconciliation, and complex data analysis.
• Experience with Python and/or PySpark for test automation, data validation, and large-scale data testing.
• Strong understanding of ETL/ELT testing, source-to-target validation, and data quality testing.
• Experience validating batch and near real-time data pipelines.
• Familiarity with GitHub, Azure DevOps, CI/CD pipelines, and automated testing frameworks. Understanding of data modelling concepts including Data Warehousing, Data Lakes, Lakehouse, and Medallion Architecture.
• Experience working within Agile delivery frameworks such as Scrum, Kanban, and Lean.
• Strong analytical, problem-solving, and stakeholder communication skills
• + Experience testing analytics, reporting, business intelligence, and data product solutions.
• Knowledge of data governance, data quality, and data reconciliation processes would be advantageous.

Skills

• Azure Data Factory
• Issue Analysis
• Regression Testing
• Data Validation