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.
- Other info: Dynamic role with a focus on collaboration and innovation.
- 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.
The predicted salary is between 36000 - 60000 £ per year.
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 employer: TXP
Join a forward-thinking company in Brierley Hill as a Data Warehouse Test Analyst, where you will be part of a collaborative and innovative team dedicated to ensuring data integrity across multiple systems. Enjoy the flexibility of a hybrid work model, competitive benefits, and ample opportunities for professional growth in a supportive environment that values your contributions and fosters continuous learning.
StudySmarter Expert Advice🤫
We think this is how you could land Data Warehouse Test Analyst
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, especially those who work with data warehouses or testing. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your experience with T-SQL, PySpark, and any data validation projects you've tackled. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common data warehouse testing scenarios. Be ready to discuss how you've handled data quality issues or tested ELT pipelines in the past. Confidence is key!
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take the initiative to connect directly with us.
We think you need these skills to ace Data Warehouse Test Analyst
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. Share specific examples of how you've validated data and tested ELT pipelines in the past.
Showcase Your Technical Skills:Don’t forget to mention your familiarity with Azure data tools and any experience with data warehouses or lakes. We love seeing candidates who can hit the ground running, so highlight those technical skills!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
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. Familiarise yourself with the types of data you'll be working with, especially from ERP systems. Being able to discuss specific examples of how you've validated data in the past will really impress.
✨Get Comfortable with PySpark and Python
Since you'll be testing ELT pipelines using these languages, it’s crucial to demonstrate your proficiency. Prepare to talk about any projects where you've used PySpark or Python for data testing. Maybe even bring a small code snippet to showcase your skills!
✨Understand ETL/ELT Concepts Thoroughly
Be ready to explain the differences between ETL and ELT, and how they apply to data warehousing. You might be asked to provide examples of how you've implemented these concepts in previous roles, so have those stories ready to share.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical problems related to data quality and testing. Think through scenarios where you had to identify and resolve defects, and be prepared to walk the interviewer through your thought process and actions.
