SQL/Data Analyst (T-SQL, Azure Data Factory, Fabric, SSIS, ERP)

SQL/Data Analyst

Duration: Initially 6 weeks - Likely to extend

Location: Dudley, West Midlands - must be able to travel on a hybrid basis

To £400.00 Per Day - Outside IR35

TXP Technology are seeking an accomplished SQL/Data Analyst to work on a Data Platform Project for a leading manufacturer in the West Midlands. The successful candidate must be able to start in August 2026 and travel to Dudley as required.

Role Overview

We're looking for a highly motivated, Midlands based SQL/Data Analyst to join our data team. This role fits a person who can validate, and chase down root cause, as well and help understand and contribute to the migration from an Informatica driven Data Warehouse to a Microsoft Fabric architecture, ensure that we match the existing data supplied to the business or understand why it has changed.

You'll work across multiple source systems (ERP platforms, data warehouses, Lakehouse pipelines) where data doesn't always arrive clean, column names don't always mean what you'd expect, and pipeline failures need a calm, methodical investigator rather than a guesser.

Required Skills & Experience

Strong hands-on SQL skills in T-SQL.
Also comfortable adapting to others such as Oracle/PL-SQL, MySQL, or PostgreSQL.
Demonstrable experience reading and debugging other people's queries/code - not just writing your own from scratch.
Solid understanding of data warehousing concepts: incremental loads, watermarking, slowly changing dimensions, staging vs. curated layers.
Comfortable investigating pipeline failures (e.g. in Azure Data Factory, Microsoft Fabric, SSIS, or similar orchestration tools) - able to read activity logs and error output to isolate the actual failure point.
Experience working with ERP or legacy source systems a strong plus (e.g. JDE, QAD, SAP, Dynamics/Axapta) - comfortable with quirky column naming conventions, Julian-style dates, and inconsistent data types across sources.
Strong analytical and root cause analysis mindset - instinctively asks "why did this actually happen" rather than stopping at "it works now."
Familiarity with Python or PySpark for notebook-based transformation logic a plus, not essential.
Experience with Informatica (PowerCenter, IICS, or similar) as we break apart an old process and migrate to MS FabricIf your profile demonstrates strong and recent experience in the above areas - please submit your application to Jackie Dean at TXP for consideration.

Please note due to the high volume of applications and to ensure a fair process, we are unable to accept phone calls. All applications must be submitted online. Rest assured, our team will review your application and provide an update via email as soon as possible

TXP takes great pride in representing socially responsible clients who not only prioritise diversity and inclusion but also actively combat social inequality. Together, we have the power to make a profound impact on fostering a more equitable and inclusive society. By working with us, you become part of a movement dedicated to promoting a diverse and inclusive workforce
Only candidates based in UK and eligible to work in UK are allowed