ETL Technical Analyst

ETL Technical Analyst (Contract)

Duration: 6 Months (Possibility for extension)

Location: London/Hybrid (3 days per week on site)

Rate: A highly competitive Umbrella Day Rate is available for suitable candidates

Role Profile

The role is responsible for translating business and data requirements into scalable ETL solutions, ensuring data quality, reliability, and performance across critical systems. Working closely with Product Owners, Business Analysts, Compliance, Operations, and Technology teams, the successful candidate will contribute to the design, development, testing, deployment, and support of enterprise data solutions.

This is a hands-on technical role requiring strong expertise in ETL development, data integration, troubleshooting, and stakeholder engagement, with responsibility for supporting both project delivery and business-as-usual operations.

Key Accountabilities:

• Translate business requirements and data mapping specifications into effective ETL technical designs.
• Design, develop, enhance, and maintain ETL solutions in line with technology standards and best practices.
• Produce and review high-level and detailed solution designs.
• Conduct technical walkthroughs and peer reviews to ensure quality and consistency of deliverables.
• Create and execute unit testing plans and support system, integration, and regression testing activities.
• Validate data completeness, accuracy, and integrity through reconciliation and controls.
• Investigate and resolve ETL failures, performance issues, and production incidents.
• Perform root cause analysis and implement sustainable solutions to prevent recurring issues.
• Support deployment and release activities using established source control and deployment processes.
• Monitor, analyse, and improve ETL performance, reliability, and operational efficiency.
• Maintain technical documentation, workflows, support procedures, and testing artefacts.
• Communicate progress, risks, issues, and dependencies to key stakeholders.
• Support knowledge transfer activities and provide technical guidance to development and support teams.
• Ensure all deliverables are completed to agreed standards, within timelines, and in accordance with governance requirements.
• Contribute to continuous improvement initiatives and provide recommendations on technology enhancements and best practices.

Skills & Experience:

• Strong experience designing, developing, and supporting ETL solutions using IBM DataStage.
• In-depth understanding of DataStage architecture, components, administration, and parallel job development.
• Experience using DataStage Designer, Director, and Administrator tools.
• Strong SQL and PL/SQL development skills.
• Experience working with relational databases including Oracle, IBM Db2, and SQL Server.
• Experience with modern data platforms such as Databricks.
• Strong understanding of data integration, transformation, cleansing, validation, and reconciliation processes.
• Experience integrating data from multiple source systems and data formats, including structured and unstructured data.
• Proven ability to troubleshoot ETL failures, data quality issues, and performance bottlenecks.
• Experience tuning ETL processes and optimising query performance when working with large datasets.
• Strong analytical and problem-solving skills with the ability to perform detailed root cause analysis.
• Experience delivering solutions across the full software development lifecycle, from requirements gathering through to deployment and support.
• Experience working within Agile and/or Waterfall delivery environments.
• Excellent communication and stakeholder management skills.
• Ability to work effectively in a fast-paced, highly regulated environment and manage competing priorities.
• Experience supporting Financial Crime, Fraud Monitoring, Transaction Monitoring, Compliance, or Regulatory Reporting solutions would be advantageous.

Candidates will need to show evidence of the above in their CV in order to be considered.

If you feel you have the skills and experience and want to hear more about this role 'apply now' to declare your interest in this opportunity with our client. Your application will be observed by our dedicated team.

We will respond to all successful applicants ASAP however, please be advised that we will always look to contact you further from this time should we need further applicants or if other opportunities arise relevant to your skillset.

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.

As part of our standard hiring process to manage risk, please note background screening checks will be conducted on all hires before commencing employment.

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.