BI Manager - Warwick based (2 days per week in office)
Role also includes some travel to different sites
£60K - £65K plus 10% bonus
The BI Manager will be responsible for managing the generation, analysis and presentation of data as required by the business to support decision making and performance management. The post holder will ensure all new and previously deployed reporting systems are supported, developed and maintained.
This role is managing the entirety of the BI function with no direct reports. Opportunity to grow the function out and bring in more people in the future is a possibility.
In this role you will:
* Engage and support the senior management team to develop solutions for monitoring performance and enhancing the understanding of operational activities.
* Manage SQL data warehouse, including the ETL processes for external data sources (e.g. SAP, Lumeon RIS and SharePoint).
* Assist the Finance team in maintaining and improving their existing Interactive P&L and Balanced Scorecard dashboards
* Represent the Business Intelligence function in all relevant internal and external meetings, including providing guidance for the ongoing development of the RIS systems and managing relationships with Operational Leadership.
Technical Skills:
* Previous experience of working in a senior data position analysing and reporting business results and KPIs, working closely with operational and commercial teams.
* Detailed knowledge and experience of Microsoft BI Stack, including SSIS, SSRS and Power BI
* Able to understand and write complex SQL queries, stored procedures, functions and views.
* Microsoft Reporting Services experience, writing complex reports, report scheduling, internal distribution, and use of data-driven subscriptions.
* Microsoft Power BI experience, creating complex dashboards, Power Query data wrangling, DAX, data refresh scheduling.
* Understanding of PowerShell scripting in relation to files, folders and SSRS portal.
* Understanding of ETL processes including knowledge of data warehousing
* Understanding of local and cloud Power BI hosting
* Advance user of Microsoft Excel with Visual Basic, comfortable working with large volumes of data