Data Warehouse Test Analyst

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.

• 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.

At TXP, we modernise businesses, at pace and scale We solve complex challenges through a connected approach that brings together technology and people.