Data Assurance & Engineering Consultant

The Data Assurance & Engineering Consultant reports into the Data Services Director and has responsibility for the implementation of products and services that CDS uses in order to build data solutions for our customers.

This role is also responsible for supporting the Data Assurance and Engineering Lead to ensure that all CDS databases, whether customer or internal, are resilient, secure and performant.

This is a hybrid role, focusing on Data Engineering, Data Migration and Database Administration

This is a technical and customer facing role, at all times focusing on the creation and measurement of value to our customers, whether external or internal.

Accountabilities

• All data assurance and engineering work undertaken by CDS adheres to our frameworks & provides measurable value to our customers.


• Relationships with customers, vendors and contractors are conducted under our "One Team" ethos.


• All implemented data solutions are secure, resilient, monitored and performant.


Responsibilities

• Development and implementation of data assurance and engineering solutions for customers.


• Creation and maintenance of best practice and execution frameworks for data engineering:



• Data Migration strategy


• Data Migration execution


• ETL strategy / design and implementation


• Data modelling


• Performance / Cost optimization



• Implementation and adhering to frameworks for data assurance:



• Database tooling / design


• Data Governance


• Data Quality


• Security & Resilience


• Monitoring / Usage forecasting



• Contribute to the development of designs and proofs of concept to support the commercial / bids teams.


• Maintaining alignment with infrastructure services.


• Challenging assumptions and using data driven decision making to provide the optimal balance between theory and practicality.


• Keeping up to date with the latest capabilities and trends
  
  Experience of using ETL tools including but not limited to SSIS, Data Factory and Data Bricks to implement complex data loading and transformation processes.


• Building infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources.


• Experience in relational database design and implementation both on prem and cloud based.


• Understanding of security and quality models within database environments


• Demonstrable experience of query optimization within different scenarios


• Optimize data delivery, designing for resilience, scalability and future proofing.


• Experience of Azure and AWS data products is desirable but not essential


Personal Attributes

Problem Solving

We create and implement data services that focus on value and make a difference in people's lives. We work on projects that fit with the CDS core values of making a positive difference, and we are proud of the solutions that we deliver.

We differentiate ourselves by utilising other capabilities within CDS such as Behavioural Research, UX/UI Design & Infrastructure services to complement our approach and can offer our customers a unique and compelling service.

Our Hybrid working model is centred around a team delivery approach; meaning our people come first. Whether it's the school run, Tuesday night football or Thursday choir practice, as long as it works for the team, we'll support you. We believe it's more important what we do with our working hours than when we do them, and limited site visits enable us to adopt a flexible working approach that works for everyone., CDS is an agency that enables strategic change in organisations. We help clients create, develop, and deliver better services to meet the evolving needs of customers, employees and citizens.

Our experts specialise in technical enablement, operational transformation, experience transformation and business process outsourcing. We improve outcomes by resolving complex insight, digital, data, technology and print challenges.

Consequently, many of the largest, most complex organisations trust CDS to provide solutions that improve health, wealth and safety in the UK. For example:

• Digitally transforming the ability to report crime online for UK police forces.


• Building a new digital platform for the regulator Social Work England.


• Providing behavioural analysis and insight to drive EE's evolving digital and customer service offering and delivering marketing and operational print management services to the Ministry of Defence


Our clients include National Rail Enquiries, the Cabinet Office, Bank of England, Open University and Insight Investments. We also work with global brands, including Coca Cola, McDonald's and Microsoft.

Together with our parent company, Bailie Group, CDS is positioned as a leader in enabling change. We are a multi-award-winning agency recognised by the industries we serve and our peers for our innovations and contributions that truly make a positive difference.

To ensure the health, safety & wellbeing of our employees we have minimum standards for homeworking environments which must be maintained. Further details available on request.

In return

• Attractive base salary.


• 25 days holiday + public holidays.


• Company pension and life assurance scheme.


• Medicash health plan online GP access, support services & discounted gym membership.


• Complimentary fruit, coffee, tea, and Friday drinks at the office.


• Cycle to work scheme.


• Season pass loan for rail & bus travel.


• A business focused on professional development and personal growth opportunities.


• Smart, engaged co-workers and a culture of inclusion, innovation, and opportunity.