At a Glance
- Tasks: Lead data integration projects and transform fragmented data into a scalable model.
- Company: Pontoon, an inclusive employment consultancy focused on talent and diversity.
- Benefits: Hybrid work, competitive salary, and opportunities for professional growth.
- Other info: Join a collaborative team with a focus on innovation and best practices.
- Why this job: Make a real impact by solving complex data challenges in a dynamic environment.
- Qualifications: Experience in data integration, strong analytical skills, and proficiency in SQL and Python.
The predicted salary is between 70000 - 90000 £ per year.
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, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.
Location: Warwick / Hybrid
Contract Type: 9 months with scope to extend
Overview
We are seeking an experienced Lead Data Integration Engineer to support the delivery of a large-scale enterprise data transformation programme. 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. 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. 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.
Key Responsibilities
- Engage with business stakeholders to understand business processes, source systems and data relationships.
- Lead the discovery phase by analysing multiple fragmented data sources and identifying how they can be integrated into a scalable enterprise data model.
- Translate business requirements into technical data integration and transformation solutions.
- Design, develop and maintain scalable data pipelines across multiple enterprise systems.
- Develop ETL/ELT processes and reusable transformation logic.
- Design and implement enterprise data models that support reporting, analytics and future system onboarding.
- Integrate data into Snowflake or an equivalent cloud data platform.
- Design and implement data quality, validation and monitoring frameworks.
- Develop APIs and system integrations where appropriate.
- Identify opportunities to automate business processes across enterprise applications.
- Produce high-quality technical specifications, solution designs and implementation documentation.
- Support technical decision-making throughout discovery, design and delivery.
- Promote engineering best practice, scalable solution design and knowledge sharing across the wider team.
Essential Skills & Experience
- Proven experience delivering enterprise-scale data integration and transformation programmes.
- Strong experience working with multiple large-scale, fragmented data sources and designing scalable enterprise data models.
- Ability to combine business analysis, technical discovery and hands-on data engineering.
- Experience facilitating workshops and engaging directly with business stakeholders to gather and validate requirements.
- Strong understanding of enterprise data architecture and data modelling principles.
- Advanced SQL.
- Strong Python development experience.
- ETL/ELT development.
- Experience with Snowflake or an equivalent cloud data platform.
- Experience using Azure Data Factory, Precog or similar integration technologies.
- API development and systems integration.
- Git and DevOps practices.
- Ability to communicate effectively with both technical and non-technical stakeholders.
Desirable Skills & Experience
- SAP and/or SAP Ariba.
- Procurement, Supply Chain or Asset Management data domains.
- Power BI.
- Data Governance and Master Data Management.
- Experience working within large, complex enterprise organisations.
Please be advised: if you haven't heard from us within 48 hours, then unfortunately your application has not been successful on this occasion. We may, however, keep your details on file for any suitable future vacancies and contact you accordingly.
We use generative AI tools to support our candidate screening process. This helps us ensure a fair, consistent, and efficient experience for all applicants. Rest assured, all final decisions are made by our hiring team, and your application will be reviewed with care and attention.
Lead Data Integration Engineer in Warwick employer: Pontoon
Pontoon is an excellent employer, offering a dynamic work culture that fosters creativity and collaboration in the heart of London. With flexible working arrangements and a strong emphasis on professional development, employees are empowered to grow their skills while contributing to innovative AI-driven solutions in the banking sector. Join us to be part of a team that values your input and encourages meaningful contributions to customer experiences.
StudySmarter Expert Advice🤫
We think this is how you could land Lead Data Integration Engineer in Warwick
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Pontoon before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Pontoon.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Pontoon.
We think you need these skills to ace Lead Data Integration Engineer in Warwick
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Pontoon, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Pontoon, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Pontoon’s attention and show the tangible impact of your work.
How to prepare for a job interview at Pontoon
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Pontoon.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Pontoon.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Pontoon.
