National Records of Scotland

Scotland's Census 2021 Data Architect

Incomplete applications

7
Incomplete applications
6 SME, 1 large

Completed applications

13
Completed applications
11 SME, 2 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Tuesday 9 January 2018
Deadline for asking questions Tuesday 16 January 2018 at 11:59pm GMT
Closing date for applications Tuesday 23 January 2018 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Specialist role Technical Architect
Summary of the work Deliver the target data architecture for the census programme and develop the enterprise wide data model in line with the business requirements.
Latest start date Monday 12 February 2018
Expected contract length 6 months
Location Scotland
Organisation the work is for National Records of Scotland
Maximum day rate £650 per day inclusive of expenses.

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement
Who the specialist will work with You will be working as part of the Census Architecture team with full responsibility for the data architecture domain.
What the specialist will work on 1. Work as a member of the team and perform tasks and duties as required within the function and across the programme.
2. Deliver programme wide data architecture policies, standards and design patterns.
3. Develop the target data architecture for the programme delivering an enterprise wide data model.
4. Assure that products / systems / services delivered and operated are compliant with these policies, standards and patterns.
5. Take responsibility for producing the data architecture for specific products / systems / services and working with a variety of suppliers and business leads to ensure that these meet the business requirements

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place Edinburgh
Working arrangements The worker will be expected to be onsite at our Edinburgh office. Flexible working will be permitted if appropriate.
Security clearance Basic Disclosure Scotland followed by BPSS

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
Additional terms and conditions References to England and Wales in the original Clause 43.1 (Law and Jurisdiction) of this Call-Off Agreement shall be replaced with Scotland and the wording of the Framework Agreement and Call-Off Contract will be interpreted as closely as possible to the original English and Welsh Law intention despite Scots Law applying.
Reference to England and Wales in Working Days definition within Clause 44 (Defined Terms) shall be replaced with Scotland.
Reference to the Freedom of Information Act in Clause 18 (Freedom of Information (FOI) requests - Definitions to be replaced with Freedom of Information (Scotland) Act 2002.

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
  • Experience designing and implementing RDBMS technologies
  • Strong knowledge of ETL and data integration techniques
  • Experience with data modelling and BI tools
  • Ability to demonstrate significant experience in database design and data architecture experience Extensive knowledge of data warehouse, data architecture and best practices
  • Solid experience with Data Warehouse and BI systems. It is expected that the above will be part of the specialist toolkit the worker will bring to the post.
  • Demonstrable experience of influencing a wide range of internal and external stakeholders including senior officials, customers and suppliers.
  • Ability to mentor less experienced technical colleagues
Nice-to-have skills and experience
  • Knowledge and understanding of government information security standards
  • Experience working in a “just enough architecture” environment.
  • Certifications for database administration and/or TOGAF
  • Experience working with API’s
  • Experience in the management of ICT staff including technical specialists, external contracts and consultants
  • Demonstrable experience in working with teams and/or suppliers using diverse delivery models such as agile and waterfall in all phases of service development through to business as usua
  • Use of case tools such as Sparx Enterprise Architect.
  • Knowledge of Data vault modelling and implementation

How suppliers will be evaluated

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many specialists to evaluate 5
Cultural fit criteria
  • Be transparent and collaborative when making decisions
  • •Have a no-blame culture and encourage people to learn from their mistakes
Assessment methods
  • Work history
  • Reference
  • Interview
Evaluation weighting

Technical competence

60%

Cultural fit

10%

Price

30%

Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. Can you confirm how many Technical Architects are required? Is this role within IR35? Is the daily rate of £650 to include agency fee? I can confirm we are looking for 1 Data Architect.
We have evaluated the role as out of scope of IR35. This will be reviewed once more, once the contractor is in post and on a regular basis to evaluate if this remains the case.
The daily rate of £650 should include the agency fee.
2. Is this within or outside IR35 ? We have evaluated this role as out of scope of IR35. This will be reviewed once more, once the contractor is in post and on a regular basis to evaluate if this remains the case.