Business Intelligence Technical Lead

Description

Summary of the work Business Intelligence 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. Specialist role Designer Expected Contract Length Upto 24months.SoW 12months with optional further period of upto 12months depending on business need. Latest start date Monday 21 May 2018 Maximum Day Rate Market Rate Early Market Engagement Home Office have already evaluated various BI tools and chosen Microsoft Power BI as a strategic BI Visualisation Tool. Who Speclialist Work With There is a team allocated to this work formed of 1 Product Manager, 1 BA, 1 Power BI developer, 1 Lead Architect, 1 Dev-ops Engineer, 2 Bus. Change Managers. What Specialists Work On Develop interactive reports, dashboards for visual insights using PowerBI SSAS, SSIS and SQL Server, PBIRS on-premises reporting server - including disaster recovery - hosted in AWS. Implement data feeds to private cloud data stores using Data connectors Data analysis, multi-dimensional data modelling, tabular modelling. Manage personal or sensitive information with appropriate controls and protection. Design and implement database sharding with the capability of Horizontal scaling. Assist in the procurement process for AWS Platforms and BI components. Identify technical risks and dependencies. Implement Active Directory service with Kerberos authentication. Train Technical and non-technical users to manage the BI platform and products. Skills & Experience • Have demonstrable experience of successfully understanding user needs and designing services to support them, implementing BI POC solutions and improving them using Agile methods and practices. • Have demonstrable experience of using AWS environment, Power BI to develop interactive reports and dashboards for visual insights, SQL databases and data warehouse services. • Have 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. • Have demonstrable experience of managing sensitive information with appropriate controls and protection, designing, maintaining database architecture, conceptual, logical and physical data models for business intelligence with disaster recovery. • Have a good understanding of Column store indexes and experience in Enterprise data modelling. • Have demonstrable experience of successfully working with other suppliers/3rd parties/other partners in the delivery of public sector digital services. Nice to Haves • 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. • Know of Microsoft Azure Data Warehouse would be advantageous to compare solutions built in AWS and Azure. Work Location Westminster, London Working Arrangments 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 T&Cs Breakpoints to assess progress and quality will be set at regular intervals of the Project. No. of 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. Evaluation Weighting Technical competence 60% Cultural fit 15% Price 25% Questions from Suppliers 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. 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. 3. 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. 4. Can the authority please confirm the IR35 status of this role. We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis. 5. Please could you confirm the IR35 status. We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis. 6. 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. 7. This is currently listed as specialist role "designer". Can this be changed to Developer/Tech Architect? The correct Role for this requirement is Developer.