Data Assurance & Engineering Consultant

Bailie Group

  • Leeds
  • Permanent
  • Full-time
  • 14 days ago
About the CDS Data TeamWe 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.About the roleThe 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 AdministrationThis 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 trendsTechnical Skills and Capabilities
  • 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 AttributesProblem SolvingDiscipline««««Creativity«««Teamwork««««Communication«««IntegrityProfessionalismVettingDue to the nature of this role and the business, you will need to either currently hold UK Government clearance to a minimum of SC level or be able to undergo and maintain this level of clearance.Hybrid & HomeworkingTo 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.
About CDSCDS 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.Our inclusive cultureCDS positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, gender reassignment, religion or belief, marital status, or pregnancy and maternity. We foster an inclusive culture that enables everyone to achieve their full potential and enjoy a fulfilling career with us.

Bailie Group