Lead Data Integration Engineer in Warwick

We are seeking an experienced Lead Data Integration Engineer to support the delivery of a large-scale enterprise data transformation programme.

\n

Working alongside the Project Manager, business stakeholders and the wider delivery team, you will lead the discovery, integration and transformation of data from multiple fragmented enterprise systems into a scalable, trusted enterprise data model.

\n

This role combines technical leadership with strong analytical and stakeholder engagement skills. The successful candidate will work closely with business units to understand how disparate data sources relate to one another, identify integration opportunities, and design practical, scalable data solutions as requirements emerge.

\n

This is a hands-on delivery role suited to someone who enjoys solving complex integration challenges, working through ambiguity and bridging the gap between business and technology.

• Proven experience delivering enterprise-scale data integration and transformation programmes. \n

• Strong experience working with multiple large-scale, fragmented data sources and designing scalable enterprise data models. \n

• Ability to combine business analysis, technical discovery and hands-on data engineering. \n

• Experience facilitating workshops and engaging directly with business stakeholders to gather and validate requirements. \n

• Strong understanding of enterprise data architecture and data modelling principles. \n

• Advanced SQL. \n

• Strong Python development experience. \n

• ETL/ELT development. \n

• Experience with Snowflake or an equivalent cloud data platform. \n

• Experience using Azure Data Factory, Precog or similar integration technologies. \n

• API development and systems integration. \n

• Git and DevOps practices. \n

• Ability to communicate effectively with both technical and non-technical stakeholders. \n

n \n

• Engage with business stakeholders to understand business processes, source systems and data relationships. \n

• Lead the discovery phase by analysing multiple fragmented data sources and identifying how they can be integrated into a scalable enterprise data model. \n

• Translate business requirements into technical data integration and transformation solutions. \n

• Design, develop and maintain scalable data pipelines across multiple enterprise systems. \n

• Develop ETL/ELT processes and reusable transformation logic. \n

• Design and implement enterprise data models that support reporting, analytics and future system onboarding. \n

• Integrate data into Snowflake or an equivalent cloud data platform. \n

• Design and implement data quality, validation and monitoring frameworks. \n

• Develop APIs and system integrations where appropriate. \n

• Identify opportunities to automate business processes across enterprise applications. \n

• Produce high-quality technical specifications, solution designs and implementation documentation. \n

• Support technical decision-making throughout discovery, design and delivery. \n

• Promote engineering best practice, scalable solution design and knowledge sharing across the wider team. \n

\n

Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone’s chance of being part of the workplace. We respect and appreciate people of all ethnicities, , beliefs, orientations, identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.