Data Solutions Architect - Financial Services - London

Job Title: Data Solutions Architect - Financial Services - London
Contract Type: Permanent
Location: London, England
Salary: £70000.00 - £80000.00 per annum
Reference: BBBH18470_1525964951
Contact Name: Carl Ashdown
Contact Email:
Job Published: May 10, 2018 16:09

Job Description

Data Solutions Architect - Financial Services - London
A global Banking group are looking to hire a Data Solutions Architect to work on desining data warehouse solutions that support OLTP and OLAP BI database solutions.


  • Architect and design Data Warehouse infrastructure and solutions
  • Gather and analyse business requirements and develop technical specifications
  • Perform data profiling to detect patterns, trends and anomalies
  • Develop overall strategic data architecture direction and provide a comprehensive road map for the Enterprise Data Warehouse
  • Effectively negotiate and influence project direction with alignment to data modelling and data management standards
  • Develop, enhance, and integrate Data Warehouses/Data Marts and Business Intelligence Solutions
  • Test, deploy and maintain Data Warehouses/Data Marts
  • Identifies, evaluates, and recommends emerging data technologies
  • Map existing or legacy logical entities to the Enterprise Data Warehouse
  • Develop dimensional models and views needed for data analytics and reporting
  • Design, develop and maintain target interface solutions to support Bank's OLTP and MI/BI systems

Required Skills:

  • ETL (Extraction, Transformation and Loading) experience required
  • In-depth PL/SQL knowledge to enhance and develop the data architecture required to support Oracle/SQL Server based applications and data warehouse environments essential.
  • Experienced in using modelling tools Erwin & ER/Studio Data Architect
  • Expert level of understanding of enterprise class ETL tools (SSIS/Informatica)
  • Strong quantitative and analytic skills are required. Proven ability to quickly earn the trust of key stakeholders
  • experience of exposure in banking industry working as Data Solution Architect / Data Modeller in the Banking domains
  • In-depth understanding of Financial Instruments that helps to translate data requirements into canonical DWH model
  • Extensive experience implementing relational database designs, data warehousing, data architecture, & data modelling, including strong knowledge of various data modelling approaches and practices
  • Hands-on experience with large/complex database implementations in Oracle and SQL Server