Job Band

Job Reference 18893

Band: D

Salary Range: £60,000-£71,000 depending on relevant skills, knowledge and experience. The expected salary range for this role reflects internal benchmarking and external market insights.

Contract type: Permanent

Location: Salford, Newcastle, Cardiff, Bristol, Birmingham, Edinburgh or Glasgow This is a hybrid role and the successful candidate will balance office working with home working

We’re happy to discuss flexible working. Please indicate your choice under the flexible working question in the application. There is no obligation to raise this at the application stage but if you wish to do so, you are welcome to. Flexible working will be part of the discussion at offer stage.

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.

You can find out more about working at the BBC by selecting this link to our candidate pack.

If you need to discuss adjustments or access requirements for the interview process please contact the k. For any general queries, please contact: k.

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 portfolio is diverse and contains some of the largest and highest-profile properties on the UK internet. We’re a huge streaming media destination, a news source trusted across the world, a provider of educational and entertaining content to children of all ages, and a sports results, analysis, and commentary service, and much more besides. It's an unparalleled portfolio of products, and our strength is our range and breadth. Working with the BBC’s content divisions, our focus now is on driving engagement across our portfolio so that the BBC online becomes a valued daily habit for all audiences just as television and radio have been over the last century.

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.

Main Responsibilities

The Principal Analytics Developer 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. Sitting between data engineering and data analysis you will get exposure to both areas across all product teams and 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 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.

You will work alongside other product analytics developers, product data managers, data engineers and data operations managers, ensuring that all work delivers maximum value to the BBC. You will be leading on cross-product strategic projects and using cutting-edge technologies, surrounded by like-minded people. This work will align with and help inform the short and long-term data strategy. This is an individual contributor role that, while it involves mentoring colleagues, will not involve line management responsibilities.

Role and responsibilities will comprise of:

• Leading on the design, implementation and maintenance of dimensional data models that promote a self-service approach to data consumption. This includes ensuring that data quality within the data warehouse is maintained throughout the data lifecycle.
• Define best practices in dimensional data modelling and database design and ensure standards are adhered to across the team.
• Mentoring, coaching and supporting other team members in developing data modelling skills through knowledge transfer.
• Automating data pipelines using proprietary BBC technology & Airflow.
• Using your expert knowledge of BBC products and their features to inform the design and development of data products and upskilling the team through this knowledge.
• Developing ways of working between product data domains and other data teams within product group.
• The creation of processes for data product development, ensuring these processes are documented and advocating their use throughout the organisation.
• Supporting analytics, data science and other colleagues outside the digital product area in managing projects and fielding queries.
• Ability to build and maintain strong working relationships where you might, as a specialist, have to manage the expectations of more senior colleagues.
• 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

When it comes to analytics developers at the BBC we look for these skills:

Technical Skills

• At least 5 years’ experience in a Data Analyst, Data Modelling, Data Engineering or Analytics Engineering role, preferably in digital products, with an interest in data modelling and ETL processes.
• Proven experience in dimensionally modelling complex data at the conceptual, logical and physical layer.
• Experience of designing STAR Schemas 
• Excellent SQL skills for extracting and manipulating data. Experience of using tools such as DBT, Looker and Airflow would be an advantage.
• Good knowledge of analytical database systems (Redshift, Snowflake, BigQuery).
• Comfortable working alongside cross-functional teams interacting with Product Managers, Engineers, Data Scientists, and Analysts.
• Knowledge of digital products and their components, as well as what metrics affect their performance.
• An understanding of how digital products use experimentation.
• Some experience coding in R or Python.
• A good understanding of on-demand audio and video media products, with a knowledge of key competitors.

Teamwork and stakeholder management
• Ability to listen to others’ ideas and build on them
• Ability to clearly communicate to both technical and non-technical audiences. 
• Ability to collaborate effectively, working alongside other team members towards the team’s goals, and enabling others to succeed, where possible. 
• Ability to prioritise. A structured approach and ability to bring other on the journey.
• 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. Priority consideration means for those employees seeking redeployment their application will be considered alongside anyone else at risk of redundancy, prior to any individuals being considered who are not at risk.

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 here.

Diversity matters at the BBC. We have a working environment where we value and respect every individual's unique contribution, enabling all of our employees to thrive and achieve their full potential.

We want to attract the broadest range of talented people to be part of the BBC – whether that’s to contribute to our programming or our wide range of non-production roles. The more diverse our workforce, the better able we are to respond to and reflect our audiences in all their diversity.

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. We will consider flexible working requests for all roles, unless operational requirements prevent otherwise.