Senior Data Architect
Edinburgh, Scotland, United Kingdom
JOB DESCRIPTION
About The Role
We are recruiting for a Senior Data Architect to join our team. Our Senior Data Architect will work in multi-disciplinary teams that build, support & maintain User-Centred digital solutions that offer real value and work for everyone.
As a Senior Data Architect , you will be working as part of teams to build solutions that make data accessible to enable solutions to be optimised by using an evidence-based approach. Engaging with our clients you will design and implement data solutions ensuring solutions are integrated with internal systems and business processes.
Your role in a nutshell:
Define a data architecture that satisfies the data requirements of all stakeholders in an organisation and adheres to the enterprise wide data and technical strategy
Build and maintain appropriate Enterprise Architecture artefacts including Entity Relationship Models, Data Dictionary, ETL/ELT definitions and Data Pipeline/Lineage Models
Be accountable to the client for the rationale of the architecture and detailed solution
Define the methods of governance to ensure ongoing integrity of the architecture design artefacts
Be an advocate of data security principles and ensure appropriate security practices are embedded in any data strategy
Define standards for data modelling to ensure consistency within the solution and across the enterprise
Evaluate APIs by analysing documentation and sample responses
Analyse candidate data sources for content, timeliness and integrity
Reverse-engineer data models from a live system
Create Agile stories for the implementation of the solution and support the engineering team throughout development
Support third party suppliers in developing specifications that ensure compatibility between client and supplier systems
Support integration and reconciliation testing
Visualise insights using industry standard reporting tools
About the Candidate:
Proven experience in defining data architectures to satisfy multiple stakeholders with varying data proficiency
Thorough understanding of data lake and data warehousing principles and full project involvement in one or more major technology platforms, e.g. Snowflake, Databricks
Proven experience with one or more Cloud Services provider, e.g. AWS, Azure or Google Cloud Platform.
Good understanding of role-based access control, its importance in data security and methods of implementation
Excellent data modelling skills in designing data warehouses and datamarts
Experience of migrating data from legacy on-prem systems to cloud architectures
Knowledge of OLTP and OLAP principles and evidence of building such solutions
Evidence of building and managing the evolution of entity relationship models, data dictionaries and ELT/ETL models
Ability to visualise outputs using leading reporting tools such as Power BI (with custom DAX) and/or Tableau
High proficiency in SQL. Knowledge of SQL Server, SSMS, SSIS and SSRS a bonus
Ability to make test calls to API endpoints using a tool such as Postman
About The Company
As well as a competitive salary which we’re transparent about from the outset, you can also expect a range of benefits:
Contributory pension scheme (company 6% with employee contributions of 2%)
25 days holiday plus UK public holidays
Perkbox access for a wide range of discounts
Critical illness cover
Life assurance and death in service cover
Volunteer days
Cycle-to-work scheme for the avid cyclists
Salary sacrifice electric vehicles scheme
Season ticket loans
Financial and general wellbeing sessions
Flexible benefits scheme with options of:
private health cover
private dental cover
additional company pension contributions
additional holidays (up to an extra 2 days)
wellbeing contribution
charity contributions
tree planting