Data Platform Engineer
Alfred H Knight Group United Kingdom
International Trade and Development · 1,001-5,000 employees
About the role
You will design, build, and maintain modern data platform solutions, including SQL Server environments and ETL/ELT pipelines. Additionally, you will optimize data warehousing solutions and ensure data integrity across the global AHK Group.
What they look for
Requirements
Candidates must have strong experience in T-SQL development, data integration, and dimensional modelling. A degree in IT, Computer Science, Science, or Mathematics is required, along with practical experience in production data support.
Benefits
Full description
WHAT IS ON OFFER
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
Essential
- 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.
Desirable Skills & Experience
- 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.