ETL Developer

Proactive.IT Appointments; London; Hybrid; GBP 50,000 - 80,000; Full time

Job summary

A leading company in London is seeking an experienced ETL Application Developer for their data engineering team. This pivotal role focuses on enhancing operational resilience through capacity monitoring across systems. Candidates should possess strong skills in ETL development, SQL, and data integration from various infrastructure sources. Experience in financial environments will be advantageous.

Qualifications

• Experience in ETL development in a financial or enterprise environment.
• Proficiency with ETL tools and data extraction using RESTful APIs.
• Solid experience with SQL, especially T-SQL.

Responsibilities

• Design, develop, and maintain ETL processes to store capacity metrics.
• Integrate data from infrastructure sources.
• Ensure data quality through validation and transformation.

Skills

ETL Development

Data Extraction

SQL

Python

Data Quality

Excel VBA

RESTful APIs

Tools

Microsoft SQL Server

Control-M

SQL DTSS

Job description

Social network you want to login/join with:

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:

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