At a Glance
- Tasks: Join our data team to analyse and validate data for a major migration project.
- Company: TXP Technology, a socially responsible company focused on diversity and inclusion.
- Benefits: Competitive pay of up to £400 per day and flexible hybrid working.
- Other info: Opportunity for career growth while contributing to a more equitable society.
- Why this job: Make a real impact by solving complex data challenges in a dynamic environment.
- Qualifications: Strong SQL skills and experience with data warehousing concepts required.
The predicted salary is between 104000 - 104000 £ per year.
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 as help understand and contribute to the migration from an Informatica driven Data Warehouse to a Microsoft Fabric architecture, ensuring 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 Fabric.
If 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.
SQL/Data Analyst (T-SQL, Azure Data Factory, Fabric, SSIS, ERP) in Dudley employer: TXP
At TXP, we pride ourselves on being an exceptional employer that fosters a dynamic and inclusive work culture, particularly in our Financial Services division. Our employees enjoy generous benefits such as 25 days of annual leave and private medical insurance, alongside ample opportunities for professional growth and development in the rapidly evolving FinTech landscape. Join us to be part of a forward-thinking team that values innovation and collaboration, making a meaningful impact in the world of technology sales.
