Data Warehouse Test Analyst
Contract Length: 6 months
Location: Brierley Hill
Hybrid (2-3 days per month onsite)
Our client is looking for a Data Warehouse Test Analyst who will play a key role in validating data from multiple ERP and operational systems, testing ELT pipelines, and ensuring business rules and transformations are applied correctly.
What you'll do:
Validate data ingested from ERP, customer service and operational platforms.
Design and run data quality, reconciliation and source to target tests.
Test ELT pipelines built in Fabric Notebooks using PySpark/Python.
Validate incremental loads, full refreshes, error handling and pipeline performance.
Identify, document and track defects through to resolution.
Support regression testing and UAT with business users.
Translate business and technical specifications into clear test cases.
Contribute to data quality rules, standards and testing templates.
Provide documentation to support audit and compliance activities.
Essential skills & experience:
Strong T‑SQL for data validation and analysis.
Experience with PySpark or Python for data testing.
Background in testing data warehouses, data lakes or analytics platforms.
Solid understanding of ETL/ELT concepts and SCDs.
Experience validating data from ERP systems (e.g., finance, supply chain, manufacturing).
Exposure to Azure data tools (Synapse, Data Factory, Fabric, Databricks).
Familiarity with Microsoft Fabric Lakehouse (Desirable)
Strong understanding of data quality dimensions.
If this role sounds of interest, please apply and send an up to date CV for consideration