CRM Data Engineer at CACI, Farnborough, £Contract Rate

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.

2. Analysing and fixing / enhancing PL/SQL routines.

3. 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

3. Ability to connect to a RESTful API and perform CRUD operations using tools such as Postman.

4. Ability to connect to a RESTful API from PL/SQL.

5. 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.