IT Analyst - Data Warehouse for Regulatory Reporting

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) which is the central source for Regulatory Reporting. 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).

We are currently looking to set up a Project Delivery team focusing on the Bank's Data Warehouse development for various projects.

As a Technical Analyst, 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

• At least 5-10 years of relevant experience
• Banking /Financial Services and Regulatory reporting 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.

Experience in OneSumX, Analytics tool such as Power BI / Excel / SSRS / SSAS, WinSCP

• Training on Datawarehousing, BI, Data modelling, Microsoft SQL server, SSIS, Scrum

• Competitive salary
• Luxoft Training Center
• Access to e-learning Library
• Individual development plans
• Long-term cooperation with possibility to gain experience in different projects and technologies
• A significant number of professional communities (Agile Community, Tech Community, Business Analysis Community, etc.)

• Group Life Insurance
• Private healthcare insurance – LuxMed. Unlimited access to specialist consultations with Dental Care included
• Medical costs reimbursement for employees (up to certain amount per quarter)
• Travel Insurance
• Benefit Program - Cafeteria and Multisport Card

• Various communities (sport, recreation activities, trips, board games, cultural and educational activities)
• Discounts program for employees – BeLux (banking offer, car leasing offer and cafeteria program discount)
• Convenient locations in a modern offices with game rooms
• Multinational projects for clients all over the world