Senior Data Architect

About The Role

Hippo is recruiting for a Senior Data Architect to join our Hippo Herd. 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.

• 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

• 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

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 (Hippo 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

At Hippo, we’re dedicated to creating a diverse, equitable and inclusive workplace that works for everyone. We understand that having a diverse team unlocks our capacity for innovation, creativity and problem solving. Only by building a community of diverse perspectives, cultures and socio-economic backgrounds can we create an environment where all can contribute and thrive.

We actively…