Reporting and Analytics Engineer

ARAG Group; West of England; Hybrid; GBP 45,000 - 75,000; Full time

Benefits offered by this job

26 days holiday + bank holidays + MyD­

Contributory pension scheme (up to 10%

Annual leave buy/sell up to 5 days

Employee Reward and Incentive Scheme

Career progression opportunities

Sports & Social club discounts

Group Income Protection

Group Legal Protection

Health Cash plan

Cycle scheme

Employee discounts hub

Job summary

ARAG UK in Bristol is seeking a Reporting and Analytics Engineer to design, build and maintain end-user visualisations, reports and ad-hoc analyses.

You will work with the Data Engineering team and business areas to deliver insights, promote transparency, and follow best practices for documentation and release processes.

Qualifications

• Strong SQL, SSRS and Power BI skills for paginated reports, visuals and dashboards.
• Experience with TSQL, data warehouses and tabular data sets.
• Familiarity with development lifecycles using source control, ideally Azure DevOps.

Responsibilities

• Design and build paginated reports and dashboards with SSRS and Power BI.
• Build and enhance datasets for report consumption using TSQL.
• Collaborate with data warehouse teams to improve coverage and KPIs.
• Gather detailed requirements and ensure BI processes run smoothly.
• Resolve BI tool and data queries; escalate issues as needed.

Skills

SQL

SSRS

Power BI

TSQL

Data Warehouses

Tabular data sets

Azure DevOps

Source control

Development lifecycle

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, 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:

• 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

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 Scheme
• Progressive 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.