Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Build data models using GCP BigQuery and dbt Cloud to support analytics.
- Company: Join Virgin Media O2, the UK's fastest broadband network and a beloved mobile brand.
- Benefits: Enjoy a comprehensive benefits package and a culture that celebrates inclusivity.
- Why this job: Be part of a diverse team that values your contributions and empowers you to excel.
- Qualifications: Must have SQL expertise and experience with large datasets and data modelling.
- Other info: We encourage authenticity in your application journey.
The predicted salary is between 43200 - 72000 £ per year.
Location: Data Democratisation function
Responsibilities:
- Use cutting-edge technology on GCP BigQuery and dbt Cloud to build world-class data models.
- Surface data to the company through well-maintained data models and data products.
- Support API services and assist analyst and visualization teams to be self-sufficient, focusing on data infrastructure, transformation, and quality processes.
Who we are:
The UK’s fastest broadband network, the nation’s best-loved mobile brand, and one of the UK's biggest companies. Diverse, high-performing teams with serious talent, offering the UK more choice and value through our customer-centric values and ambitions. We are Virgin Media O2, eager to see what you can contribute.
Our commitments:
Accessible, inclusive, and equitable for all. Virgin Media O2 is an equal opportunities employer, committed to removing bias and barriers, fostering equity and inclusion in all aspects of our work and candidate engagement. We encourage you to be authentic throughout your application journey.
Minimum Requirements:
To be considered, you must have:
- SQL expertise, including complex query writing, optimization, data modeling, and performance tuning.
- Experience with large datasets, stored procedures, functions, triggers, and ETL processes.
- Experience with products like Apache Airflow, DBT, Gitlab/Github, BigQuery.
- Experience in Data Modelling, working with denormalized data structures, testing, asserts, and data cleansing.
Preferred Skills:
Additional qualities we value:
- Developing robust applications, scripts, and libraries.
What’s in it for you:
We aim to celebrate our people and create an inclusive culture that empowers everyone to bring their best selves to work. Our benefits package is comprehensive, supporting you and your loved ones through life's challenges.
Senior Analytics Engineer employer: Virgin Media O2
Contact Detail:
Virgin Media O2 Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Analytics Engineer
✨Tip Number 1
Familiarise yourself with GCP BigQuery and dbt Cloud. Consider taking online courses or tutorials to deepen your understanding of these tools, as hands-on experience will set you apart from other candidates.
✨Tip Number 2
Network with current employees at Virgin Media O2 through platforms like LinkedIn. Engaging with them can provide insights into the company culture and the specific skills they value, which can be beneficial during interviews.
✨Tip Number 3
Prepare to discuss your experience with SQL and large datasets in detail. Be ready to share specific examples of how you've optimised queries or improved data models in previous roles, as this will demonstrate your expertise.
✨Tip Number 4
Showcase your problem-solving skills by preparing for technical challenges that may arise during the interview process. Practice explaining your thought process clearly, as communication is key in collaborative environments.
We think you need these skills to ace Senior Analytics Engineer
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities of a Senior Analytics Engineer. Familiarise yourself with GCP BigQuery, dbt Cloud, and the specific skills required such as SQL expertise and data modelling.
Tailor Your CV: Customise your CV to highlight relevant experience and skills that align with the job description. Emphasise your expertise in SQL, large datasets, and any experience with tools like Apache Airflow and Gitlab/Github.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data analytics and how your background makes you a perfect fit for Virgin Media O2. Mention your commitment to inclusivity and how you can contribute to their diverse teams.
Proofread Your Application: Before submitting, carefully proofread your application materials. Check for any spelling or grammatical errors, and ensure that all information is clear and concise. A polished application reflects your attention to detail.
How to prepare for a job interview at Virgin Media O2
✨Showcase Your SQL Skills
Be prepared to discuss your SQL expertise in detail. Bring examples of complex queries you've written, and be ready to explain how you optimised them for performance. This will demonstrate your technical proficiency and problem-solving abilities.
✨Familiarise Yourself with GCP and dbt
Since the role involves using GCP BigQuery and dbt Cloud, make sure you understand these tools well. Brush up on their features and functionalities, and think of specific instances where you've used them in past projects.
✨Understand Data Modelling Concepts
Be ready to discuss your experience with data modelling, especially with denormalised data structures. Prepare to explain how you've approached testing, asserts, and data cleansing in your previous roles.
✨Emphasise Collaboration and Support
The role requires supporting API services and assisting analyst teams. Highlight your experience in collaborative environments and how you've empowered others to be self-sufficient in data-related tasks.