Lead Data Architect

About The Role Hippo is recruiting for a Lead Data Architect to join our Hippo Herd. Our Lead Data Architect will work in multi-disciplinary teams that build, support & maintain user-centred data solutions that offer real value and work for everyone.As a Lead Data Architect , you will be responsible for contributing to and implementing data governance standards that ensure that our clients\’ data is high quality and fit for purpose. You will design and implement solutions on leading edge data cloud platforms that adhere to high standards of security, privacy and accessibility that unlock business insights and opportunities for data-driven business decisions.Please note, we are looking for candidates who are looking for growth at this level (Lead), therefore the advertised salary band is the lower end of our full banding for this level of position, allowing for progression in the role.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 strategyBuild and maintain appropriate Enterprise Architecture artefacts including Entity Relationship Models, Data Dictionary, ETL/ELT definitions and Data Pipeline/Lineage ModelsBe accountable to the client for the rationale of the architecture and detailed solution and be able to evidence that a thorough change approval process has been followedDefine the methods and standards of governance to ensure ongoing integrity of the architecture design artefactsDefine standards for data modelling to ensure consistency within the solution and across the enterprise. Be a vocal and assertive advocate of data warehousing modelling techniques such as KimballBe versatile in working within a delivery team to:Analyse candidate data sources for content, timeliness and integrityEvaluate APIs by analysing documentation and sample responsesReverse-engineer data models from a live systemCreate Agile stories for the implementation of the solution and support the engineering team throughout developmentSupport third party suppliers in developing specifications that ensure compatibility between client and supplier systemsSupport integration and reconciliation testingVisualise insights using industry standard reporting toolsAbout The Candidate Proven experience in defining data architectures to satisfy multiple stakeholders with varying data proficiencyThorough understanding of data lake and data warehousing principles and full project involvement in one or more major technology platforms, e.g. Snowflake, Databricks, etc.Proven experience with one or more Cloud Services provider, e.g. AWS, Azure or Google Cloud PlatformGood understanding of role-based access control, its importance in data privacy and methods of implementationExcellent data modelling skills in designing data warehouses and datamartsExperience of migrating data from legacy on-prem systems to cloud architecturesKnowledge of OLTP and OLAP principles and evidence of building such solutionsEvidence of building and managing the evolution of entity relationship models, data dictionaries and ELT/ETL modelsAbility to visualise outputs using leading reporting tools such as Power BI (with custom DAX) and/or TableauHigh proficiency in SQL. Knowledge of SQL Server, SSMS, SSIS and SSRS a bonusAbility to evaluate APIs using tools such as PostmanConsultancy experience is highly desirableExperience designing and implementing data pipelines is highly desirableAbout 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 (Hippo 6% with employee contributions of 2%)25 days holiday plus UK public holidaysPerkbox access for a wide range of discountsCritical illness coverLife assurance and death in service coverVolunteer daysCycle-to-work scheme for the avid cyclistsSalary sacrifice electric vehicles schemeSeason ticket loansFinancial and general wellbeing sessionsFlexible benefits scheme with options of:private health coverprivate dental coveradditional company pension contributionsadditional holidays (up to an extra 2 days)wellbeing contributioncharity contributionstree plantingDiversity, Inclusion and Belonging Hippo is dedicated to creating a diverse, equitable and inclusive workplace that works for everyone. We encourage applications from underrepresented groups and are committed to providing an inclusive and accessible recruitment process. We are a Disability Confident Employer, Mindful Employer, Endometriosis Friendly Employer and a member of the Armed Forces Covenant. We strive to remove barriers and offer reasonable adjustments.Hi, we\’re Hippo. We design with empathy and build for impact. We are a digital services partner invested in helping our clients thrive as modern organisations. Our delivery methodology is agile, from concept to reality, supporting innovation and continuous improvement to achieve outcomes. We believe technology should serve humanity and take a human-centred approach to our work.Hippo locations: We are headquartered in Leeds with offices across the UK in Glasgow, Manchester, Birmingham, London and Bristol. You need to be located within reasonable travelling distance from one of our offices. Client work may require on-site presence and travel. Relocation support up to £8k is available.Seniority level: Mid-Senior levelEmployment type: Full-timeJob function: Consulting and Information TechnologyIndustries: Professional Services

#J-18808-Ljbffr