We are partnered with a leading professional services firm who are experts in risk, strategy, and people. The organisation delivers advice and technology driven solutions that help organisations redefine the world of work, reshape retirement and investment outcomes, and unlock health and wellbeing for a changing workforce. Do you want to help pioneer an independent app to improve the financial clarity for over 7 million individuals? Do you want to set both the data and security architectures that are required?For the chance to work on a Greenfield, Single Customer View (SCV) of the organisation's UK customers, please see below. What will you be doing in this role as a Data Architect?Setting both the data and security architectures that are required and be extensible for further data inections Applying the principles of Data Warehousing across of all the customer's data, you will evolve the structure of the databases and own the data schema to ensure that the customer, the business, and the data scientist can be served with data efficiently, effectively, and securely As the Data Architect, you will provide direction to the Data Engineers for coding ETLs / ELTs effectively and securely, and act as a QA for written code You're going to be working with Head of Customer Engagement and Digital and set the architectural standards and ensure that the business is making most of the available tools ( , Salesforce and Adobe) and identify new tools and features that the business needs The Data Architet will ensure full compliance with all relevant legislation and GDPR regulations at all times You will also have the remit to devise the database designs, data modelling, and data integrations and the ambition is to set an architectural standard within the UK that can be replicated globally What do you need to apply to this role?Extensive experience in ETL of data directly from different heterogeneous source systems like flat files, Excel, SQL, xml, json, API Experience in designing and developing complex mappings in Informatica and SSIS to load the data from various sources into the Data Warehouse, using different transformations / stages like Joiner, Transformer, Aggregator, Stored Procedure transformation Experience in Data Modelling, Designing of Logical and Physical Data Marts Experience in Data Warehouse Design and Implementation Experienced with Microsoft Azure and Microsoft Server 2012 + For more information or any questions on this role or the organisation, then please email: in the first instance.