Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Validate and test data from various systems, ensuring accuracy and quality.
- Company: Join a forward-thinking company in Brierley Hill with a hybrid work model.
- Benefits: Competitive pay, flexible working, and opportunities for professional growth.
- Why this job: Be at the forefront of data quality and make a real difference in analytics.
- Qualifications: Strong T-SQL skills and experience with PySpark or Python required.
- Other info: Dynamic role with a focus on collaboration and innovation.
The predicted salary is between 36000 - 60000 £ per year.
If the following job requirements and experience match your skills, please ensure you apply promptly.
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.
Data Warehouse Test Analyst in Brierley Hill employer: TXP
Contact Detail:
TXP Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Test Analyst in Brierley Hill
✨Tip Number 1
Network like a pro! Reach out to folks in your industry on LinkedIn or at local meetups. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions related to data validation and testing. We recommend using the STAR method to structure your answers, showcasing your skills in T-SQL and PySpark.
✨Tip Number 3
Showcase your projects! If you've worked on any data warehouse or ELT pipeline projects, be ready to discuss them in detail. Bring examples of how you’ve validated data and resolved defects.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Data Warehouse Test Analyst in Brierley Hill
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with T-SQL, PySpark, and data validation. We want to see how your skills match the job description, so don’t be shy about showcasing relevant projects or roles!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the Data Warehouse Test Analyst role. We love seeing enthusiasm and a clear understanding of the responsibilities outlined in the job description.
Showcase Your Testing Experience: Since this role involves testing ELT pipelines and validating data from various systems, make sure to include specific examples of your past testing experiences. We want to know how you’ve tackled similar challenges before!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it makes the whole process smoother for everyone involved.
How to prepare for a job interview at TXP
✨Know Your Data Inside Out
Make sure you brush up on your T-SQL skills and understand the data validation processes. Be ready to discuss how you've validated data from ERP systems in the past, as this will show your expertise and relevance for the role.
✨Familiarise Yourself with ELT Pipelines
Since you'll be testing ELT pipelines using PySpark or Python, it’s crucial to have a solid grasp of these technologies. Prepare to explain your experience with them and how you've tackled challenges in previous projects.
✨Prepare for Scenario-Based Questions
Expect questions that require you to think on your feet. Practice explaining how you would design and run data quality tests or handle defects. This will demonstrate your problem-solving skills and understanding of the testing lifecycle.
✨Showcase Your Documentation Skills
Documentation is key in this role, especially for audit and compliance activities. Be prepared to discuss how you've contributed to documentation in past roles, including test cases and data quality standards, to highlight your attention to detail.
