Analytics Engineer in Welwyn Garden City

As the Analytics Engineer on the Cyber Analytics team, you will be responsible for transforming the raw data into organised, usable, well documented and tested data models. These data models will empower security teams to draw insights and develop reporting capability, advanced analytics, machine learning and GenAI solutions to strengthen our security defences. You will collaborate closely with cross functional security and data teams to ensure the security data is reliable, accurate and accessible.

What is in it for you:

• Annual bonus scheme of up to 20% of base salary
• Holiday starting at 25 days plus a personal day (plus Bank holidays)
• Private medical insurance
• 26 weeks maternity and adoption leave (after 1 years' service) at full pay, followed by 13 weeks of Statutory Maternity Pay or Statutory Adoption Pay, we also offer 6 weeks fully paid paternity leave
• Free 24/7 virtual GP service, Employee Assistance Programme (EAP) for you and your family, free access to a range of experts to support your mental wellbeing

You will be responsible for:

• Data Integration and Transformation: Implement the ETL/ELTs to move data between the raw, trusted, and curated data layers of data lake supporting various real time and batch cyber use case.
• Data Modelling: Implement the logical and physical data model for the cyber data products to support threat detection, incident response and reporting.
• Coding and Documentations: Contribute to raising the quality bar of the team's codebase by producing high-quality code and documentation of data pipelines, data models and their quality metrics.
• Collaboration and Communication: Collaborate and communicate effectively with stakeholders and members of the data team and actively participate in monitoring and improving the data quality of the cyber data products.

You will need:

• A strong passion for big data, data modelling, data quality and ETLs
• Proficiency in SQL and programming languages like Python
• A working knowledge of ETL and ELT frameworks, data modelling and orchestration tools like Airflow and dbt
• Experience with cloud data platforms e.g. Databricks on Azure and a good understanding of data lakes and data warehouses concepts
• A good practical understanding of version control systems such as Git plus experience working with BI tools like Tableau
• Good knowledge of cybersecurity principles and practices

About us:

Our vision at Tesco is to become every customer's favourite way to shop, whether they are at home or out on the move. Our core purpose is 'Serving our customers, communities and planet a little better every day'. Serving means more than a transactional relationship with our customers. It means acting as a responsible and sustainable business for all stakeholders, for the communities we are part of and for the planet. We are proud to have an inclusive culture at Tesco where everyone truly feels able to be themselves. At Tesco, we not only celebrate diversity, but recognise the value and opportunity it brings. We're committed to creating a workplace where differences are valued, and make sure that all colleagues are given the same opportunities. We're proud to have been accredited Disability Confident Leader and we're committed to providing a fully inclusive and accessible recruitment process.

We’re a big business and we can offer a range of diverse full-time & part-time working patterns across our many business areas, which means that we can find something that works for you. We work in a more blended pattern - combining office and remote working. Our offices will continue to be where we connect, collaborate and innovate. If you are applying internally, please speak to the Hiring Manager about how this can work for you - Everyone is welcome at Tesco.