Data Engineer

Overview

ARAG UK Group have an exciting opportunity to join our high-performing Digital Services team as a Data Engineer in our Bristol office.As Data Engineer you will be responsible for supporting the Data Engineering Manager with the design and implementation of the enterprise data lakehouse, data movement and data model design and implementation to support the needs of the business. You will ensure it is trusted, secure, scalable, performant and fit for purpose, as well as:Leveraging contemporary technologies and data paradigms as appropriateSupporting a single analytical view of our data and informationImplementing to agreed and defined metricsDelivering business value by supporting action-oriented insightsEnsuring it is built in line with our information management strategy and guiding principlesEnsures “explainability” fit for audit in a regulatory controlled environment through appropriate data lineage and documentationIn our collaborative environment and as part of the data engineering team you will work closely with many areas within the business. Working particularly with Finance, our Reporting and Analytic team and Data Platform teams and taking responsibility and accountability for the collaborative design and build of data solutions. These will provide a secure, dependable, and well performing platform for information and analytical purposes.You will be able to confidently address a wide range of different business areas with varied technical understanding whilst adapting your delivery to effectively convey difficult technical problems and solutions to non-technical colleagues.You will have experience implementing cloud centric data solutions using platforms such as Azure and have the ability and desire to pick up new technology, tools, paradigms and develop it further. You are comfortable building out and administrating data models, ensuring that they are accessible and used appropriately whilst leveraging platforms such as Databricks, dbt and Power BI.You will possess the knowledge of automating deployments using a combination of tools such as PowerShell and Azure DevOps and the ability to use Python both to manipulate data and building additional process to support data processing activities is fundamental. You will exhibit a passion for data and information with a strong understanding of data architecture principles and information "story telling" to maximise the value of our raw data. As well as a familiarity with data processing paradigms such as ETL/ ELT, Kimball, Medallion Data Lakehouse.The successful candidates will have:Experience with multiple ETL/ELT tools, including cloud specific technologies (e.g. Azure DataFactory, dbt, Databricks, SSIS, AWS Glue) desirable.Excellent knowledge of Microsoft SQL Server 2012 onward, including SSIS package design.Strong problem solving and planning skills with a "can do" attitude to manage and mitigate risks to maintain delivery commitments.Knowledge of the insurance industry and working within regulated environments would be desirable.Experience of working within an Agile environment essential, and ability to lead daily stand-up''s advantageousExperience of utilising an ESB (Enterprise Service Bus) desirable (e.g. Mulesoft ESB)Good communication and relationship building skills.Good all round and hands on BI knowledge and skillsAs a team we are passionate and enthusiastic about what we do. Our people are encouraged to think independently and to take ownership of their work. You will be agile in the way that you work and adaptable to change. In return for your commitment, we will offer you generous remuneration and an attractive benefits package which will include:26 days holiday with the option to buy up to a further 5 days.Company pension scheme with the option to increase contributions.Progressive career pathway and development opportunitiesEmployee reward and incentive schemeGroup Income Protection for all employees.Group Legal Protection for all employees.A choice of either European Motor Assistance or Home Emergency AssistanceInclusion in our Health Cash planSalary sacrifice benefits including Cycle scheme.A comprehensive wellbeing programme including a range of free weekly exercise classes (dependent on your office location) and free eye tests.Access to our employee discounts hub offering exclusive discounts across thousands of retail partners, including discounted gym memberships at over 3,000 gyms across the UK.The option to join our Sports and Social club which organises discounted events such as theatre visits and shopping trips.If you think you would be a good match for this role and can demonstrate some transferable experience please apply, regardless of whether you meet all the criteria listed ..... full job details .....