Job Title: BI Analyst Salary: £35,000 - £55,000 DOE Location: Cambridge - 2 days a week onsite This role as a BI Analyst is within the Consultancy service provision of the company working as part of growing team developing strategic estate planning models, Bespoke BI solutions and Project management. The analyst will work on gathering, interpreting, analysing and reporting data, often as part of a larger team but also as an individual. The type of data analysed will vary according to the consultancy commission delivery requirements. Part of the analyst's role will be to establish the client deliverables clearly at the start of the project and to further ensure that they are successfully delivered. Key Tasks and Requirements The analyst will assist in the following activities: Produce any project initiation documentation, project proposals and appointment terms. Agree and action any technical and quality strategies for gathering the required data or information flows. Help clients make evidence-based decisions to reduce their costs and drive productivity. Be responsible for project administration. Develop and maintain complex data models in SQL Server and Power BI. Translate raw inputs into meaningful management information. Able to provide clear and succinct briefs to clients and other stakeholders on project requirements/findings. Identify best practice approaches for data modelling to ensure continual improvement. Clearly document key assumptions and processes to enable client and other stakeholders to replicate and understand your data models. Able to direct and motivate others in the project team, as well as the Data Analyst teams. Manage project risks and issues including the development of contingency/mitigation plans. The successful candidate will demonstrate the following capabilities: Able to demonstrate a strong understanding of Microsoft Excel for data transformation, modelling and data analysis. Able to manipulate and restructure data using SQL. Experience in SQL Server or equivalent database platforms. Proficient in Power BI DAX Code and using Power BI to demonstrate complex issues to layman users. Maintains a strong attention to detail and is able to analyse information critically. Maintain self-discipline and focus on the task at hand with minimal supervision. Ability to scrutinise your own work before presenting it to senior management or clients. Able to learn and adapt quickly under strict time constraints. Able to interpret data and put findings into context. Proficient in other Microsoft Office programmes. Additional Tasks Continually update and extend technical and professional expertise. Contribute to training activities both internally and externally where appropriate. Business development, marketing and sales - promoting the firm positively to staff, clients and potential clients. In Technology Group Ltd is acting as an Employment Agency in relation to this vacancy.