CRM Data Engineer

About CACI From our headquarters in London, we’re busy empowering organisations to make bold, strategic moves with the power of data and technology. Founded in 1975, our operations take place from multiple offices across the UK, Europe and India with over 1600 full-time employees and an annual turnover of £179m. Our expertise spans industries, from retail and education to public sector and transport – delivering intelligent solutions that drive progress and create measurable impact. Whether it’s business intelligence, customer marketing, cloud infrastructure, cybersecurity, critical national infrastructure or data management, our approach is never one-size-fits-all. We don’t just deliver solutions; we build for the tomorrow’s world, all while fostering a culture that allows employees to be their authentic selves and succeed in their careers. The role We are currently looking to hire a CRM Data Engineer to join the team here at CACI and work with one of our customers in migrating large amounts of data from one from one system to another putting in place checks and balances via Oracle SQL to ensure no data loss, quality loss or creation of duplicate records Key Skills & Experiences • Is proficient in Oracle (at least 3 years) and • Can use Oracle SQL to run complex queries (aggregations, analysis) and present results to the business in an intuitive manner • Ability to compare customer data and related objects between multiple integrated systems in order to identify integration gaps. Ability to develop potential strategies to overcome synchronisation issues and implement cleansing routines • Experience (3 years +) in the migration of large amounts of customer data from one system to another, putting in place checks and balances via Oracle SQL to ensure no data loss, quality loss or creation of duplicate records. • Able to create and maintain Oracle PL/SQL code. • Experience (3 years +) in using PL/SQL and has day to day thorough grasp of: 1. Creation of PL/SQL interfaces, packages, stored procedures with complex business logic. 1. Analysing and fixing / enhancing PL/SQL routines. 1. Ability to create Oracle table schemas and populate them using external data files / database links using Oracle PL/SQL routines • Understands and can use RESTful APIs • At least 2 year’s experience within IT projects of connecting systems using RESTful APi’s (ability to perform CRUD operations in a remote target system). 1.Understanding of RESTful APIs and ability to familiarise with existing APIs using their documentation. 2.Understanding of authentication / security concepts around RESTful APIs 1. Ability to connect to a RESTful API and perform CRUD operations using tools such as Postman. 1. Ability to connect to a RESTful API from PL/SQL. 1. Proficient in Json and XML. • The individual will have well-honed System Analysis skills , can understand end to end data flows and data transformations in an end-to-end system landscape: Specifically: • An expert in CRM / Customer data handling. Understanding of legal and logical challenges when using large amounts of customer data that is collected from multiple backend systems into a central CRM solution. • At least 5 years within IT project working across a complex, integrated system landscape across multiple functions and departments (complex IT ecosystems) , for example where customer records are being touched across multiple systems and business processes. Demonstrate an understanding of the challenges of integrated systems and proven track record of developing strategies to overcome these challenges in a system analyst and development capacity. • They will be self sufficient in scoping and design solutions and be able to interact/present to business and externals with limited guidance. Expected behaviors We have a structured performance management framework which measures continual attainment against key personal behaviours. We believe this is an important part of our success and culture. Joining as a team member we expect you to act as a role model and exemplar against these behaviours which are to be: • Proactive • Adaptable • Flexible • A team player • Reliable Flexibility The key to our success is our teamwork and collaboration. We take a hybrid approach – working remotely and coming into the office depending on the business demand and collaboration required as part of the delivery process. Equal opportunities CACI is proud to be an equal employer. Embracing the diversity of our people, we are on a journey to build a truly inclusive work environment where no one is treated less favorably due to ethnic origin, age, gender, veteran status, religion or belief, sexual orientation, marital status, and disability or health condition, actively working to prevent discrimination. As a Disability Confident employer, we will: • Provide reasonable adjustments in the recruitment process where requested (contact a member of the recruitment team on 020 7602 6000 to discuss individual requirements further). • Offer people with health conditions and disabilities, meeting the minimum criteria for a role, an interview. Our people are unique, and we encourage, and support them, to be confident in contributing to our inclusion journey.