Data Warehouse Developer

GSF Car Parts; Wolverhampton; On-site; GBP 80,000 - 100,000; Full time

Job summary

A leading automotive parts distributor in the UK seeks a skilled Data Warehouse Developer for a 4-6 month contract. This hands-on role involves architecting a MySQL data warehouse, managing ETL/ELT pipelines, and modernising reporting workflows with Power BI. Ideal candidates will have advanced SQL skills, experience with ETL tools, and a strong grasp of data modelling techniques.

Qualifications

• Architect, design and build MySQL data warehouse.
• Develop and manage ETL/ELT pipelines.
• Optimise database performance and troubleshoot issues.

Responsibilities

• Integrate diverse datasets for unified reporting.
• Document data models and architect decisions.
• Collaborate with stakeholders for data solutions.

Skills

Advanced SQL skills

Experience with ETL tools

Data modelling techniques

Analytical capabilities

Communication skills

Familiarity with version control

Tools

MySQL

MS SSIS

Azure Data Factory

Lobster

Git

Job description

About The Role

We’re seeking a skilled Data Warehouse Developer to lead the development of a new MySQL-based data warehouse that will unify all business data sources on a 4-6 month contract. This is a hands‑on contract role with immediate impact—ideal for someone who thrives in fast‑paced environments and enjoys building robust, scalable data infrastructure from the ground up.

You’ll be responsible for architecting the warehouse, integrating diverse datasets, and ensuring the final product is secure, compliant, and performance‑optimized. Once launched, you’ll transition into modernising reporting workflows and migrating legacy reports to Power BI.

About You

As a Data Warehouse Developer, you will:

• Architect, design, and build a MySQL data warehouse, including schema and data models.
• Develop and manage ETL/ELT pipelines to ingest data from multiple business systems.
• Optimise database performance for fast, reliable data access and reporting.
• Troubleshoot and resolve data-related issues, including pipeline failures and inconsistencies.
• Document data models, processes, and architectural decisions clearly and thoroughly.
• Collaborate with stakeholders to gather requirements and deliver tailored data solutions.
• Redevelop existing reports from various platforms and data sources into Power BI, aligned with the new warehouse.

Key Skills & Experience

• Advanced SQL skills for complex data manipulation, aggregation, and retrieval (MySQL preferred).
• Experience with ETL tools such as MS SSIS, Azure Data Factory (ADF), or Lobster.
• Strong grasp of data modelling techniques including dimensional modelling and normalisation.
• Excellent analytical and problem‑solving capabilities.
• Clear communication skills for engaging both technical and non‑technical stakeholders.
• Familiarity with version control systems such as Git.

About Us

GSF Car Parts is one of the UK’s leading automotive parts distributors, supplying thousands of independent garages throughout the UK and Ireland with parts, tools, garage equipment and specialist training. The group has over 202 branches nationwide and a turnover exceeding £475 million. Built on the heritage and success of a dozen local brand identities acquired over several years, we have traded as one brand since November 2021. Our branch network is bolstered by centralised support and expertise from specialist departments in key areas such as procurement and supply chain, marketing and national accounts. The business also benefits from integrated IT systems, which include our industry leading catalogue system, Allicat, and access to the Group’s national garage programme, Servicesure.