Analytics Engineer

WeAreTechWomen; Welwyn Garden City; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

A leading tech organization is looking for an Analytics Engineer to transform raw data into well-structured data models. Responsibilities include implementing ETL processes, collaborating with security teams, and ensuring data quality. Ideal candidates will have strong SQL and Python skills, experience with ETL frameworks, and a passion for data modelling. This is a full-time position promoting a blended work pattern, combining remote and office work, in a company that values diversity and inclusion.

Benefits

Flexible working patterns

Diversity and inclusion initiatives

Career development opportunities

Qualifications

• Strong passion for big data and data modelling.
• Practical understanding of cybersecurity principles.
• Experience with cloud data platforms and data lakes.

Responsibilities

• Transform raw data into organised, usable models.
• Implement ETL/ELT processes for data movement.
• Collaborate with cross-functional teams on data quality.

Skills

SQL

Python

ETL/ELT frameworks

Data modelling

Data quality

BI tools (e.g., Tableau)

Version control (e.g., Git)

Tools

Databricks

Airflow

dbt

Job description

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.

Data Integration and Transformation: Implement the ETL/ELTs to move data between the raw, trusted, and curated data layers of the data lake supporting various real‑time and batch cyber use cases.

Data Modelling: Implement the logical and physical data model for the cyber data products to support threat detection, incident response, and reporting.

Coding and Documentation: 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 have a strong passion for big data, data modelling, data quality, and ETLs.

As you have gained more experience in your field you will have a proficiency in SQL and programming languages like Python.

It would be great if you can demonstrate a working knowledge of ETL and ELT frameworks, data modelling, and orchestration tools like Airflow and dbt.

You will have worked with cloud data platforms e.g. Databricks on Azure, which will be accompanied by a good understanding of data lake and data warehouse concepts.

You will have good practical understanding of version control systems such as Git plus experience working with BI tools like Tableau.

You will have good knowledge of cybersecurity principles and practices.

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. For further information on the accessibility support we can offer, please click here.

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.