Awarded to LA International Computer Consultants Limited

Start date: Monday 2 October 2017
Value: £650
Company size: large
Her Majesty's Passport Office

Business Intelligence Technical Lead

16 Incomplete applications

10 SME, 6 large

9 Completed applications

8 SME, 1 large

Important dates

Published
Thursday 4 May 2017
Deadline for asking questions
Thursday 11 May 2017 at 11:59pm GMT
Closing date for applications
Thursday 18 May 2017 at 11:59pm GMT

Overview

Specialist role
Designer
Summary of the work
Power BI Technical Lead for HMPO's BI transformation project, directing agile delivery team to iteratively design, build and implement a BI service in collaboration with Lead Technical Architect to deliver Alpha. Alpha is limited in scope but will lay foundation of key architecture building blocks for the future BI platform.
Latest start date
Monday 29 May 2017
Expected contract length
3-6 months with the possibility of 2 years to delivery of an end to end BI service.
Location
London
Organisation the work is for
Her Majesty's Passport Office
Maximum day rate
Market Rate

About the work

Early market engagement
Home Office have already evaluated various BI tools and chosen Microsoft Power BI as a strategic BI Visualisation Tool. Greenplum is chosen as underlying BI data platform
Who the specialist will work with
There is a small team allocated to this work formed of 1 Product Manager, 1 BA and a Lead Architect.
What the specialist will work on
Develop interactive reports, dashboards for visual insights using PowerBI and Microsoft Azure.
Implement Azure SQL databases, data warehouse services to as per the BI design and requirements
Implement data feeds to private cloud data stores using Data connectors
Document the detailed technical design as per the project's technical governance.
Do the Data analysis, multi-dimensional data modelling and resource isolation between different tenants of that data platform
Design a BI solution that collect and manage personal and/or sensitive information with appropriate controls and protection.
Design, maintain, develop database design as well as conceptual, logical and physical data models for business intelligence.

Work setup

Address where the work will take place
Westminster, London
Working arrangements
We expect the specialist to work collaboratively with existing in house project teams that are transforming the way HMPO processes business intelligence.
Work is based in London and will involve the supplier being on site 4 days per week to work collaboratively with HMPO teams; travel and expenses remains the responsibility of the supplier.
Service design and development must align with the HM Passport Office strategic technical architecture and technologies.
Security clearance
SC clearance is required. HMPO will support the clearance process.

Additional information

Additional terms and conditions
Breakpoints to assess progress and quality will be set at the end of alpha phase.

Skills and experience

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

Essential skills and experience
  • Have demonstrable experience of successfully understanding user needs and designing services to support them.
  • Have demonstrable experience of using Miscrsoft Azure, and Power BI to develop interactive reports and dashboards for visual insights.
  • Have demonstrable experience of using PowerQuery for data discovery internal, and externally.
  • Have demonstrable experience of using Azure SQL databases and data warehouse services
  • Have demonstrable experience of using Data connectors to private cloud data stores
  • Have demonstrable experience of Data analysis and multi-dimensional data modelling, resource isolation between different tenants of that data platform
  • Have demonstrable experience of successfully delivering digital solutions that collect and manage personal and/or sensitive information with appropriate controls and protection.
  • Have demonstrable experience of successfully working with other suppliers/3rd parties/other partners in the delivery of public sector digital services;
  • Have demonstrable experience of successfully delivering BI platform from Alpha to Live phase outputs and iteratively developing and improving them using Agile methods and practices."
  • Design, maintain and develop database architecture as well as conceptual, logical and physical data models for business intelligence efforts.
  • Ensure that all relevant aspects of data model (granularity, etc.) are taken into account
  • Analyse the logical and physical database models and guarantee models are in accordance with standards.
  • Translate technical aspects of data modeling (facts, dimensions, "snowflaking", etc.) into language that non-technical users can understand.
  • Work with both technologists as well as non-technical users with ease and approachability.
Nice-to-have skills and experience
  • Have demonstrable experience of delivering digital solutions that meet Level AA of the W3C WCAG 2.0 accessibility standards
  • Have demonstrable experience of successfully and collaboratively working, coaching and sharing knowledge with Public Sector client teams, particularly those with limited agile development experience.
  • Have demonstrable experience of successfully design and implementation for cloud based BI / data analytics solutions utilising Microsoft PowerBI
  • Have demonstrable experience of Data Analysis, Data Cleansing, Database Administration, Analytics
  • Have demonstrable experience of Regulatory Reporting, Data Visualisation

How suppliers will be evaluated

How many specialists to evaluate
3
Cultural fit criteria
  • Be transparent and collaborative when making decisions
  • Take responsibility for their work
  • Can work with clients with low technical expertise
  • Able to work within HMPO design, delivery and governance framework
Assessment methods
  • Work history
  • Interview
  • Presentation
Evaluation weighting

Technical competence

60%

Cultural fit

15%

Price

25%

Questions asked by suppliers

1. Does the HM Passport Office evaluation process have a preference between suppliers providing one in-depth piece of evidence throughout, and suppliers providing several different experiences? In short, how does the DVLA read the following: "You should only provide one example for each essential or nice-to-have requirement (unless the buyer specifies otherwise). You can reuse examples across different essential or nice-to-have requirements if you need to."
You can reuse the same example to explain the essential and nice to have requirements.
2. How do you want us to send you the candidates' work history (i.e. CVs)?
Applications are made via DOS framework, if we require CVs then we will request after the closing date.
3. What is the maximum number of specialists a supplier can submit for these roles?
Supplier's can only submit one applicant per opportunity and only three candidates will be shortlisted for the interviews.
4. What is the status of the role in regards to IR35? - Inside or outside?
The role is expected to be outside of IR35, however status is assessed on a case-by-case basis.
5. How many candidates can be submitted for the job opportunity?
Supplier's can only submit one applicant per opportunity and only three candidates will be shortlisted for the interviews.
6. Could you please provide guidance on the "market rate" to determine the suitability of certain candidate expectations?
No maximum target rate is being set.
7. Is Security clearance required at the date of application? Or will you help obtain it?
Security clearance would be preferred, but is not is not a pre-requisite. Personnel will be sponsored through the clearance process by HM Passport Office.
8. Does this role fall within the IR35 legislation?
The role is expected to be outside of IR35, however status is assessed on a case-by-case basis.
9. We expect a role of this nature could command up to £1400 per day, is this within your acceptable parameters?
No maximum target rate is being set.
10. You have mentioned that you are looking for market rate on the job description page however there is a limit when it comes to the actual application. Is this correct?
No maximum target rate is being set.
11. Can I please ask if the successful candidate can start onsite with BPSS whilst the SC Clearance is going through?
Successful candidates can only start with CTC or SC clearance.