This leading UK Real Estate company require a Power BI Specialist to work with the Head of FP&A and broader finance function to provide advanced analytics / dashboarding capabilities for forecasting, business planning and investment purposes.
Client Details
Leading UK Real Estate company
Description
This leading UK Real Estate company require a Power BI Specialist to work with the Head of FP&A and broader finance function to provide advanced analytics / dashboarding capabilities for forecasting, business planning and investment purposes.
Key Responsibilities:
Develop, manage and maintain the current Power BI platform used in Finance
Collaborate with other functional teams to enhance and develop the use of Power BI reporting
Provide standard reports as timetabled and other analysis and reports as and when required that deliver proactive insights and recommendations
Product focused covering Revenue to Gross Margin delivering insight to key stakeholders on profitability, and Industry performance.
Defining clear criteria to assess performance of assets using leading and lagging indicators, and, working cross functionally, support the improvement in performance of these assets.
Through variance and trend analysis, identify forecast gaps and improve accuracy of forecast ongoing, including a continuous feedback loop with Commercial teams. Activate different tactical responses based on forecast gap and lead time.
Support the annual business planning process through critical review and evaluation of long term asset level forecasts
Develop Power BI dashboards using financial metrics and KPIs to give a clear view of business performance
Develop database tools and processes to improve the delivery of sales and market Business Intelligence to key stakeholders using internal data from ERP, CRM, Project Tracking, Finance etc as well as external sources
Leverage strong data integration and ETL skills using SQL / SSIS (or similar) to ensure quality of data in Power BI
Work with IT to extend the scope and functionality of the Data Platform, PowerBI dataset and the Group PowerBI dashboardRequired Skills and Experience:
Experience developing databases and tools to manage and interpret large volumes of complex data using Power BI, DAX, Power Query, Excel, PowerPoint
Strong knowledge of ETL process, database management and data integration via SSIS
Strong analytical skills and the ability to present conclusions and insights in a clear and concise manner
Great presentation / data visualisation skills to transform data into digestible information.
Proven experience of creating Dashboards in Power BI
Relevant Finance background and working as part of a large Group Finance or FP&A team
Relevant degree or equivalent qualification
A technical aptitude with natural curiosityProfile
Experience developing databases and tools to manage and interpret large volumes of complex data using Power BI, DAX, Power Query, Excel, PowerPoint
Strong knowledge of ETL process, database management and data integration via SSIS
Strong analytical skills and the ability to present conclusions and insights in a clear and concise manner
Great presentation / data visualisation skills to transform data into digestible information.
Proven experience of creating Dashboards in Power BI
Relevant Finance background and working as part of a large Group Finance or FP&A team
Relevant degree or equivalent qualification
A technical aptitude with natural curiosityJob Offer
Opportunity to deliver enhanced analytics services
Opportunity to influence and enhance insight & analytics strategy