Microsoft Dynamics CRM Data Analyst

Description

Summary of the work The Security Industry Authority has recently deployed a modified Microsoft Dynamics 2013 CRM system.The system is primarily used to process applications for licences required by individuals under the Private Security Industry Act of 2001. The SIA has aspirations to further develop this system to support its enforcement operations. Specialist role Performance analyst Expected Contract Length 6 months Latest start date As soon as possible Maximum Day Rate Max £600 exclusive of VAT Who Speclialist Work With Individual will work with colleagues in operations, ICT and change implementation and will require to: •Establish and refine management information to inform operational decisions and ensure comprehensive understanding of the workflows •Analyse issues encountered with the system to enable us to establish the root cause of problems and take appropriate action to resolve those problems (incident management, defect or change request) •Collaborate with colleagues in drafting change requests and incident reports for resolution by the supplier •Work with business analysts to identify where process changes may be required •Support colleagues in developing expertise in creating and running enquiries and reports What Specialists Work On •Data analysis skills, manipulating data extracted from the system to provide insight and trends analysis (Excel, SQL etc) •Significant experience working with the Microsoft Dynamics CRM application •A capability to clearly articulate findings to business users through the provision of analysis output •Experience of SSRS (SQL Server Reporting Services), drafting reports and structuring query •Experience of data models, drafting and articulating data architecture in a system •Experience of working on CRM implementation projects, especially through go-live and transition. •Experience of working with external suppliers and in a live operational environment. Skills & Experience • Data analysis skills, manipulating data extracted from the system to provide insight and trends analysis (Excel, SQL etc) • Significant experience working with the Microsoft Dynamics CRM application • A capability to clearly articulate findings to business users through the provision of analysis output • Experience of SSRS (SQL Server Reporting Services), drafting reports and structuring query • Experience of data models, drafting and articulating data architecture in a system • Experience of working on CRM implementation projects, especially through go-live and transition • Experience of working with external suppliers and in a live operational environment • Establish and refine management information to inform operational decisions and ensure comprehensive understanding of the workflows • Analyse issues encountered with the system to enable us to establish the root cause of problems • Collaborate with colleagues in drafting change requests and incident reports for resolution by the supplier • Work with business analysts to identify where process changes may be required • Support colleagues in developing expertise and confidence in creating and running enquiries and reports Nice to Haves Public sector delivery experience Work Location Head Office: Security Industry Authority 90 High Holborn London WC1V 6WY Working Arrangments This is a full time post. Security Clearance The postholder will be subject to standard security clearance procedures No. of Specialists to Evaluate 5 Cultural Fit Criteria • Ability and willingness to share knowledge and experience • Work as a team with our organisation and other suppliers • Be transparent and collaborative when making decisions • Have a no-blame culture and encourage people to learn from their mistakes • Take responsibility for their work • Challenge the status quo • Be comfortable standing up for their discipline • Can work with clients with less technical expertise Evaluation Weighting Technical competence 75% Cultural fit 5% Price 20% Questions from Suppliers 1. Once the opportunity is closed on the Digital Marketplace, do SIA require skills and experience, CV, work history or a combination of those? Once the opportunity is closed on the Digital Marketplace, the SIA do require candidates detailed CV including skills, experience, and work history. 2. Would SIA consider applications from candidates with a higher day rate? The SIA would not consider applications from candidates with a higher day rate (the maximum day rate is £600).