Data Engineer
Role details
Job location
Tech stack
Job description
We are looking for an experienced Data Engineer to support the mobilisation of new contracts by integrating data and processes into the ISS data ecosystem.
This role operates within a central team and is responsible for moving contract data into ISS systems to ensure it is available, reliable and ready for reporting and insight., As ISS delivers a new data strategy, the focus is shifting away from traditional data warehouse approaches towards modern, cloud-based technologies including Databricks and Microsoft Fabric.
The role combines support for the existing Insight@ISS data warehouse with the delivery of new ingestion pipelines and data transformations that underpin contract performance and service delivery.
Key Responsibilities
Develop and maintain data ingestion pipelines using Databricks and Microsoft Fabric
Build and manage data flows across Bronze, Silver and Gold layers following Medallion Architecture principles
Support and maintain the existing UK Data Warehouse, including SQL Server and SSIS components
Design and develop SQL Server database objects including views, stored procedures and scripts
Integrate data from multiple UK and global systems, including data transfer via SFTP
Support new contract mobilisation activities through data analysis, preparation and integration
Work collaboratively with business and technical stakeholders to translate requirements into technical solutions
Requirements
Experience of ETL / ELT processes and working with a variety of data sources
Hands-on experience with Databricks and Microsoft Fabric
Strong SQL Server and T-SQL skills, including stored procedures and database views
Experience developing and supporting SSIS packages
Python scripting experience, particularly within Databricks
Strong understanding of complex datasets and relational data models
Experience working within an Agile framework
Comfortable working independently while contributing to a small central team
Able to explain complex data concepts clearly to non-technical stakeholders, Disability Confident About Disability Confident A Disability Confident employer will generally offer an interview to any applicant that declares they have a disability and meets the minimum criteria for the job as defined by the employer. It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people. For more details please go to .