Lead Engineer: Data Architect

Up to £48859 per annum + Pension + Benefits
13 Jan 2021
10 Feb 2021
Laura McKeating
Contract Type
Full Time
Role: Lead Information Systems Engineer: Data Architect
Job Type: Fixed Term Contract, 2 years
Hours: 37.5
Grade: G7
Locations: Flexible with occasional travel to PHE sites
Salary: £48,859

Badenoch & Clark are proud to be partnering with Public Health England to supply the best IT talent for a number of opportunities to support the ongoing digitalisation and evolution of services over the next 1-2 years. Public Health England exist to protect and improve the nation's health and wellbeing and reduce health inequalities. Public Health England do this through world-leading science, research, knowledge and intelligence, advocacy, partnerships and providing specialist public health services. As a result, we are looking to recruit a Lead Information Systems Engineer: Data Architect on a 24-month Fixed Term Contract to work within the Information and Communications Technology Department.

ICT Intro
The Information and Communications Technology Department (ICT) has primary responsibility for service technical infrastructure and support. ICT has staff at a number of locations throughout the Organisation. The key functions of ICT are to provide and support such systems required by the staff of Public Health England (PHE), and to provide the technical infrastructure to enable all forms of corporate communication, both within the Organisation and between the Organisation and its customers and stakeholders.

* Learning and development tailored to your role
*An environment with flexible working options
* A culture encouraging inclusion and diversity
* A Civil Service pension

Job Summary
Hosting and Data Curation for the design, delivery, improvement of Enterprise data solutions for the PHE database services both on premise and on public cloud infrastructures, as well as integration of the new technologies. Provide technical and strategic leadership for architecting PHE's SQL and NOSQL platforms and work closely with internal SQL, Cloud and DevOps engineers to provide a holistic approach in implementing a full end to end infrastructure as a code capability.

Main Duties & Responsibilities
*Lead the strategic drive in architecting Enterprise data solutions. Identifying development opportunities in these fields and lead associated work-streams.
*Lead the planning, design, implementation and post implementation tasks for the organisation's Enterprise Data solutions comprising SQL Server and NoSQL technologies
*Responsible for large-scale data migration programs, working with the PHE's application owners and data scientists
*Overall curation of platform data stores from a performance and reliability and security perspective
*Coding using tools such as Python, Perl and Powershell.
*Lead the drive towards automation, reducing the management overhead and developing a more self-sufficient infrastructure.
*Hosting and Data Curation, design, plan, implement and manage infrastructure monitoring systems to support performance and capacity planning.
*Develop standards, policies, guidelines and procedures defining the usage of database systems and services.
*Provide technical leadership for database security initiatives, working closely with security colleagues and ensuring that security remains a primary objective for PHE ICT.

Essential Skills
*Educated to degree level in relevant subject or equivalent level of experience of working at a similar level in specialist area
*Must have previous experience of managing systems for a large user base
*High level of expertise as a DBA in the administration, design and implementation of backups, performance tuning, management and provisioning of MS SQL database instances
*Strong technical background in Microsoft SQL Databases, Microsoft Reporting Tools (SSRS, PowerBI) and Microsoft data extraction methods (SSIS).
*Certification (Advantageous)
*Knowledge of PostgreSQL/MSSQL/MariaDB would be a distinct advantageous as well as the ability to work across a range of technologies
*Database clustering: HA, and distributed active/active system
*Fluent in various development languages e.g. SQL, Python, Powershell, PL/SQL
*Knowledge of NoSQL DB's, e.g. MongoDB, Cosmos DB and Elastic
*You have a good knowledge of SQL Data Warehouses and have (ideally) experience working with multi-dimensional data
*Working knowledge of ODBC
* Experience in maintaining ETL pipelines and supporting large scale data infra projects

Things you need to know
*Successful candidates must pass a disclosure and barring security check.
*People working with government assets must complete basic personnel security standard checks.

Selection process details
*Open to all external applicants (anyone) from outside the Civil Service (including by definition internal applicants).
*Feedback will only be provided if you attend an interview or assessment.

Badenoch & Clark and Public Health England are equal opportunities employers. If you are unfortunately unsuccessful for this opportunity, we will keep your details on file and may contact you about any other suitable opportunities.

For more information on this role please visit us online where you can also submit an application: https://hyphen.avature.net/PublicHealthEnglandApplicationPage

Badenoch + Clark acts as an employment agency for permanent recruitment and an employment business for the supply of temporary workers. Badenoch + Clark UK is an Equal Opportunities Employer.

By applying for this role your details will be submitted to Badenoch + Clark. Our Candidate Privacy Information Statement explains how we will use your information - please copy and paste the following link in to your browser: https://www.badenochandclark.com/en-gb/candidate-privacy

Apply for Lead Engineer: Data Architect

Already uploaded your CV? Sign in to apply instantly


Upload from your computer

Or import from cloud storage

Your CV must be a .doc, .pdf, .docx, .rtf, and no bigger than 1MB

4000 characters left

You are about to register with the Adecco Group UK & I as a candidate. During your registration, we will collect and use information about you to make available our services and maintain our relationship with you. Our Privacy Information Statement explains how we collect and use information about you and the rights you have.

Where you choose to give us so called sensitive information* other than where we ask for it, by giving us that information, you agree that we may use it in the way set out in the Privacy Information Statement.

* This is information that gets special protection under our privacy laws. It is information about your race or ethnic origin, political opinions, religious or philosophical beliefs, trade union membership, health, genetic or biometric details, sex life and details of any criminal convictions or similar you may be subject to.

♦ The business of the Adecco Group UK & Ireland is transacted via a number of differently branded trading entities, as follows: Adecco UK Limited, Adia Technology Limited, Modis International Limited, Badenoch and Clark Limited, Ajilon (UK) Limited, Office Angels Limited, Penna plc, Pontoon Europe Limited, Roevin Management Services Limited, Spring Technology Staffing Services Limited.

Similar jobs

More searches like this

Similar jobs