Data Platform Engineer

AHK Group; Knowsley; Remote; GBP 65,000 - 95,000; Full time

Benefits offered by this job

Pension

Life assurance

Employee assistance programme

Job summary

Alfred H Knight is hiring a Data Platform Engineer to join the Group IT team at our Prescot headquarters. The role focuses on delivering reliable data pipelines, optimising data lakehouse and warehousing solutions, and enabling analytics across the global AHK Group.

Reporting to the Data Engineering Lead, you will design, build and support data platform solutions, taking hands-on responsibility for SQL Server environments, semantic models, and ETL/ELT pipelines.

Qualifications

• Strong experience in T-SQL development within Microsoft SQL Server.
• Hands-on experience designing, building, and maintaining robust ETL/ELT pipelines using SSIS or equivalent tooling.
• Solid understanding of data warehousing concepts, relational schema design, and dimensional modelling (e.g., star schemas).
• Experience in production data environments, data validation, and issue resolution.
• Exposure to modern cloud data architectures like Microsoft Fabric / Azure Data Factory.
• Experience developing semantic models and Power BI reporting.

Responsibilities

• Design, build and support the group’s modern data platform solutions.
• Hands-on responsibility for SQL Server environments, semantic models and ETL/ELT pipelines.
• Collaborate with technical and non-technical stakeholders to translate requirements into scalable data solutions.

Skills

T-SQL Development

SQL Server

ETL/ELT pipelines

Data Warehousing

Power BI / semantic models

Cloud Data Architecture

Education

Bachelor's degree in IT/CS or related

Tools

SSIS

SQL Server

Power BI

Azure Data Factory

Git

Microsoft Fabric

Job description

Alfred H Knight has an exciting opportunity for a Data Platform Engineer to join our Group IT team at our global headquarters in Prescot, Merseyside.

Driven by strong year-on-year growth and ongoing investment back into our business, we are actively modernising our global technology and data landscape. Data sits right at the heart of our strategy, and this role plays a pivotal part in delivering reliable data pipelines, optimising our data lakehouse/warehousing solutions, and enabling modern analytics capabilities across the worldwide AHK Group.

Reporting directly to the Data Engineering Lead, you will design, build, and support our modern data platform solutions while taking hands-on responsibility for SQL Server environments, semantic models, and ETL/ELT pipelines. It’s a brilliant chance to join a growing, collaborative team where data is championed as a key strategic asset.

ABOUT US

Alfred H Knight is a totally independent, family owned business spanning five generations. A global network of strategically placed offices and laboratories enable global trade by providing independent inspection, analysis and consultancy services to the metals and minerals, solid fuels and agriculture industries.

We have honed and carefully crafted our reputation. Delivering knowledge and professionalism in all aspects of weighing, sampling and analysis. We thrive by continuing to re-invest in our facilities, technology and people. Click here to find out more about AHK.

DO YOU HAVE WHAT IT TAKES?

To be successful at Alfred H Knight you will need to display the following:

REQUIRED KNOWLEDGE AND WORK EXPERIENCE

• Database & T-SQL Development: Strong experience in T-SQL development within Microsoft SQL Server, including query optimisation, performance tuning, and routine maintenance.
• Data Integration & Pipelines: Hands-on experience designing, building, and maintaining robust ETL/ELT pipelines using SQL Server Integration Services (SSIS) or equivalent tooling.
• Data Warehousing & Modelling: Solid understanding of data warehousing concepts, relational database schema design, and dimensional modelling (e.g., star schemas).
• Data Quality & Production Support: Practical experience supporting production data environments, conducting root-cause issue resolution, and enforcing data validation and integrity controls.
• Collaborative & Solution-Focused: Proven ability to translate business requirements into scalable data solutions and communicate effectively across technical and non-technical stakeholders.
• Exposure to modern cloud data architectures, such as Microsoft Fabric (Lakehouse, Data Factory, Warehousing) or Azure Data Factory. Understanding of medallion architecture (bronze/silver/gold layers) and modern data platform patterns.
• Experience developing or working with semantic models (e.g., Power BI / Microsoft Fabric) and Power BI reporting.
• Familiarity with CI/CD practices, version control (Git), and Agile delivery methodologies.
• Understanding of data governance, security, and access control practices.

Required Qualifications

• Formal education to degree level in IT, Computer Science, Science, or Mathematics (or equivalent industry experience).

BENEFITS

We are offering an excellent opportunity with a salary and benefits package to match including pension, life assurance and an employee assistance programme.

If you are invited to interview, please let us know if there are any reasonable adjustments we can make to the recruitment process that will enable you to perform to the best of your ability.

Alfred H Knight is committed to creating a diverse & inclusive environment and hence welcomes applications from all sections of the community.