Overview
We are seeking a skilled Database Engineer / Developer to join a leading bank on a hybrid contract basis. This role focuses on supporting data engineering and transformation initiatives related to identity and privileged access data. The successful candidate will work collaboratively with technical and security teams to design robust ETL processes, integrate data from various sources, and apply governance controls, ultimately ensuring data integrity and usability for operational and analytical purposes.
Responsibilities
- Design and develop ETL processes to extract, transform, and integrate data from multiple sources.
- Collaborate with relational databases including PostgreSQL, Oracle, and SQL Server.
- Develop data extraction, transformation, and integration solutions across databases and flat-file sources including CSV, Excel, and text files.
- Translate Python-based data processing and transformation logic into scalable, production-ready ETL solutions.
- Implement data quality and governance checks across identity and privileged access data.
- Investigate data issues, identify discrepancies, and collaborate with stakeholders to resolve data quality problems.
- Support data warehousing, dimensional modelling, and reporting solutions using tools like Power BI and Tableau.
- Develop and maintain technical documentation covering data flows, transformations, processes, and controls.
Requirements
- Strong commercial experience with PostgreSQL, Oracle, and/or SQL Server.
- Extensive experience in designing and developing ETL processes.
- Proven experience in extracting, transforming, and integrating data from diverse sources.
- Solid understanding of data quality, validation, reconciliation, and governance.
- Strong proficiency in Python for data processing and automation.
- Experience with data warehousing and reporting solutions.
- Analytical and problem-solving skills with attention to detail.
- Familiarity with Git, Azure DevOps, and the Snowflake data platform is a plus.