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 CACIs 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 CACIs 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 our 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: Experience working in a data driven commercial environment with a strong technical background, ideally including Python Experience with 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 include: Knowledge and experience of GIS, Amazon S3, Athena and Glue Experience with processing spatial data Experience of project management techniques ADZN1_UKTJ