Senior Data Architect - Remote Opportunities Available

About the Role

Hippo is recruiting for a Senior Data Architect to join our Hippo Herd. This Senior Data Architect remote position will involve working in multi-disciplinary teams that build, support, and maintain user-centered digital solutions that offer real value and work for everyone.

As a Senior Data Architect remote, you will be part of teams that build solutions making data accessible, enabling optimization through an evidence-based approach. Engaging with our clients, you will design and implement data solutions ensuring integration with internal systems and business processes.

What You'll Do

• Define a data architecture that satisfies the data requirements of all stakeholders in an organization while adhering to the enterprise-wide data and technical strategy.
• Build and maintain appropriate Enterprise Architecture artifacts 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 governance methods to ensure ongoing integrity of the architecture design artifacts.
• Advocate for data security principles and ensure appropriate security practices are embedded in any data strategy.
• Define standards for data modeling to ensure consistency within the solution and across the enterprise.
• Evaluate APIs by analyzing documentation and sample responses.
• Analyze 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.
• Visualize insights using industry-standard reporting tools.

Requirements

• 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 providers, 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 modeling 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.
• Ability to visualize 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 is a bonus.
• Ability to make test calls to API endpoints using a tool such as Postman.

Nice to Have

• Experience with data governance frameworks.
• Familiarity with data privacy regulations.
• Experience in a consulting environment.

What We Offer

• Competitive salary and transparent pay structure.
• Contributory pension scheme (Hippo 6% with employee contributions of 2%).
• 25 days holiday plus UK public holidays.
• Access to Perkbox for a wide range of discounts.
• Critical illness cover and life assurance.
• Volunteer days and cycle-to-work scheme.
• Generous relocation support package of up to £8k.
• Flexible benefits scheme with options for private health and dental cover.