At a Glance
- Tasks: Design and develop scalable data pipelines using Python, SQL, and Snowflake.
- Company: Join a dynamic team at a leading data platform company.
- Benefits: Competitive day rate, flexible working, and opportunities for mentorship.
- Other info: Collaborative environment with excellent growth potential and support for diversity.
- Why this job: Make a significant impact by migrating to a modern Azure-based data platform.
- Qualifications: Strong Python and SQL skills, with experience in cloud data platforms.
The predicted salary is between 60750 - 74250 £ per year.
Location: Warwick/London (2-3 days per week onsite)
Contract Length: 6 Months
Day Rate: £375 per day (Umbrella)
Overview
Our client is seeking a highly capable Data Engineer to join an established data platform team and play a key role in delivering a critical migration programme. This is an excellent opportunity for an individual eager to take ownership of technical delivery, engage with stakeholders, and mentor junior team members.
The successful candidate will contribute to the evolution of the Interconnectors Data Platform (ICDP), a cloud-based data warehouse that drives commercial, financial modelling, and operational decision-making across the organisation. The immediate focus will be on migrating existing products and workloads to a modern Azure-based data platform, ensuring that key activities are successfully delivered in the upcoming year.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines utilising Python, SQL, and Snowflake technologies.
- Support the migration of existing products and workloads to Azure-based services and modern data architectures.
- Deliver migration activities into a Medallion Architecture environment (Bronze, Silver, Gold data layers).
- Build and enhance Azure-native ingestion solutions for data sources, including APIs and SFTP platforms.
- Analyse, troubleshoot, and improve existing pipelines and legacy codebases.
- Contribute to the development of reusable ETL/ELT frameworks and engineering standards.
- Develop and maintain data quality, observability, monitoring, and reliability processes.
- Operate within established CI/CD pipelines, promoting engineering best practises and continuous improvement.
- Provide production support and investigate platform issues as needed.
- Mentor and support junior Data Engineers, sharing knowledge and enhancing team capabilities.
- Collaborate effectively with technical teams, analysts, and business stakeholders to deliver robust data solutions.
Required Skills & Experience
Essential:
- Strong Python development skills, with experience in building production-grade data solutions.
- Solid SQL expertise, including data modelling, performance tuning, optimisation, and troubleshooting.
- Hands-on experience with Snowflake or a similar modern cloud data platform.
- Familiarity with Snowflake-native technologies such as Snowpipe and Snowpark.
- Experience working with ETL/ELT frameworks and large-scale data pipelines.
- Strong understanding of Azure cloud services, including data ingestion and storage solutions.
- Intermediate to advanced experience with CI/CD pipelines and DevOps practises.
- Experience working with APIs, SFTP integrations, and external data sources.
- Ability to work independently, quickly grasp existing solutions, and hit the ground running.
- Proficiency with Git and version control best practises.
Desirable:
- Knowledge of Matillion.
- Exposure to Azure Data Factory, Microsoft Fabric, Airflow, or dbt.
- Experience in energy, utilities, trading, or market data environments.
- Familiarity with event-driven or real-time data architectures.
- Experience supporting production platforms and driving continuous improvement initiatives.
This is a fantastic opportunity for a Data Engineer looking to make a significant impact within a dynamic team. If you possess the required skills and are ready to tackle new challenges, please submit your application today!
Data Engineer in Warwick employer: Pontoon
Join a forward-thinking organisation in Warwick that values innovation and collaboration, offering a hybrid work model that promotes work-life balance. As a Strategic Comms & Engagement Lead, you'll thrive in a supportive environment that prioritises employee growth through continuous learning opportunities and a culture of open communication. With a commitment to enhancing the visibility of Asset Management, you'll be part of a dynamic team that encourages creativity and strategic thinking, making it an excellent place for those seeking meaningful and rewarding employment.
StudySmarter Expert Advice🤫
We think this is how you could land Data 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 Data 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.