Job Description

We are seeking a skilled and detail-oriented Reporting Analyst to join our team in Pangbourne, United Kingdom. As a Reporting Analyst, you will play a crucial role in transforming complex data into actionable insights that drive business decisions. This position offers an exciting opportunity to work with cutting-edge technologies and collaborate with cross-functional teams to deliver high-quality reports and analytics solutions.

• Managing ad-hoc data extraction and transformation requests to support business needs for data visibility. 

• Support a new initiative for business self-serve analytics with the provision of common comprehensive and re-usable datasets. 

• Provision of visuals in Power BI to meet business reporting requirements. 

• Strong working knowledge of technologies including SQL, Azure and Databricks to compile underlying data models to support reporting. 

• Support the ingestion process and scheduling of source raw data tables into the XP data warehouse. 

• Liaison with the business and SAP Data Architect to understand data requirements for extraction in preparation for reporting. 

• Support the business with any general reporting issues, queries and management of enhancement requests. 

• Maintenance and creation of key documentation to support BI and the XP reporting catalogue. 

Qualifications

• Bachelor's degree in Business, Computer Science, Statistics, or a related field
• Proven experience working with Power BI and strong SQL skills for data querying and transformation
• Proficiency in developing data cubes to support self-serve reporting, including requirements gathering, design, build, deployment, and training
• Experience working with SAP systems, specifically in reporting and data analysis
• Exposure to Microsoft Azure Data Factory and Databricks
• Strong analytical mindset with the ability to interpret complex data sets and generate meaningful insights
• Excellent documentation skills, including the ability to translate business requirements into technical specifications and create clear user guides
• Detail-oriented with a strong focus on data accuracy and quality
• Outstanding communication skills, with the ability to present complex problems in a simple manner to non-technical audiences
• Experience with data visualization tools and knowledge of data warehousing concepts
• Ability to engage with stakeholders at all levels and work collaboratively in a team environment
• Self-motivated with excellent organizational skills and the ability to work independently
• Proven track record of delivering efficient and innovative reporting solutions

Additional Information

Location

• Based in the UK
• Hybrid 2 days in the Pangbourne Office and 3 days from home