Microsoft BI Consultancy

Tender description

Who Speclialist Work With The specialist would work with the Business Intelligence manager, their team, the data warehousing team, DBAs, solutions architect and service development team within the Digital information service directorate What Specialists Work On Review of Business Intelligence processes (acquisition and modelling, analysis and visualisation) and approach within Adult Social Care Directorate. Discovery Phase: Review business requirements Review current development processes for delivering the requirement Review implementation of BI technologies against requirements Propose recommendations for improvements to design, process and technology use. Implementation Phase: (optional subject to council accepting the recommendations). Support high level / detailed solution design work Support production of a BI roadmap for client Support production of an action plan (short, mid, long term actions). Key outcomes are to reduce the duration of and simplify the production cycle of BI Assets. Where the Work Takes Place Two locations in Leeds City Centre. Merrion House and St Georges House Early Market Engagement Working Arrangements The role will involve on site face to face meetings and / or workshops with key stakeholders across our two locations during the discovery phase. It is expected that the individual will work Monday to Friday and be on site at least two days per week, specific days will be dependent on availability of council staff. Work that doesn't require onsite presence can be done remotely, such as research, analysis, writing up the recommendations etc. Should access to council systems be required, laptops and logins will be provided. Expenses will not be paid. Work Location Two locations in Leeds City Centre. Merrion House and St Georges House Security Clearance Compliance with council's computer use policy. DBS may be required if access to adult social care databases is required Additional T&Cs Skills & Experience Have Specialist Knowledge of Microsoft BI Technologies (SSDB, SSIS, SSAS, SSRS, Power BI) on premise deployment Proven track record of reviewing Requirements and making recommendations Experience of Data Warehouse design using SSAS cubes Proven track record of implementing BI platforms in complex organisations Ability to produce clear, concise and understandable report detailing the recommendations and steps required to implement them Have proven experience with agile data warehousing Nice to Haves Able to provide advice around future road map for BI and AI in the organisation Domain knowledge of Adult Social Care in local government Have experience of Kimball design principles No. of Specialists to Evaluate 3 Cultural Fit Criteria Be able to work as a team with our organisation and other suppliers Be transparent and collaborative when making decisions Take responsibility for their work and be proactive in engaging with council staff Share knowledge and experience with Council staff Challenge the status quo Can work with clients with low technical expertise Understand Constraints and Challenges of public sector Have good communication skills Assessment Method Reference Interview Presentation Evaluation Weighting Technical competence 50% Cultural fit 20% Price 30% Questions from Suppliers Budget range