Data Engineer – Location Intelligence Group
This is an exciting opportunity to join CACI
CACI is recruiting for a Data Engineer within the Location Intelligence Group who will be converting complex analytical algorithms into repeatable, efficient code that forms the backbone of our client models.
Who we are
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 analysing 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 Marketing Solutions Division, you will be joining a 250 strong team working in over 50 markets globally.
Our people are what really make us different. We are a growing and dynamic group of analysts, data scientists and commercially savvy consultants. We are passionate, progressive, and unafraid of challenge; our mission is to use data-driven insight to make a commercial difference.
Location Intelligence Team
We are the leading Location Intelligence team across the world, responsible for delivering advanced spatial analysis and insight to major organisations across a range of sectors and countries. We provide consultancy, cutting edge software and the latest data to help our clients optimise their location strategies across both the physical and digital landscape. Projects typically last between a week and six months, ranging from performance analysis, customer insight, defining network strategies, BI & visualisation and advanced predictive modelling. We work closely with our clients to ensure we understand their aims and objectives, incorporate their feedback and knowledge, and develop a bespoke solution to meet their business needs.
We have a team of over 25 analysts working on a large number of projects at any one time. Some of these projects involve complex predictive models built into our GIS software, InSite. The main role will be to work as part of a team of data engineering specialists who productionise and implement the models built by analysts within the team into InSite. You will be converting complex analytical algorithms into repeatable, efficient code that forms the backbone of our client models.
The models employed will require a mixture of SQL and Python code to be written in order to embed them into our GIS software and produce the required outputs in a quick and efficient manner. Outputs are then viewed in a variety of different software including AWS, Excel, GIS, PowerBI and interactive web reports.
What you’ll be doing
We are looking for a candidate to work within our Location Analytics technical team – working with companies from a broad range of sectors (e.g. retail, leisure, grocery, automotive and the public sector), both within the UK, across Europe and internationally.
- Converting complex analytical algorithms into repeatable, efficient code
- Productionising and implementing the models built by analysts
- SQL and Python code to be written in order to embed models into our GIS software and produce the required outputs
- Outputs viewed in a variety of different software including AWS, Excel, GIS, Power BI and interactive web reports
- Previous work experience in a data processing / data engineering role
- Work knowledge of SQL database queries, creating tables and database structures
- Familiarity with or a desire to learn Python
- Experience of using GIS platforms, building maps and reports from spatial data
- Strong Microsoft Excel skills.
- A self-starter willing to bring new ideas to the business to develop your colleagues and the wider team
- Self-motivated, organized, detail-oriented, with a positive, “can do” attitude
- Good communication skills including documenting best practice and system training
Whilst not essential, the following skills would also be desirable:
- Experience with learning to write and maintain programming code and database scripts using repository software, e.g. Git
- Familiarity in AWS or other cloud services, ETL software such as Alteryx
- Understanding of predictive models
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.
The Property Consulting Group’s goal is to be the biggest, and best, consultancy in the property sector, providing top quality insights, using cutting edge, innovative analytical techniques to the UK and Europe’s biggest retail, residential, office and logistics companies. As a member of our team, you will be key to helping us achieve this goal.
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.
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. Covid-19 has changed the way we work forever, and a new flexible working policy will be released when the situation stabilises.
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.
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.
For more information on CACI please visit our website (www.caci.co.uk) or contact Valentina Pucciano (MSD_Recruitment@caci.co.uk).
- Date posted: 29 July
- Location: London
- Salary: Competitive
- Job type: Full time