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. 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 UKs 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 Groups national garage programme Servicesure.
#INDGSF
Required Experience:
Senior IC
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 solution...
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. 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 UKs 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 Groups national garage programme Servicesure.
#INDGSF
Required Experience:
Senior IC
View more
View less