Principal Product Analytics Developer

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.

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.

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

Contract type: Permanent

Location: Salford or Newcastle