Scotland's Census 2021 Data Architect

Tender description

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. Specialist role Technical Architect Expected Contract Length 6 months Latest start date Monday 12 February 2018 Maximum Day Rate £650 per day inclusive of expenses. Who Speclialist Work With You will be working as part of the Census Architecture team with full responsibility for the data architecture domain. What Specialists 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 Skills & 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 Haves • 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 Work Location Edinburgh Working Arrangments 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 T&Cs 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. No. of 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 Evaluation Weighting Technical competence 60% Cultural fit 10% Price 30% Questions from 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.