Technical Lead (Enterprise Warehouse)

Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.

The Bank's Data Store has been transformed into a Data warehouse (DWH) for Regulatory Reporting and the plan is to build a new Enterprise Data Warehouse environment. It is also intended to be the core data integration platform that not only provides data for regulatory reporting but also provide data for Risk Modelling, Portfolio Analysis, Ad Hoc Analysis & Reporting (Finance, Risk, other), MI Reporting, Data Quality Management, etc.

Due to high demand of regulatory requirements, a lot of regulatory projects are in progress to reflect regulatory requirements on existing regulatory reports and to develop new regulatory reports on MDS. Examples are IFRS9, AnaCredit, IRBB, the new Deposit Guarantee Directive (DGSD), Bank Data Retrieval Portal (BDRP), and the Fundamental Review of the Trading Book (FRTB).

Responsibilities

• As a Functional Consultant, responsible for performing detailed analysis of the Bank's Data Warehouse requirements against the business systems, the data and processes for various change request and translate to the IT changes needed. Also analyze the data flows and reporting processes, create, update and maintain functional specification documentation, document issues, support in identify root causes and find solutions. Support development of technical designs and user documentation

Skills

• At least 5-10 years of relevant experience
• Banking /Financial Services, Regulatory reporting and Enterprise Datawarehouse experience is required. Knowledge of AnaCredit and or FinRep / CoRep would be a big plus. Technical Requirements:
• Able to create and execute complex SQL queries.
• Strong understanding of Database concepts
• A good understanding of data modelling.
• A background in development.
• Experience with MS SQL Server and SSIS.
• Experience with MS Visual Studio
• Experience with data warehousing, datamarts and OLAP
• Strong experience working with interfaces and have a good understanding of ETL techniques and reporting technologies. Required Experience:
• Experienced in translating Business requirements to Technical/Functional Requirements (Creating, Updating and Maintaining functional specification document)
• Understanding of the data governance life cycle.
• Experienced in analyzing the data flows and reporting processes
• Experienced in documenting issues, support in identify root causes and find solutions.
• The ability to understand financial products and how they are reported on by Risk, Product Control and Finance departments within an investment bank.
• Experience with Jira.
• Have worked in a fast-paced BAU environment and appreciate deadlines the regulatory reporting teams are working towards.
• Pay great attention to detail and be client driven with a focus on delivery and milestones.
• Have exceptional communication skills, being able to converse with a wide variety of stakeholders including department heads.
• Experience with an agile/scrum way of working. Flexibility is a must.
• Self-starter who is proactive and driven.
• Detailed and structured way of working.
• Strong communication skills.

Nice to have

• Experience in OneSumX, Analytics tool such as Power BI / Excel / SSRS / SSAS, WinSCP
• Training on Data warehousing, BI, Data modelling, Microsoft SQL server, SSIS, Scrum