Reporting & Analytics Engineer

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 Dev Ops, 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 increased efficiency, enhanced decision-making, and optimized operations.
• Resolve queries and issues related to BI tools, services and data.
• Act as 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 courses.

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

Generous remuneration and a benefits package including:

• 26 days holiday with the option to buy up to a further 5 days
• Company pension scheme with the option to increase contributions
• Group Income Protection for all employees
• Group Legal Protection for all employees
• A choice of either European Motor Assistance or Home Emergency Assistance
• Salary sacrifice benefits including Cycle scheme
• A comprehensive wellbeing programme including an employee Health Cash Plan
• 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
• 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.