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 1100 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 Marketing Solutions Division provides 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. MSD helps 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. At CACI we do amazing things with data. We build some of the most highly regarded, innovative datasets in the market and our people are the best at manipulating that data to provide insight to our clients. We are experts in all things consumer and location and bring together cutting-edge analytical techniques, creative thinking and diverse perspectives to drive growth for our clients. As part of the wider Consumer & Market Intelligence Group you will be joining a 250 strong team working in over 50 markets globally. 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 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: 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 include: Knowledge and experience of Amazon S3, Athena and Glue Experience with processing spatial data Experience of project management techniques What we can offer you We don’t settle for people that can just do the job, we look for people that are constantly trying to push the boundaries and improve what we do. This is what makes CACI a great team to be a part of. Innovation is hugely important to us and we guarantee everybody in the business gets to spend 5% of their time innovating and training. If you are an innovative thinker and like to challenge the norm, coming up with new ways of doing things, then you will be surrounded by likeminded people at CACI. Progression We understand that your career progression is important to you. Unlike many organisations, promotions happen twice a year at CACI. This gives you more opportunity to progress. At CACI people get promoted on merit, when they are ready. This means that your career is completely in your own hands and there is never a ceiling for your progress. Everyone’s career path is different. We welcome people exploring different areas and trying out new skillsets. Just because you start off down one path doesn’t mean you are committed to it indefinitely. At CACI you have the freedom to carve your own career path. Flexibility The key to our success is our teamwork and collaboration and that tends to work best when we are all in the office working together. That said, we fully appreciate that everyone leads busy lives and we can’t always be in the office. This is why we embrace flexible working with a requirement to be in the office 2-3 days per week. Development Your development is key and is a top priority for the team. We offer 3 types of training: externally run consulting courses, externally run bespoke courses and internal courses. Everyone has different training requirements which means everyone has their own training plan. A bespoke training plan will be created for you when you join. Benefits We have a range of benefits on offer to support you. We have a comprehensive list of schemes ranging from pension plans to health and wellness policies, in addition you can opt into a selection of flexible benefits to meet your personal needs. 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. Other details Pay Type Salary