Data Products - Geo Data Engineer

Headquartered in London, CACI Ltd is a wholly owned subsidiary of CACI International Inc., a publicly listed company on the NYSE with annual revenue in excess of US $6.2bn and employing approx. 22,000 people worldwide.

CACI Ltd is an international data and technology consultancy with £154m turnover and 1200 employees. We are passionate, progressive and unafraid of challenge; our mission is to use technology and data-driven insight to make a commercial difference.

We provide expert advice and hands-on system management to help our national and global clients get the most from technology and data. We use innovation wisely to deliver well thought-out digital solutions and software.

CACI's Consumer & Market Intelligence and Experience & Transformation groups provide data, software and consulting services to improve our clients’ sales and marketing programmes.

We help clients find, retain and grow profitable customers through our understanding of consumer characteristics and behaviour. And we help commercial property developers and retailers plan retail provision in the UK and overseas.

C&MI and E&T Groups help clients shape the vision, define the strategy and deliver a truly integrated customer experience. Our services are based on in-depth understanding of individual consumer behaviour and marketing technology which influence the way consumers buy products and services through a combination of data, technology and consultancy.

Data Solutions Group

Data is at the heart of our company, and the Data Solutions Group are the experts on the data used by various teams across CACI as well as by our external customers.

As part of the wider Product Strategy and Implementation team, we are responsible for the ingestion and management of third party data, mostly of a geographic nature, making it usable and accessible across the business. Such data includes demographics, street mapping, administrative and postal boundaries and retail location data, both for the UK and worldwide.

Our team actively collaborate with other parts of the business, to development and maintain a global portfolio of CACI’s own data products that are used across a wide range of sectors including retail, leisure, media, finance, health and local government.

Many of our data solutions are held in our AWS Data Lakehouse, published for use with CACI’s Geographical Information System software, InSite or exported for clients to use in their own systems.

The team provide technical support for internal users of InSite assisting with data product knowledge and best practice for using the data on client projects.

As an innovative group, we have a wealth of experience using programming languages such as SQL, Python and SAS and different ETL and GIS applications. Working with the wider business across a variety of sectors offers numerous opportunities to build up experience and learn new skills.

The department is recruiting for a role based in our head office at West Kensington in London.

The role

Working in a team of 12 people, you will be responsible for processing a wide variety of spatial and non-spatial datasets and providing expertise and support to internal users in different roles and departments. This involves understanding complex data structures, creating processes to manipulate and clean the data, then loading it into internal applications or creating files for clients to use.

As a team we are aways striving to innovate and improve existing processes to make them more efficient and more accurate. You will have the opportunity to challenge the norm and create new and improved processes as part of your everyday work. We are transitioning to storing and processing data in a central data lakehouse, and you will have the opportunity to be part of this journey, applying your existing knowledge and experience as well gaining from formal training and experience from colleagues.

Key responsibilities

• Providing technical support and data product expertise to internal users
• Data ingestion and processing of data
• Verifying, reformatting and enhancing source data using various ETL tools
• Building databases for use in InSite, our proprietary Geographical Information System (GIS), taking feeds from the Data Lakehouse.
• Assisting in the transformation of existing semi-automated legacy data processes (SAS, FME) to automated and efficient processes run via the Data Lakehouse
• Creating and applying quality assurance processes to ensure that work is delivered to a high standard.

Skills, knowledge & experience

Your skills and experience will include:

• Minimum two years experience working in a data driven commercial environment with a strong technical background, ideally including Python
• Experience with GIS and ETL products for data processing and analysis (FME, ESRI, QGIS, Alteryx etc)
• Competent with SQL query languages in order to retrieve and manipulate data in Postgres and SQL server.
• A self-disciplined, and driven person who takes the initiative, works well under pressure and meets deadlines
• A quick learner with a passion for problem solving, able to translate general requirements into specific actions
• Strong in attention to detail and ability to quality assure outputs with a pragmatic, common sense approach
• Excellent written and verbal communication skills with the ability to communicate technical concepts to a non-technical audience
• A communicative person who values building strong relationships
• Passionate about creating and using geographic data to improve business practices with a drive to innovate and enhance solutions

Desirable skills and experience

• Knowledge and experience of Amazon S3, Athena and Glue
• Experience with using and processing spatial data
• Experience of project management techniques

We are committed to creating a diverse environment and are proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Successful candidates must have the right to work in the UK.

#J-18808-Ljbffr