At a Glance
- Tasks: Build and maintain data models using GCP BigQuery and dbt Cloud.
- Company: Join Virgin Media O2, the UK's fastest broadband network and a beloved mobile brand.
- Benefits: Enjoy a fantastic reward package with flexible benefits for you and your loved ones.
- Why this job: Be part of a diverse team that champions inclusivity and empowers you to be your authentic self.
- Qualifications: Must have SQL expertise, experience with large datasets, and familiarity with tools like Apache Airflow and DBT.
- Other info: Expect a three-stage interview process and support for any adjustments needed during recruitment.
The predicted salary is between 43200 - 72000 Β£ per year.
As a Senior Analytics Engineer in our Data Democratisation function, you will use cutting-edge technology on GCP BigQuery and dbt Cloud to build world-class data models to surface data to the company. Working in a network environment, you will be responsible for maintaining data models and data products to service APIs and helping analysts and visualisation teams to be as self-sufficient as possible without needing to worry about the data infrastructure, data transformation, and data 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 too. Diverse, high-performing teams - jam-packed with serious talent. Together, we offer the UK more choice and better value, through our boundary-pushing, customer-championing values and ambitions. Together, we are Virgin Media O2, and we can't wait to see what you can do.
Accessible, inclusive and equitable for all
Virgin Media O2 is an equal opportunities employer and we're working hard to remove bias and barriers for our people and candidates. So, we build equity and inclusion into everything we do, from the policies we craft to the relationships we shape. We support and encourage you to be your authentic self throughout your application journey with us.
The must haves
- SQL expertise, including complex query writing, optimisation techniques, data modelling, and database performance tuning.
- Skilled in working with large datasets, building stored procedures, functions, and triggers, and implementing ETL processes.
- Have used products like Apache Airflow, DBT, Gitlab/Github, BigQuery.
- Demonstrable experience in Data Modelling including working with denormalised data structures, testing, asserts, and data cleansing.
The other stuff we are looking for
- Skilled in developing robust applications, scripts, and libraries.
What's in it for you
Our goal is to celebrate our people, their lives and everything in-between. We aim to create a culture that empowers everyone to bring the best versions of themselves to work each and every day. We believe the most inclusive and diverse culture makes for a better business and a brighter world. Working at Virgin Media O2, you get a bumper reward package bursting with benefits, and loads of extras you can add if you'd like to. These are designed to support both you and your loved ones, making sure that you're covered no matter what life throws your way.
Next steps
If we feel like a place where you can belong, we'd love to learn more about you as a person and your experience to date. Once you've submitted an application, the next steps of the process, if successful, are likely to include a three-stage interview process. When you apply, you'll be asked about any adjustments you might need to support the recruitment process. Let us know, and we'll be sure to discuss it with you.
Please note: Applications will be reviewed, and interviews conducted throughout the duration of this advert, therefore we may bring the closing date forward. We encourage all interested applicants to apply as soon as possible. If you're offered a job with us, it will be conditional, based on the passing of background checks. All roles require a criminal record check and some roles need a financial probity check. Your recruiter can provide you with more information if needed. Thanks for your patience and for showing an interest in joining the Virgin Media O2 family.
Senior Analytics Engineer employer: Virgin Media
Contact Detail:
Virgin Media 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. Since these are key technologies for the role, demonstrating your hands-on experience or knowledge during interviews can set you apart from other candidates.
β¨Tip Number 2
Brush up on your SQL skills, especially complex query writing and optimisation techniques. Be prepared to discuss specific examples of how you've improved database performance in past roles.
β¨Tip Number 3
Showcase your experience with data modelling and working with denormalised data structures. Prepare to explain your approach to testing and data cleansing, as this will be crucial for the role.
β¨Tip Number 4
Highlight any experience you have with tools like Apache Airflow and GitLab/GitHub. Being able to discuss how you've used these tools in previous projects will demonstrate your capability to work in a collaborative environment.
We think you need these skills to ace Senior Analytics Engineer
Some tips for your application π«‘
Tailor Your CV: Make sure your CV highlights your SQL expertise, experience with large datasets, and familiarity with tools like Apache Airflow and DBT. Use specific examples to demonstrate your skills in data modelling and ETL processes.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your background aligns with their values of inclusivity and diversity, and explain why you are excited about the opportunity to work with cutting-edge technology.
Showcase Relevant Projects: If you have worked on relevant projects, include them in your application. Describe your role, the technologies used, and the impact of your work. This will help demonstrate your practical experience and problem-solving abilities.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail and professionalism, which is crucial for a Senior Analytics Engineer role.
How to prepare for a job interview at Virgin Media
β¨Showcase Your SQL Skills
Be prepared to discuss your SQL expertise in detail. Bring examples of complex queries you've written, optimisation techniques you've employed, and how you've tackled performance tuning in the past.
β¨Demonstrate Data Modelling Experience
Highlight your experience with data modelling, especially with denormalised data structures. Be ready to explain your approach to testing, asserts, and data cleansing during the interview.
β¨Familiarity with Tools
Make sure you can talk about your experience with tools like Apache Airflow, DBT, and BigQuery. Discuss specific projects where you've used these technologies to build data models or ETL processes.
β¨Emphasise Collaboration Skills
Since you'll be working in a network environment, it's crucial to demonstrate your ability to collaborate with analysts and visualisation teams. Share examples of how you've helped others become self-sufficient in managing data infrastructure.