Key responsibilities
- Test and validate transformation and pipeline logic across Fabric, ADF, and Azure SQL stored procedures, functions, and views.
- Optimise SQL logic and pipelines for performance — reducing run time and resource use, without changing results.
- Build automated data-quality and reconciliation checks (record counts, referential integrity, aggregate totals, flag/measure consistency) that can be re-run to catch issues introduced by future changes.
- Test pipeline and database changes/migrations before they reach live environments.
- Record clear, reproducible findings for both defects and optimisation opportunities, and confirm changes with the development team.
Essential skills and experience
- Advanced T-SQL
- Proven experience performance-tuning SQL
- Proven experience testing transformation and pipeline logic in Microsoft Fabric and Azure Data Factory (ADF).
- Experience with Azure SQL / SQL Server.
- Experience building automated data-quality tests/checks
- Experience with Azure DevOps — CI/CD, source control, and release processes for data solutions.
Preferred / desirable
- Experience with Power BI & DAX — testing and optimising DAX measures
- Experience parsing and validating text/string data as part of testing transformations
MUST BE ELIGABLE TO WORK IN THE UK
Rate:
Not specified
Location:
United Kingdom
IR35 Status:
Outside
Remote Status:
Not specified
Industry:
Data & Analytics
Seniority Level:
Not Specified