Leeds City Council

Microsoft BI Consultancy

Incomplete applications

14
Incomplete applications
12 SME, 2 large

Completed applications

16
Completed applications
15 SME, 1 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Friday 13 December 2019
Deadline for asking questions Tuesday 17 December 2019 at 11:59pm GMT
Closing date for applications Friday 20 December 2019 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Specialist role Technical Architect
Summary of the work We are looking for an experienced MS accredited BI technical architect to undertake a review of the data architecture and development lifecycle within our Adult Social Care service with a view to simplifying and improving delivery time, with an option to support the council implementing the recommendations.
Latest start date Friday 31 January 2020
Expected contract length 3-4 weeks (Discovery Phase)
Location Yorkshire and the Humber
Organisation the work is for Leeds City Council
Maximum day rate

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement
Who the specialist will 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 the specialist will 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.

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place Two locations in Leeds City Centre. Merrion House and St Georges House
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.
Security clearance Compliance with council's computer use policy. DBS may be required if access to adult social care databases is required

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
Additional terms and conditions

Skills and experience

Buyers will use the essential and nice-to-have skills and experience to help them evaluate suppliers’ technical competence.

Skills and experience
Opportunity attribute name Opportunity attribute value
Essential skills and 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-have skills and experience
  • 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

How suppliers will be evaluated

All suppliers will be asked to provide a work history.

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many 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
Additional assessment methods
  • Reference
  • Interview
  • Presentation
Evaluation weighting

Technical competence

50%

Cultural fit

20%

Price

30%

Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. Is there a current incumbent? There is not an incumbent supplier.
2. Please can you confirm the IR35 status of this role? This role is outside IR35.
3. After the discovery phase, is this engagement likely to be extended? If there is a gap between phases, how long is this likely to be? Following the discovery phase there will be a gap to allow the council to evaluate recommendations. It is anticipated this may be up to 2 weeks.
4. Will this position extend beyond the 3-4 week discovery phase. There is the option to extend beyond discovery with the successful bidder.