Reporting & Analytics Engineer

About The Role

ARAG UK, a market-leading insurance and legal services provider, has an exciting new opportunity for a Reporting and Analytics Engineer to join us in our Information Management Team, based in our spacious, modern Bristol offices.

The ideal candidate will demonstrate a passion for data, visualisations, and story-telling through data; ideally coming from a relevant professional background to support this passion.

Working as part of the Reporting & Analytics team, you will work in close collaboration with the Data Engineering team and business areas taking responsibility and accountability for collaborative design and build of end-user visualisations, reports, and ad-hoc analysis. It is key that you will promote transparent communication by sharing updates, insights, and hurdles, as well as working collaboratively to tap into shared expertise. You'll also ensure all required documentation is complete prior to release and all standards and best practices are adhered to.

It is essential that you have strong SQL, SSRS, and Power BI skills for creating and managing paginated reports, visualizations and dashboards. Experience with TSQL, using data warehouses, and tabular data sets is also important. Familiarity with development lifecycle processes using source control, ideally within Azure DevOps, is highly valued.

Key responsibilities include:

1. In collaboration with stakeholders across the business, design and build a variety of content including paginated reports and dashboards using SSRS and Power BI.
2. Building and enhancing datasets for report consumption using TSQL.
3. Work with the data warehouse team to improve warehouse coverage and create key performance indicators (KPIs). Gather detailed requirements and foster collaborative idea generation. Ensure BI solutions follow the principles of increase efficiency, enhance decision-making, and optimize operations.
4. Resolve queries and issues related to BI tools, services and data.
5. An active stakeholder ensuring all BI processes including data refreshes and report generation run smoothly.
6. Resolving failures or errors in scheduled jobs, investigating data discrepancies. Escalate, document and undergo deeper investigation required for the development of fixes.

We will offer support and development in order to progress your career within the Reporting & Analytics space, with in-situ training, as well as access to online training course.

About You

We are keen to hear from candidates with previous experience in a similar role. You will have a "can do" attitude, to help thrive in this rapidly evolving area, an enthusiasm to learn and a true passion for data and information. In addition, we'd like to hear from candidates who are:

1. Experienced across the Microsoft technology stack, ideally leveraging capabilities in Azure.
2. Adept at visualising information through good use of chart types best suited to the situation.
3. Have experience developing reports using a Data Warehouse and a solid understanding of Kimball methodologies and principles.
4. Experience of using DAX at an advanced level preferable.
5. Can build and enhance datasets for report consumption using TSQL.
6. Good problem solving and planning skills with a "can do" attitude.
7. Able to work well as a team with good collaboration skills.
8. A creative and lateral thinker.
9. Able to demonstrate good communication and relationship building skills.

In return for your commitment, we will offer you generous remuneration and a benefits package to include:

1. 25 days holiday with the option to buy up to a further 5 days
2. Company pension scheme with the option to increase contributions
3. Group Income Protection for all employees
4. Group Legal Protection for all employees
5. A choice of either European Motor Assistance or Home Emergency Assistance
6. Salary sacrifice benefits including Cycle scheme
7. A comprehensive wellbeing programme including an employee Health Cash Plan
8. 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
9. The option to join our Sports and Social club which organises discounted events such as theatre visits, wine tasting and shopping trips

At ARAG UK we encourage our people to achieve a work-life balance that works for them and are happy to discuss flexible working options.

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.