Awarded to People Source Consulting Ltd

Start date: Monday 20 August 2018
Value: £259,680
Company size: SME
Her Majesty’s Passport Office

Business Intelligence Power BI Developer- B

1 Incomplete application

1 SME, 0 large

15 Completed applications

14 SME, 1 large

Important dates

Published
Monday 26 March 2018
Deadline for asking questions
Wednesday 28 March 2018 at 11:59pm GMT
Closing date for applications
Monday 2 April 2018 at 11:59pm GMT

Overview

Specialist role
Developer
Summary of the work
Power BI Developer for Her Majesty's Passport Office's BI transformation project, working within an agile delivery team to iteratively build and implement a BI service in collaboration with the project team to deliver in Beta.
Latest start date
Tuesday 1 May 2018
Expected contract length
12months with optional further period upto 12months dependent on business need. Total upto 24months
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. SQL Server 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 Business Analyst, 1 BI Technical Lead, 1 Power BI developer, 1 Lead Architect, 1 Dev-ops Engineer.
What the specialist will work on
1) Understanding user needs and designing services to support them.
2) Develop interactive reports and dashboards for visual insights using Power BI on premises AWS.
3) Implement Microsoft SQL databases and data warehouse services to as per the BI design and requirements
5) Implement data feeds to private cloud data stores using Data connectors.
6) Writing SQL queries
7) Document the low level technical details as per the project's technical governance.
8) Carry out and support knowledge transfer to non-technical business units

Work setup

Address where the work will take place
Westminster
Working arrangements
Work is based in London and will involve the supplier being on site 4 days per week to work collaboratively with Her Majesty’s Passport Office teams; travel and expenses remains the responsibility of the supplier.
Service design and development must align with the Her Majesty’s Passport Office strategic technical architecture and technologies.
Security clearance
SC Clearance is required. HM Passport Office will support the clearance process.

Additional information

Additional terms and conditions
Breakpoints to assess progress and quality will be set at the end of Beta 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 Power BI to develop interactive reports and dashboards for visual insights.
  • Have demonstrable experience of using Microsoft SQL Server databases and data warehouse services
  • Have demonstrable experience of using Data connectors to private cloud data stores
  • 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 delivering of public sector digital services;
  • Have demonstrable experience using Agile methods and practices
  • Have demonstrable experience of best practices in data visualization
  • Adept at writing Transact-SQL queries
  • Adept at writing DAX calculations
Nice-to-have skills and experience
  • User 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 Power BI
  • Have demonstrable experience of Data Analysis, Data Cleansing
  • Have demonstrable experience of Regulatory Reporting, Data Visualisation
  • Have demonstrable experience of SQL Server Analysis Services
  • Have demonstrable experience of SQL Server Integration Services
  • Have demonstrable experience of writing M queries

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 Her Majesty’s Passport Office design, delivery and governance framework
Assessment methods
  • Work history
  • Presentation
Evaluation weighting

Technical competence

60%

Cultural fit

15%

Price

25%

Questions asked by suppliers

1. Can you confirm that these roles are outside IR35
We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.
2. What is the ir35 status on this role?
We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.
3. Due to the bank holiday please would you consider extending the deadline.
We are unable to extend the deadline, the closing date stands as 2nd April.
4. Could you please confirm IR35 status & rate for this role.
We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.