Senior Data Engineer

We are seeking a Senior Data Engineer with deep expertise in SQL, data modelling, and ETL development, alongside strong experience with modern data platforms and business intelligence tools. The ideal candidate will have a proven track record of designing, building, and maintaining scalable data solutions, including enterprise-grade data warehouses, while ensuring data integrity and enabling advanced analytics across the organisation.

This role is suited to an experienced professional who can take ownership of data architecture, mentor junior team members, and drive best practices in data engineering within a collaborative IT environment.

Key Responsibilities

• Design, develop, and maintain robust, scalable ETL/ELT pipelines to integrate data from multiple systems into centralised data platforms.
• Lead the design, implementation, and ongoing maintenance of data warehouses and data lake architectures.
• Develop and optimise complex SQL queries, stored procedures, and data models to support reporting, analytics, and operational use cases.
• Define and enforce data modelling standards (e.g., dimensional modelling, star/snowflake schemas).
• Collaborate with software engineers, analysts, and business stakeholders to translate requirements into reliable and performant data solutions.
• Oversee data integration processes, ensuring high performance, reliability, and security across all pipelines.
• Implement and champion data quality, validation, and governance frameworks.
• Support and optimise datasets for BI tools such as Power BI, ensuring efficient and scalable reporting solutions.
• Work closely with IT and Infrastructure teams to design secure, scalable, and cost-effective data environments.
• Mentor and support junior data engineers, promoting best practices and continuous improvement.

Preferred Skills:

• Advanced proficiency in SQL (T-SQL or PL/SQL), including performance tuning, indexing strategies, and query optimisation.
• Strong experience with ETL/ELT tools such as SSIS, Azure Data Factory, or similar.
• Extensive experience with relational databases (e.g., MS SQL Server, PostgreSQL, MySQL).
• Proven expertise in data warehouse design, implementation, and maintenance.
• Strong understanding of data modelling techniques, including dimensional modelling.
• Hands-on experience with cloud data platforms (preferably Azure, though AWS or GCP also valuable).
• Solid understanding of data governance, data quality, and security best practices.
• Experience with programming/scripting languages (e.g., Python, .NET, PowerShell) for automation and data processing.
• Familiarity with BI tools such as Power BI or Phocas.
• Experience with version control systems (e.g., Git) and modern development practices.
• Strong analytical thinking and problem-solving skills.
• Excellent communication skills, with the ability to engage both technical and non-technical stakeholders.
• Ability to work effectively in a hybrid environment (3 days office, 2 days remote).

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 175 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.

#INDGSF