Reporting and Analytics Engineer

ARAG plc; Bristol; On-site; GBP 40,000 - 60,000; Full time

Benefits offered by this job

26 days holiday

Pension scheme (up to 10% employer)

Annual leave purchasing option

Employee discount hub

Health Cash plan

Job summary

ARAG UK, a market-leading insurance and legal services provider, is seeking a Reporting and Analytics Engineer to join the Information Management Team in Bristol. You will design and build end-user visualisations, reports, and ad-hoc analysis, collaborating with Data Engineering and business areas to ensure transparent communication and robust BI solutions.

The role focuses on SQL, SSRS and Power BI skills, building datasets for reporting, and contributing to data warehouse initiatives.

Qualifications

• Strong SQL, SSRS, and Power BI skills for creating and managing paginated reports, visualisations and dashboards.
• Experience with T-SQL, data warehouses and tabular data sets.

Responsibilities

• In collaboration with stakeholders design and build paginated reports and dashboards using SSRS and Power BI.
• Build and enhance datasets for report consumption using TSQL.
• Collaborate with the data warehouse team to improve warehouse coverage and create KPIs.
• Gather requirements and foster collaborative idea generation; ensure BI solutions improve efficiency and decision-making.
• Resolve queries and issues related to BI tools, services and data.

Skills

SQL

SSRS

Power BI

T-SQL

Data warehousing

Tabular data

Azure DevOps

Tools

Azure DevOps

Job description

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

• In collaboration with stakeholders across the business, design and build a variety of content including paginated reports and dashboards using SSRS and Power BI.
• Building and enhancing datasets for report consumption using TSQL.
• 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.
• Resolve queries and issues related to BI tools, services and data.
• An active stakeholder ensuring all BI processes including data refreshes and report generation run smoothly.
• 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.

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:

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

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.

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

• 26 days holiday + bank holidays+ 'MyDay' (1 day to take at your discretion during the year)
• Contributory company pension scheme (up to 10% employer match)
• Opportunity to buy up to 5 days of annual leave every year
• Employee Reward and Incentive SchemeProgressive career pathway and development opportunities
• The option to join our Sports and Social club which organises discounted events such as theatre visits, sporting events and shopping trips
• Group Income Protection for all employees
• Group Legal Protection for all employees
• European Motor Assistance and Home Emergency Assistance
• Inclusion in our Health Cash plan
• Salary sacrifice benefits including Cycle scheme
• 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
• 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.