Senior Data Architect - London (Hybrid) - Initial 12 months contract Job Title: Senior Data Architect Location: London (Hybrid) Contract: Initial 12 months Salary: £600 - £800/day (Inside IR-35) Hours: Full-time
Role details - Senior Data Architect
We are currently looking for a Senior Data Architect to support a reputable organisation on an initial 12-month contract.
As the Senior Data Architect, you will be a member of one of the Agile development streams, responsible for the creation and maintenance of conceptual, logical and physical data models for Data and Analytics (D&A) being worked on within their stream.
Role responsibilities of the Senior Data Architect
- Responsible for creating models to the standards defined by the Lead Data Modeller in both process and documentation.
- Creation and maintenance of data models within the model repository
- Creation of Physical and Logical data models in line with the Conceptual model and therefore in line with the Data and Analytics Strategy.
- Generating the Data Definition Language (DDL) used to create/amend the database schema for each environment it will be implemented into.
- The migration of legacy data models into the D&A target model, including importing existing data models from new sources to generate a data model.
- Responsible for the database standards in terms of naming conventions and schema design within models produced.
- Accountable that the physical models produced by the D&A data modellers are compliant with the conceptual model and support the needs of the business in regard to performance, data quality and simplicity.
- To produce data modelling artefacts as agreed in the D&A delivery framework to the required quality standards
- Accountable for facilitating data modelling sessions with senior level business owners to create the data model for new or enhanced data sets.
- Accountable for the creation of a project logical model during the requirements analysis phase, and ensuring any changes to the conceptual, logical or physical models as part of a project are captured and the relevant models updated.
Skills required of the Senior Data Architect
- Detailed working knowledge of Business Intelligence, Data warehousing, Data modelling and dealing with big data
- Knowledge of star schema structure & design, understanding of Kimball & Inmon data warehouse design
- Understanding of Agile development approach
- Knowledge of relevant national and international legislation pertaining to the Government/Public Sector IT – e.g. Data Protection Act, EU Procurement Directives and Freedom of Information Act, including knowledge of basic confidentiality and data protection requirements that apply to the processing of customer information.
- Experience working with a data modelling tool such as Erwin.
- Experience with writing SQL and running queries on multiple database technologies in support of data analysis.
Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates
Senior Data Architect - London (Hybrid) - Initial 12 months contract Job Title: Senior Data Architect Location: London (Hybrid) Contract: Initial 12 months Salary: £600 - £800/day (Inside IR-35) Hours: Full-time