Awarded to Techmodal

Start date: Monday 24 May 2021
Value: £248,300
Company size: SME
Defence Digital, MOD

PowerBI Visualisation

15 Incomplete applications

14 SME, 1 large

13 Completed applications

12 SME, 1 large

Important dates

Published
Wednesday 10 March 2021
Deadline for asking questions
Friday 12 March 2021 at 11:59pm GMT
Closing date for applications
Wednesday 17 March 2021 at 11:59pm GMT

Overview

Specialist role
Performance analyst
Off-payroll (IR35) determination
Summary of the work
Cyber Mission Data-Alpha(CMD-A) shall improve the quality of Defence data, through new data structures to enable data exploitation through Machine Learning and Data Science.
CMD-A will facilitate the delivery of new Cyber Insights upon data currently held and identify information to assist decision making whilst saving resource effort through automation.
Latest start date
Tuesday 13 April 2021
Expected contract length
18 months
Location
South West England
Organisation the work is for
Defence Digital, MOD
Maximum day rate
£650 per day MAX. (exclusive of VAT and includes T&S)

About the work

Early market engagement
Who the specialist will work with
The Power BI developer will work within the multi-disciplined Cyber Mission Data Alpha team. This team consists of Authority Crown Servants, current contract supplier technical resource, and separately procured technical resource.
The Cyber Mission Data Alpha team fits within the current construct of the Data as a Service function, which forms part of the wider Defence Cyber Operations.
What the specialist will work on
You will have a strong background in data and business analysis, be an excellent communicator and have an analytical approach.

You are expected to be highly skilled with the PowerBI application to develop, maintain and create dashboards based on the prioritised cyber use cases, to allow information to be clear and concise to support decision making at various tiers from Business through to tactical levels.

You will utilise new and existing processes providing data mapping and data analysis on a broad range of Cyber Data and visualise prioritised Cyber insights.

You will work closely with users/stakeholders to understand reporting requirements.

Work setup

Address where the work will take place
MOD Corsham / Working from home.
Working arrangements
5 days per week, either from MOD Corsham or working from home (to be agreed with the Authority).
Security clearance
DV, although initially SC (must be held to start role) would be acceptable with the aim to acquire DV once onboarded.
Sole UK nationality is required for this role.

Additional information

Additional terms and conditions
Off-payroll working rules apply (IR35 in-scope)

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
  • Expertise at Development using Microsoft Power BI including DAX (10%)
  • Proven experience as a BI Developer or Data Scientist (10%)
  • Background in data warehouse design and data mining (5%)
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework (5%)
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) (5%)
  • Analytical mind with a problem-solving aptitude (3%)
  • BSc/BA in Computer Science, Engineering or relevant (10%)
  • Skilled with a wide variety of data exploitation applications such as SPLUNK, and SQRRL (3%)
  • Consulting and business analysis skills to understand client's requirements (2%)
  • Experience in Agile delivery methodology (2%)
  • Produce technical specifications (2%)
  • Experience in Big Data platforms including HADOOP ecosystems (1%)
  • Experience working as a Database Analyst or Database Developer (1%)
  • Ability to programme in languages such as SQL, .NET, Python and Bash script (1%)
  • Understand Data modelling and ETL concepts (1%)
  • Understand and design Business Intelligence and reporting architecture (2%)
  • Understand concepts of dimensions, measures, metadata & schemas (1%)
  • Understand analytical processing (1%) https://www.gov.uk/guidance/content-designer
Nice-to-have skills and experience
  • Previous experience working within a defence or intelligence environment
  • Previous experience working within a defensive cyber security environment
  • Previous experience working within an agile development environment

How suppliers will be evaluated

All suppliers will be asked to provide a work history.

How many specialists to evaluate
3
Cultural fit criteria
  • work as a team with our organisation and other suppliers (1%)
  • be transparent and collaborative when making decisions (1%)
  • have a no-blame culture and encourage people to learn from their mistakes (1%)
  • take responsibility for their work (1%)
  • share knowledge and experience with other team members (1%)
Additional assessment methods
Scenario or test
Evaluation weighting

Technical competence

65%

Cultural fit

5%

Price

30%

Questions asked by suppliers

1. Is there a current incumbent?
Cyber Mission Data is a new project being stood up, so technically there is no current incumbent however, this project does supersede a project which had a current incumbent within it.
2. Is there a current incumbent or preferred supplier for this role please?
Cyber Mission Data is a new project being stood up, so technically there is no current incumbent however, this project does supersede a project which had a current incumbent within it.
3. Is there a current or preferred incumbent for this?
If there is any then please let us know what are the key pain points?
Is this requirement inside or outside of IR35?"
Cyber Mission Data is a new project being stood up, so technically there is no current incumbent however, this project does supersede a project which had a current incumbent within it.

Although Cyber Mission Data is superseding a project which is currently in place, CMD is an entirely new project with a different set of objectives, which warrant the Authority going out to market to ensure we are getting the most suitable specialists for each role. There were no particular pain points to address.

Inside IR35, off-payroll working rules apply.
4. Is there an incumbent in the role?
Is it a Ltd company or a service partner?
If incumbent is this a need/desire to replace?
Cyber Mission Data is a new project being stood up, so technically there is no current incumbent however, this project does supersede a project which had a current incumbent within it.

The question in relation to whether it is a Ltd company or a service partner is not understood. Please re-word and re-submit.

Although Cyber Mission Data is superseding a project which is currently in place, CMD is an entirely new project with a different set of objectives, which warrant the Authority going out to market to ensure that we are getting the most suitable specialists for each role.
5. Is there an incumbent suppplier curently providing this role?
Cyber Mission Data is a new project being stood up, so technically there is no current incumbent however, this project does supersede a project which had a current incumbent within it.
6. Is there an incumbent currently in place?
Cyber Mission Data is a new project being stood up, so technically there is no current incumbent however, this project does supersede a project which had a current incumbent within it.
7. Is there a current incumbent?
Cyber Mission Data is a new project being stood up, so technically there is no current incumbent however, this project does supersede a project which had a current incumbent within it.