Responsible for designing and implementing Aviva target data architecture, working closely with business stakeholders, data analysts, and data engineers to understand the data requirements and objectives, and to design data models, schemas, and policies that meet those needs. The role holder will have the following technical data skills:
• Ability to use data modelling techniques such as entity-relationship diagrams, dimensional modelling, and schema design to represent data structures and relationships in a logical and conceptual way.
• Proficiency in:
o the use of database management systems like SQL, NoSQL, or cloud-based databases to store, query, and manipulate data in a structured and consistent way;
o data integration tools like ETL (extract, transform, load), ELT (extract, load, transform), or data pipelines for moving, transforming, and combining data from different sources and formats.
o data quality tools such as data profiling, data cleansing, data validation, and data auditing for ensuring that the data is accurate, complete, consistent, and relevant; and
• data governance tools like data catalogues, dictionaries, lineages, and policies in order to define and enforce the rules for managing the data lifecycle and usage