Properties Division, Department of Finance, Northern Ireland

Business Intelligence Services

Incomplete applications

4
Incomplete applications
4 SME, 0 large

Completed applications

10
Completed applications
9 SME, 1 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Friday 16 June 2017
Deadline for asking questions Tuesday 20 June 2017 at 11:59pm GMT
Closing date for applications Friday 23 June 2017 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Specialist role Developer
Summary of the work As part of a wider transformation project we are seeking to procure support from interested suppliers to further enhance our existing BI capability built on the Microsoft BI stack.
Latest start date Monday 10 July 2017
Expected contract length 2 years
Location Northern Ireland
Organisation the work is for Properties Division, Department of Finance, Northern Ireland
Maximum day rate £500.00 and total value of the contract will not exceed £30k.

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement
Who the specialist will work with The specialist will work with the product owner, users from the business and IT staff from NICS. The product owner will agree the requirements, specification and quality of work to be delivered. The buyer will provide development, UAT and production platforms and licences. The specialist will be working with an in-house IT resource to transfer knowledge and skills.
What the specialist will work on As part of a wider transformation project we are seeking to procure support from interested suppliers to develop our existing BI system and deliver further enhancement using the latest suit of Microsoft analytical tools. The existing BI tool is developed in the Microsoft PowerBI stack using Sharepoint as a platform.
In addition to BI development we require experience in data cleansing and Data modelling, SQL and Server Administration & Performance Tuning, SSIS, SSRS, and SSAS Multidimensional PowerBI & Power Pivot and SharePoint.
Business analysis and presentational skills are also required in order to develop customer requirements.

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place The supplier will be working mainly from two customer sites for the duration of the development and implementation phase: Clare House, 303 Airport Road, Belfast, and Northland House, 3-5 Fredrick Street, Belfast.
Working arrangements The supplier will be working on site as required in order to develop requirements with various groups, from operational staff to senior management. The supplier will be expected to be on-site approximately two to three days per week during the development and implementation phase. An essential component of delivery is working with in house staff to deliver coaching and mentoring. The implementation phase is likely to take 3 to 4 months to complete and thereafter as and when required for further enhancement.
Security clearance The supplier will be required to have Basic Security Clearance.

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
Additional terms and conditions

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 a minimum 3 years experience of successfully understanding user needs and designing BI reporting to suit.
  • Have demonstrable experience in developing system prototypes that are user-centric in their design.
  • Have demonstrable experience of using Miscrosoft Power BI to develop interactive reports and dashboards for visual insights.
  • Have demonstrable experience of using SQL databases and SQL server and data warehouse services.
  • Be able to use Agile development methods to deliver the requirements.
  • Have demonstrable experience in data modelling and data cleansing.
Nice-to-have skills and experience
  • Have experience of web application development using MVC or other tools
  • Have experience of working with public sector or IT Assist, (NICS ICT shared service provider)
  • Have experience using property asset data to support strategic planning using analytics.

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
  • Have experience in transferring knowledge and experties to others
  • Can work with clients with low technical expertise
  • Work as a team with our users and NICS ICT staff
Assessment methods Work history
Evaluation weighting

Technical competence

50%

Cultural fit

10%

Price

40%

Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. Does the candidate need to have the BPSS already, or can this be obtained on appointment? This is a core requirement. The candidate must have BPSS prior to the appointment.
2. Is the role inside or outside of IR35 regulations? Given that the buyer is seeking the delivery of specified outcome within a specified timescale then the engagement falls outside the provisions of IR35.
3. Can any other security clearance such as CTC, SC or DV be considered for this role Basic Security Clearance is the minimum and any clearance that is above Basic will be considered.
4. What is the lead time for feedback once the application is submitted? The feed back will be provided within a week after the completion of the evaluation stage.
5. Will this role be within IR35 Given that the buyer is seeking the delivery of specified outcome within a specified timescale then the engagement falls outside the provisions of IR35.
6. Can more than one candidate per supplier be submitted for this role Yes there can be more than one candidate.
7. What are the other expenses which will be paid. No other expenses will be paid.
8. Any chances of change in start date as the latest date mentioned is Monday 10 July 2017. I am afraid not. There can be no change to start date.
9. Any specific format(pdf,doc) in which CVs to be sent later There is no specific format.
10. Is occasional remote working allowed? The supplier will be expected to be on-site approximately two to three days per week during the development and implementation phase.
11. What is the total number for positions open for this role We are essentially looking for one position. However the individual could be substituted to deliver the specified outcome.
12. Is there any travel involved in this role and will the travel expenses be paid ? The suppliers will be expected to work from buyer's locations (Northland House, Belfast or Clare House, Airport road, Belfast) as was published in the requirement document. No travel expenses will be paid.
13. Is the rate inclusive or exclusive of VAT? The rate is exclusive of VAT.
14. Would you consider work permit holders (e.g. Tier 2 General Visa) and EU passport holders for this role ? Under the Digital Outcomes and Specialists framework we enter in a contract with the supplier, not the specialists him/herself. Therefore it depends on your supplier.