PowerBI Visualisation

Tender description

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. Specialist role Performance analyst Expected Contract Length 18 months Latest start date Tuesday 13 April 2021 Maximum Day Rate £650 per day MAX. (exclusive of VAT and includes T&S) Who Speclialist 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 Specialists 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. Skills & 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 Haves • 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 Work Location MOD Corsham / Working from home. Working Arrangments 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 T&Cs Off-payroll working rules apply (IR35 in-scope) No. of 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%) Assessment Method Scenario or test Evaluation Weighting Technical competence 65% Cultural fit 5% Price 30% Questions from 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.