Data Engineer in Bristol

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 appropriate
• Supporting a single analytical view of our data and information
• Implementing to agreed and defined metrics
• Delivering business value by supporting action-oriented insights
• Ensuring it is built in line with our information management strategy and guiding principles
• Ensures “explainability” fit for audit in a regulatory controlled environment through appropriate data lineage and documentation

In our collaborative environment and as part of the data engineering team you will work closely with many areas within the business, particularly with Finance, our Reporting & Analytics teams and Data Platform teams, 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 & 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-ups advantageous
• Experience 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 skills

As 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 opportunities
• Employee reward and incentive scheme
• Group Income Protection for all employees
• Group Legal Protection for all employees
• A choice of either European Motor Assistance or Home Emergency Assistance
• Inclusion in our Health Cash plan
• Salary 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 above.