Data Engineer

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. Working particularly with Finance, our Reporting & Analytics 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 & analytical purposes.

About You

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 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.

About The Company

ARAG UK has been helping businesses and individuals gain access to justice for over 40 years. It’s our founding principle to enable everybody, not just those who can afford it, to assert their legal rights. Thousands of businesses and individuals defend or pursue legal action each year safe in the knowledge that ARAG are paying their legal bills. Our businesses include a legal expenses insurance company and a law firm with many opportunities in both areas. We have always been aware that it’s the people that really make it happen; the quality of our people defines the quality of the company, the service we offer and the good outcomes for our customers, so we’re committed to creating a great place to work for our employees. We believe it is an exciting time to join ARAG. You can expect an organisation that will challenge and develop you to progress your career. By giving you every opportunity to develop yourself professionally and personally, we also pride ourselves on having an open, inclusive and high energy culture that encourages a fun working environment and places our customers at the very heart of everything we do. If you are keen to become part of our exciting future then we would love to hear from you. In addition to the very genuine development opportunities we provide we also offer a generous reward and benefits package.