Data Architect and Developer

Job brief:

We widely support several teams working in Customer Lifecycle Management area for corporate and investment banking clients. Entire initiative is called KYC (Know Your Customer) and belongs to an investment area of Account Opening Process.

The work spans onboarding procedures, anti-money-laundering workflows and implementations of market and tax regulations. The solutions are frequently integrated with other systems of the bank e.g., trade capture, management reporting or CRM.

You will be responsible for:

You will drive development of a brand new tool that primarily will cover data reconciliation. Data are being sourced from different sources, so you really need to understand how to map, track and reconcile it.

You (stand-alone mostly) will mainly need to:

• Build data foundation.
• Ask and challenge business and technical requirements and required logic therere many qualified people to talk to.
• Design data pipeline with ability to track data enrichments and calculated attributes - why and how we calculated it (Data Quality needs to be enrolled for example).
• Design entire architecture - from data lake to single attributes of specific customers.
• Work with different sources of data (6-8 data sources).
• Understand well how to trace the data, where it is from again, Data Quality.
• Work with a volume that contents millions of lines of records.
• Focus on consistency completeness and correctness on result - system of records tracking.

Main skills:

• Strong understanding of Big Data tech stack, ideally 8 years of experience;
• Understanding/knowledge of Google Cloud is a significant advantage (Big Query);
• ETL / ELT hand-coding preferred (tooling e.g., Apache NiFi a plus);
• Job monitoring (e.g. Ambari), performance tuning, debugging execution plans;
• HiveQL or relational SQL;
• Scripting - e.g. BASH / Python / VBA;
• BI reporting ideally Qlik (certification or advanced knowledge a strong plus - e.g., data model / Load Script optimization).

Personal skills:

• Fluency in English both written and spoken;
• High analytical thinking with attention to detail and problem solving attitude;
• Excellent collaboration and communication skills;
• Good team player with high ability to work in international teams;
• Previous experience working in an agile environment;
• University degree in IT or relevant.