Her Majesty’s Passport Office

Power BI Developer Lead

Incomplete applications

5
Incomplete applications
5 SME, 0 large

Completed applications

8
Completed applications
7 SME, 1 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Tuesday 3 April 2018
Deadline for asking questions Thursday 5 April 2018 at 11:59pm GMT
Closing date for applications Tuesday 10 April 2018 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Specialist role Developer
Summary of the work Power BI Developer for HMPO's BI transformation project, working within an agile delivery team to iteratively build and implement a BI service in collaboration with the project.
Latest start date Monday 7 May 2018
Expected contract length Upto 24months.SoW 12months with optional further period of upto 12months depending on business need
Location London
Organisation the work is for Her Majesty’s Passport Office
Maximum day rate Market Rate

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement Home Office have already evaluated various BI tools and chosen Microsoft Power BI as a strategic BI Visualisation Tool.
Who the specialist will work with The team allocated to this work formed of 1 Project Manager, 1 Project Support, 1 Product Manager, 1 BA, 1 BI Technical Lead, 1 Lead Architect, 1 Dev-ops Engineer, 2 Business Change Managers
What the specialist will work on Understanding user needs and designing services to support them.

Developing interactive reports and dashboards for visual insights using PowerBI in AWS environment.

Implementing data discovery internally, and externally using PowerQuery.

Implementing SQL databases and data warehouse services as per the BI design and requirements in the environment hosted in AWS.

Implementing data feeds to private cloud data stores using Data connectors, collaborating with suppliers, third parties and other HO projects

Writing SQL queries

Documenting the low level technical details as per the project's technical governance.

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
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 5 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. HM Passport Office will support the clearance process.

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
Additional terms and conditions Breakpoints to assess progress and quality will be set at regular intervals of the Project.

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 demonstrable experience of understanding User needs and designing services to support them, successfully implemented BI POC solutions, data visualisation
  • Have demonstrable experience of using AWS environment, Power BI to develop interactive reports and dashboards, PowerQuery, SQL databases and data warehouse services, writing SQL queries, column store indexes.
  • Demonstrable experience in designing and implementing Multi-dimensional and Tabular models using Microsoft SSAS, Creating scheduled Ingestion Pipes using Microsoft SSIS, Data connectors to private cloud data stores, Enterprise data modelling.
  • 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.
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 successful design and implementation for cloud based BI / data analytics solutions utilising Microsoft PowerBI.
  • Have demonstrable experience of Data Analysis, Data Cleansing, Database Administration and Analytics.
  • Have demonstrable experience in implementing new BI related technologies.
  • Know of Microsoft Azure Data Warehouse would be advantageous to compare solutions built in AWS and Azure.

How suppliers will be evaluated

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many specialists to evaluate 3
Cultural fit criteria
  • Be transparent and collaborative when making decisions.
  • Take responsibility for their work.
  • Able to 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

Questions asked by suppliers
Supplier question Buyer answer
1. To confirm there will be no Question and Answer session. Please send in your questions and we will endeavor to answer your questions soon.
2. Will this engagement be deemed out of scope for IR35? We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.
3. Can you confirm this will be outside IR35? We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.
4. Can you confirm if this role falls inside or outside of the off-payroll working regulations (IR35)? We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.
5. What is the IR35 status for this task? We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.