You will need to login before you can apply for a job.
Principal Analytics Team Lead, Newcastle
Job Band
Job number 20622
Job Band: D
Starting salary: up to 71,500 depending on relevant skills, knowledge and experience. The expected salary range for this role reflects internal benchmarking and external market insights.
Contract Type: Continuing
Location: Newcastle
Excellent career progression - the BBC offers great opportunities for employees to seek new challenges and work in different areas of the organisation.
Unrivalled training and development opportunities - our in-house Academy hosts a wide range of internal and external courses and certification.
Benefits - We offer a negotiable salary package, a flexible 35-hour working week for work-life balance and 25 days annual leave with the option to buy an extra 5 days, a defined pension scheme and discounted dental, health care and gym.
Interview Process
This is a 2-stage interview process. Both are virtual for shortlisted candidates; the first is a 30-min technical interview based on your experience, the second is a 1-hour interview focusing on a take home exercise, competency, and values-based questions. Interviews will begin the week commencing 3rd February 2025.
Introduction
Product Group is responsible for the design, development, and delivery of the BBC's portfolio of digital products, including iPlayer, Sounds, Bitesize, and the BBC News and BBC Sport apps and website. Our focus now is on driving engagement across our portfolio so that the BBC online becomes a valued daily habit for all audiences.
Data is fundamental to our future: both in helping us prioritise and shape our work and in creating richer, more personalised experiences for our audiences. And our portfolio means that we've got one of the widest, most diverse, and most exciting datasets to work within the UK.
Key Responsibilities
The Principal Analytics Team lead is a new role that will support the newly created Product Data Domain teams. Working as part of our multi-disciplinary data teams, you will lead on the creation of clean, tested, well-modelled trusted datasets around our digital estate for use across the BBC, including managing a team focused on collecting data. Sitting between data engineering and data analysis, you will focus on modelling unstructured data into meaningful insights. You will be building and maintaining data pipelines through best practices to support teams across the BBC in delivering quality products and content.
You will be leading on work to break down business requirements, designing the dimensional data models and build ETL pipelines using SQL to deliver data products that will power key value use cases across the BBC. The role requires strong skills in dimensionally modelling, conforming and integrating data from multiple sources, as well as experience in leading strong analytics engineering teams.
Role and responsibilities will comprise of:
1. Planning workloads and delegating tasks in an agile environment.
2. Assisting with the daily operation of the organisation, including support and incidents.
3. Providing feedback to team members, including constructive areas for development.
4. Leading on the design, implementation and maintenance of dimensional data models that promote a self-service approach to data consumption.
5. Defining best practices in dimensional data modelling and database design.
6. Mentoring, coaching and supporting other team members in developing data modelling skills through knowledge transfer.
7. Automating data pipelines using proprietary BBC technology & Airflow.
8. Using your expert knowledge of BBC products to inform the design and development of data products.
9. Developing ways of working between product data domains and other data teams within product group.
10. The creation of processes for data product development, ensuring these processes are documented and advocated throughout the organisation.
11. Supporting analytics, data science and other colleagues in managing projects and fielding queries.
12. Building and maintaining strong working relationships with senior colleagues.
13. Working across mobile, web, television and voice platforms supporting Product Managers, Business Analysts and working closely with Software & Data Engineers.
Are you the right candidate?
Technical Skills
1. At least 5 years' experience in a Data Analyst, Data Modelling, Data Engineering or Analytics Engineering role.
2. At least 5 years experience in managing teams building data warehouses / analytics from diverse data sources.
3. Proven experience in dimensionally modelling complex data at the conceptual, logical and physical layer.
4. Experience of designing STAR Schemas.
5. Excellent SQL skills for extracting and manipulating data.
6. Good knowledge of analytical database systems (Redshift, Snowflake, BigQuery).
7. Comfortable working alongside cross-functional teams.
8. Knowledge of digital products and their performance metrics.
9. An understanding of how digital products use experimentation.
10. Some experience coding in R or Python.
11. A good understanding of on-demand audio and video media products.
Teamwork and stakeholder management
1. Ability to listen to others' ideas and build on them.
2. Ability to communicate clearly to both technical and non-technical audiences.
3. Ability to collaborate effectively, enabling others to succeed.
4. Ability to prioritise and bring others on the journey.
5. Strong attention to detail.
About the BBC
The BBC is committed to redeploying employees seeking suitable alternative employment within the BBC for different reasons and they will be given priority consideration ahead of other applicants. We don't focus simply on what we do - we also care how we do it. Our values and the way we behave are important to us. Please make sure you've read about our values and behaviours. Diversity matters at the BBC. We have a working environment where we value and respect every individual's unique contribution. We want to attract the broadest range of talented people to be part of the BBC. We are committed to equality of opportunity and welcome applications from individuals, regardless of age, gender, ethnicity, disability, sexual orientation, gender identity, socio-economic background, religion and/or belief. #J-18808-Ljbffr