Senior Data Architect

We are looking for a Data & Analytics Senior Data Architect for an initial 1 year hybrid contract. Any public sector experience would be advantageous as would having worked in large scale digitally advanced, web orientated type organisations. High transaction numbers, high traffic websites and payments systems.

The Data & Analytics Senior Data Architect will have expert knowledge of logical and physical data models, with the ability to analyse and document existing and proposed data structures and establish how to map them to a new target data model, that they will also design themselves. They will have experience of various database and business intelligence technologies, with significant knowledge and experience in the design of data interface specifications, and the detailed design of ETL (Extract, Transform and Load) data mappings

Knowledge of emerging data technologies (preferably the Microsoft Azure Tech Stack) are desired, but strong SQL skills are expected, as is a solid understanding of JSON schemas. Experience in BI system design, including strategies for managing slowly changing dimensions, late arriving data, potentially conflicting data sources, and sensitive/personal data.

Essential experience

• 5 years + experience as a data architects working on large scale Public Sector data projects
• Ability to analyse existing data sets and determine structure and purpose of data
• Ability to create data models / data dictionaries / data lineage / detailed data mapping artefacts
• Ability to collaborate with internal and third-party teams to devise and implement data strategies and assess needs
• Knowledge of data modelling tools
• Knowledge of relational and NoSQL databases
• Knowledge of SQL
• Knowledge of JSON and JSON Schema
• Knowledge of BI System Design, including strategies for managing slowly changing dimensions, late arriving data, and potentially conflicting data sources.
• Knowledge of GDPR, and strategies for correctly handling personal data.
• Knowledge of on-premise and Microsoft Azure technologies