ETL Developer – 11071JS

Proactive.IT Appointments Limited; London; Hybrid; GBP 125,000 - 150,000; Full time

Job summary

A leading data engineering team is looking for an ETL Developer to enhance the organisation's operational resilience through precise capacity monitoring across critical systems. This demanding role involves developing ETL processes, collaborating with various teams for data acquisition, and ensuring compliance with regulatory requirements. The ideal candidate should have a robust background in ETL development, a solid understanding of SQL and Python, and experience in addressing data quality issues.

Qualifications

• Experience in ETL development in complex environments is essential.
• Solid experience with Microsoft SQL Server and T-SQL is required.
• Hands-on with Python for data analysis and APIs is ongoing.

Responsibilities

• Design and maintain ETL processes for capacity-related metrics.
• Collaborate with teams to deliver data acquisition solutions.
• Ensure data quality through validation and normalisation.

Skills

ETL Development

Data Quality

Data Analysis

SQL

RESTful APIs

Python

Excel VBA

Tools

Microsoft SQL Server

Control-M

SQL DTSS

Nutanix Prism Central

VMware vCenter

Dell EMC Unisphere

OpManager

Job description

11071JS
£500 – 540 per day

ETL Developer

Inside IR35 – Hybrid initially but 5 days onsite required

We are seeking an experienced and detail-oriented ETL Application Developer to join our data engineering team. This is a high-impact role dedicated to enhancing our organisation’s operational resilience by ensuring comprehensive and accurate capacity monitoring across critical systems. Your work will help mitigate potential disruptions by enabling early identification of system resource constraints.

You will collaborate with cross-functional teams to deliver infrastructure-based data acquisition solutions that support our Capacity Management function and ensure compliance with key regulatory requirements.

Key Responsibilities:

• Design, develop, and maintain ETL processes to ingest, transform, and store capacity-related metrics.

• Integrate data from diverse infrastructure sources using APIs and direct connectors.

• Ensure data quality and integrity through validation, normalization, and transformation techniques.

• Collaborate with Capacity Management and infrastructure teams to ensure timely and complete data delivery.

• Develop and implement scripts and tools (SQL, Python, Excel VBA) for data trending, analysis, and reporting.

• Optimise database storage and performance for large datasets.

• Support control and automation frameworks, including Control-M and SQL DTSS.

Required Skills & Experience:

• Experience in ETL development, ideally in a complex financial or enterprise environment.

• Proficiency with ETL tools and data extraction using RESTful APIs.

• Solid experience with Microsoft SQL Server, including writing and optimising T-SQL.

• Hands-on experience working with infrastructure data sources such as:

  • Nutanix Prism Central

  • VMware vCenter

  • Dell EMC Unisphere

  • OpManager

• Working knowledge of:

  • Python (for data analysis/trending)

  • Excel VBA (2019+)

  • JSON, XML, and other data interchange formats

• Experience addressing data quality issues (especially related to time-series data).

• Familiarity with SQL DTSS, Control-M, and writing SQL control parameters is highly desirable.

ETL Developer

Due to the volume of applications received for positions, it will not be possible to respond to all applications and only applicants who are considered suitable for interview will be contacted.

Proactive Appointments Limited operates as an employment agency and employment business and is an equal opportunities organisation

We take our obligations to protect your personal data very seriously. Any information provided to us will be processed as detailed in our Privacy Notice, a copy of which can be found on our website http://proactive.it/privacy-notice/