Salarioo

Job Band

Job Reference 18893

Band: D

Salary Range: £55,000-£71,000 dependent on skills, knowledge and experience

Contract type: Permanent

Location: Salford or Newcastle

Our comprehensive benefits package includes:

•    An employer pension contribution of up to 10%

•    26 days’ annual leave (based on full time hours) + bank holidays and the option to buy/sell additional days

•    Contributory lifestyle benefit options including discounts at hundreds of retailers, cycle to work scheme, discounted gym memberships and healthcare schemes

•    Employee assistance and well-being programmes

•    Learning and development tailored to your role – this could include industry recognised qualifications, coaching and mentoring

•    An inclusive and diverse environment with opportunities to join staff networks including: Women’s Network, National Disability Networks and many more.

Family friendly flexible working arrangements, such as hybrid working, job sharing, flexi-time and compressed hours can be requested.

We welcome candidates from all backgrounds and especially welcome individuals from underrepresented groups.

If you require any reasonable adjustments at any time, please let us know by contacting us on Reasonable.adjustments@bbc.co.uk with the job reference in the subject.

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.

To find out more about Diversity and Inclusion at the BBC, please click here.