Data Platform Engineer

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.

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

• pension
• life assurance
• 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.