Awarded to SATIGO

Start date: Thursday 1 March 2018
Value: £82,550
Company size: SME
National Records of Scotland

Scotland's Census 2021 Data Architect

7 Incomplete applications

6 SME, 1 large

13 Completed applications

10 SME, 3 large

Important dates

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


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
Organisation the work is for
National Records of Scotland
Maximum day rate
£650 per day inclusive of expenses.

About the work

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

Address where the work will take place
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 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.

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 many specialists to evaluate
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


Cultural fit




Questions asked by suppliers

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.