Overview
About The Role We are currently looking for a dedicated individual to work within the central Business Intelligence Team. A passion for providing an exceptional level of support is essential and you must have a proactive approach to work, remaining professional and confidential always. We are currently consolidating and upgrading our reporting infrastructure. We're building a data warehouse to centralise and standardise data across the organisation, moving away from our legacy reporting tool. This project includes 64 reporting areas and over 500 unique reports, many with multiple versions, that need to be streamlined into concise, filterable Power BI reports. As a Business Intelligence Analyst, you'll be responsible for consolidating these reports in Power BI, leveraging both your DAX skills and knowledge of MySQL and Databricks SQL to build insightful, high-performance reports. Since our new data warehouse will reside in Databricks, experience with Databricks SQL is crucial for defining, querying, and optimising datasets to ensure smooth integration with Power BI. You'll also need to apply Row-Level Security (RLS) in Power BI to control data access and implement scheduling to ensure reports are updated in real-time.
Responsibilities
* Work with the BI Manager and the BI Team to gather requirements and develop Power BI reporting to replace 300+ Excel Reports
* Work with the BI Manager to test and refine Datasets to be used in our Power BI Reports within the current Datawarehouse project
* Work with the Sr BI Analyst to review and maintain the structure of our existing Suite of BI Reports — Workspaces, Apps, Permissions, Formats, etc.
* Assist the BI Manager with DWH requirements and testing of delivered data for YOY reporting which will be delivered by the whole team.
Qualifications
* Strong IT skills; advanced Excel (VBA desirable) and Power BI experience a plus.
* Experience with SQL (MySQL/Databricks) is advantageous
* Ability to analyse trends, produce accurate reports, and maintain data integrity.
* Professional, consistent, and meticulous in all work.
* Confident communicator who can present findings clearly to all audiences.
* Self-reliant, inquisitive, and results-driven, with a collaborative mindset.
* Experience in the Kitchen/Furniture Retail sector is desirable.
Benefits
* Life Assurance after 2 years' service
* Access to Benenden health and discount platform after 1 year of continuous service
* Personalised progression plan with clear career opportunities
* Individual training budget for personal development
* EE discount
* Staff discount on purchasing a kitchen/bedroom after 1 year of continuous service
* Eye Care Vouchers
* Refer a Friend Scheme
* Free onsite gym
#J-18808-Ljbffr