ETL Developer in Hull

ETL Developer in Hull

Hull Full-Time 36000 - 60000 Β£ / year (est.) On-site
V

At a Glance

  • Tasks: Redesign and develop ETL pipelines for a modern data warehouse using Azure Data Factory.
  • Company: Join a public sector organisation in Yorkshire & Humber focused on enhancing data infrastructure.
  • Benefits: Enjoy opportunities for remote work and professional development in a supportive environment.
  • Other info: This role offers a chance to work on cutting-edge technology in a collaborative team.
  • Why this job: Be part of a transformative project that impacts public services and enhances your tech skills.
  • Qualifications: Experience with ETL pipelines, SQL Server, and a passion for data optimisation required.

The predicted salary is between 36000 - 60000 Β£ per year.

We are currently supporting a public sector organisation in the Yorkshire & Humber region that is seeking a forward-thinking ETL Developer to help modernise and enhance their data infrastructure. This role will focus on redesigning and refreshing existing ETL pipelines, which currently use a combination of Python and SSIS, to support the transition to a new centralised data warehouse. The successful candidate will play a key part in migrating these pipelines to Azure Data Factory and providing ongoing support and iteration.

Key Responsibilities:

  • Redesign and develop new ETL pipelines to support modern data warehousing.
  • Migrate and refine existing pipelines from on-premise solutions to Azure Data Factory.
  • Access and work with SQL Server databases, including writing T-SQL queries and stored procedures.
  • Support and maintain both new and existing ETL processes.
  • Structure and prepare data to optimise performance and enable deeper insights.

Skills & Experience:

  • Proven experience writing new ETL pipelines.
  • Strong understanding of data structuring for performance and analytical use.
  • Confident in working with SQL Server, including advanced T-SQL and stored procedures.
  • Experience refining, modernising, and migrating ETL pipelines.
  • Ability to provide system support and continuous improvement to existing solutions.

If you like the sound of the role, please apply and we'll be in touch!

ETL Developer in Hull employer: Venn Group

As a leading university in London, we pride ourselves on fostering a supportive and inclusive work environment that values collaboration and professional growth. Our Governance & Legal Services team is dedicated to service excellence, offering employees the chance to engage in meaningful work while benefiting from hybrid working options and continuous improvement initiatives. Join us to be part of a culture that prioritises accuracy, professionalism, and the development of your career in higher education.

V

Contact Details:

Venn Group Recruitment Team

StudySmarter Expert Advice🀫

We think this is how you could land ETL Developer in Hull

✨Tip Number 1

Familiarise yourself with Azure Data Factory, as this is a key component of the role. Consider taking an online course or watching tutorials to get hands-on experience with its features and functionalities.

✨Tip Number 2

Brush up on your T-SQL skills, especially in writing complex queries and stored procedures. Practising with real datasets can help you demonstrate your proficiency during discussions.

✨Tip Number 3

Network with professionals in the data engineering field, particularly those who have experience with ETL processes. Engaging in relevant forums or LinkedIn groups can provide insights and potentially lead to referrals.

✨Tip Number 4

Prepare to discuss your past experiences with modernising ETL pipelines. Be ready to share specific examples of challenges you faced and how you overcame them, as this will showcase your problem-solving skills.

We think you need these skills to ace ETL Developer in Hull

ETL Development
Python
SSIS
Azure Data Factory
SQL Server
T-SQL
Stored Procedures

Some tips for your application 🫑

Tailor Your CV:Make sure your CV highlights your experience with ETL pipelines, particularly in Python and SSIS. Emphasise any projects where you've migrated data to Azure Data Factory or worked with SQL Server.

Craft a Compelling Cover Letter:In your cover letter, explain why you're passionate about modernising data infrastructure. Mention specific examples of how you've redesigned ETL processes and the impact it had on performance and insights.

Showcase Relevant Skills:Clearly outline your skills in T-SQL and your experience with data structuring. Provide examples of how you've optimised ETL processes in previous roles to demonstrate your capability.

Proofread Your Application:Before submitting, double-check your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for an ETL Developer role.

How to prepare for a job interview at Venn Group

✨Showcase Your ETL Expertise

Be prepared to discuss your previous experience with ETL pipelines in detail. Highlight specific projects where you redesigned or migrated pipelines, especially if you used Python or SSIS. This will demonstrate your hands-on knowledge and problem-solving skills.

✨Demonstrate SQL Proficiency

Since the role requires strong SQL Server skills, brush up on your T-SQL queries and stored procedures. Be ready to answer technical questions or even solve problems on the spot to showcase your ability to work with databases effectively.

✨Understand Azure Data Factory

Familiarise yourself with Azure Data Factory and its functionalities. If you have experience migrating pipelines to this platform, share those insights. If not, show your willingness to learn and adapt to new technologies, as this is crucial for the role.

✨Prepare for Scenario-Based Questions

Expect scenario-based questions that assess your approach to redesigning ETL processes and optimising data performance. Think of examples from your past work where you faced challenges and how you overcame them, as this will highlight your analytical thinking and adaptability.