Mi Analyst

MI AnalystSalary: Up to £35k dependent on experienceDivision: Effective Energy SolutionsFull-Time, PermanentLocation: Worksop office based S80 Company ProfileEffective Energy Solutions is part of the Effective Energy Group. The Effective Energy Group is a group of companies providing predominantly energy and construction related services targeted at both domestic and commercial clients, since 2008. Brands in the Group to date include Effective Energy Solutions, Effective Home, Max Energy, Max Scaffold and Aztec Solar.At Effective Energy we are experts in delivering government initiatives on behalf of our high-profile clients. We have sustainability at heart and are passionate about making sustainable living accessible to all. We achieve this by delivering schemes that assist those on low income to access funding that will benefit them by reducing their energy bills. It is key now, more than ever, that those who feel the effects of high energy bills are assisted and we achieve this through several government initiatives. As a leading provider in this sector, we are designing our own programmes to expand our portfolio of services which will provide additional support to our customers.Overview:The MI analyst, reporting to the Operations Director will operate as one of the core pillars to the businesses IT/Data function. Our primary objective is to leverage value adding insight from the wealth of data available.The MI analyst will take a proactive role in ensuring that all business functions are provided with decision enabling information through periodic reporting and ad hoc exercises. The MI analyst will also adhere to strict requirements provided by the end user and will have to deal with competing projects and subsequent deadlines.Due to the varied nature of the business and the wide scale of projects where support will be required, the successful candidate will need to show flexibility, adaptability, and the aptitude to identify key business drivers from raw data.The role is an opportunity for the successful candidate to drive the businesses analytical reports and work closely with both Managing and Operations Director to create an end-to-end reporting suite that enables critical day to day decisions to be made, to enhance future forecast planning and to produce bespoke visual reports for review with our clients.ResponsibilitiesDevelopment of financial models to assist management in decision making and reporting.Responsible for the ongoing business performance forecasting cycle.Investigation of modelling and forecast assumptions to improve output accuracy.Development and maintenance of the company’s reporting capability, including the building of data architecture.Preparation of financial and non-financial analyses.Analyse and report on key performance indicators.Assist with the development and improvement of business systems.Production of reports from business systems using Power BI to deliver meaningful insights into business performance.Identify gaps in our data collection processes and deliver requirements for change to.Become a champion/master user on the various tools and software we use to collect and store our data, including and not limited to:SQLExcelPower BIMicrosoft DynamicsAssist colleagues in using the reports and tools that have been developed as part of the roll out process.Other Ad Hoc responsibilities will be given as the role evolves.Skills and AttributesEssentialHigh level of commercial acumenAbility to handle multiple projects and deadlinesExcellent analytical skills with supplementing experienceGood communication skills with experience in maintaining good working relationships with stakeholders from a variety of functions and backgroundsProven ability to deliverAbility to work in a team and work towards a group objectiveDesire to learn and pioneer new ways of workingETL Processes Understanding: Basic knowledge of how to extract, transform, and load data from various sources.Bachelor's degree (or Equivalent) in a related field: Data science, business analytics, economics mathematics or similar fields.EssentialExperience using Power BI, DAX, and Power QueryGood knowledge of MO suite especially MS ExcelFundamental understanding of database language (TSQL)DesirableProgramming skills – basic experience in Python or R for more advanced data manipulation and statistical analysis.Experience with Big Data tools, such as Hadoop, Spark or BigQuery.Experience with Data warehousing.Data governance and compliance: awareness of data governance and legal compliance (e.G. GDPR within the UK) Interested in this MI Analyst role? Apply now with your updated CV.