Expert ETL Developer for Correspondent Banking

at  Skillspark AB

START22-09-2024

DURATION> 12 months
emagine is currently looking for Expert ETL Developer for Correspondent Banking for one of our clients in the banking industry.

REQUIRED TECHNICAL SKILLS / COMPETENCIES

• Working experience within the areas of payment, financial crime and/or transaction monitoring systems (AML).
• Proven knowledge of at least two of the following: Python, SQL, DAX, Excel/VBA, R, Scala, C#, Tableau or any other programming language and/or visualisation tools used for data analysis.
• Understanding of the technical requirements for building entity resolution solutions.
• Understanding of the financial payment flows and financial transactional data in a bank.
• Understanding of working with risk and compliance cases when conducting analysis.
• Data modelling experience using data modelling tools like Power Designer / CA ERwin / IBM InfoSphere Data Architect / Python / SQL.
• Optimize and update logical and physical data models to support new and existing projects.
• Implement data strategies, build data flows and develop conceptual data models in collaboration with data stewards
• Perform reverse engineering of physical data models from databases and scripts.
• Ability to analyse data-related system integration challenges and propose appropriate solutions.
• Understand and translate business needs into technical long-term solutions.
• Expertise in capturing and documenting business requirements and converting these into the foundation for IT design and development
• Ability to analyse provided data and present the findings / results to PM and business stakeholders"”

Preferable skills /competencies

• Understanding of Payment systems technical architecture.
• Ability to independently carry out and drive technical workshop / activities.
• Adapts interpersonal style to suit different people or situations.
• Hands-on database design and modelling experience within single and multi-platform environments.
• Experience with Quantexa or similar network analysis tools
• Analytical experience with structured vs. unstructured customer transactional data .
• Deep understanding of the content and structure of SEPA and Swift cross border messages, both MT and MX (ISO 20022)
• Backend system validation experience and understanding any dependencies and impacts.
• Possible experience with external lookup and verification of government owned company and address data.
• Clarify, document and communicate the functional and non-functional requirements by using data, process or information modelling and drive delivery of a change initiative in alignment with the target picture to enable sustainable solutions.
• Understand the structure, dynamics, terminology and IT applications of the payment systems and work closely with stakeholders in business, IT and external partners.
• Experience working with correspondent banking related projects

DESCRIPTION OF KNOWLEDGE AND EXPERIENCE

Other skills / competencies:

• Excellent oral English skills and ability to drive a technical meeting in English
• Excellent English writing skills and ability to produce precise and relevant written material
• Being able to facilitate a technical physical or remote Teams meeting with the focus on getting a common understanding and provide results
• Being able to explain and report technical complexity in a less technical language
• Managing technical stakeholders to deliver expected results
• Making a close corporation with the Project Manager driving the project with common stakeholders
• Agile way of working Knowledge and Application
• Deals with ambiguity, making positive uses of the opportunities it presents”

Scope and type of initiative Multiple initiatives within a Programme scoped with the enhancement of the clients Cross-Border Transaction Monitoring capability.
What he /she will be doing Conducting the full range of data development and analytical activities. Working within a Programme Test Team.

The client is seeking an Expert ETL Developer with excellent analytical skills and experience from the financial sector, preferably from payment, financial crime and/or transaction monitoring systems (AML). The person will work in a Nordic based project in the bank and some travelling must be considered.