Senior Data Analyst

Job Band
Band: D
Contract type: 18 months Fixed Term Contract, ideally starting March 2024
Location: Hybrid working from any BBC UK office - London or Glasgow preferred
Salary: £50,000 - £55,000 per annum depending on relevant skills, knowledge and experience. The expected salary range for this role reflects internal benchmarking and external market insights.
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.
Job Purpose
Archives Technology & Services is responsible for managing the BBC's vast and varied content catalogue, with a hundred years of heritage and hundreds of hours of new content every day. We build and operate systems and services to store and manage one of the world's largest media archives, and to make it easy to find and reuse our content in new programmes. We have great people, world class content and cutting edge technology.
Join us in the challenge of unlocking the BBC's incredible 100 year Public Service archive of metadata and media for generations to come!
Key Responsibilities
We are currently building out a next generation, Public Service Data Platform to provide seamless access to the BBC's large archive of programme information, metadata, subtitles, transcripts, production data and restrictions. Up until now, this metadata has been stored in a large number of separate, siloed systems, tightly coupled to their respective business use cases. You'll be working with software engineers building this platform, and will contribute to analysis, ETL/ELT process and reporting to support it.
The right candidate will have a keen interest in data process design, ETL development, data exploration and analysis, and visualisation. The data team is key to helping design and implement key processes that support archive operations. An interest in BBC material and archives will help - our data describes the BBC's output through time, and our job is to help manage and get value from the archives.
Are you the right candidate?
This is an exciting opportunity to be a part of one of the world great media archives at a time when we are aiming to transform our platform and operations. The ideal candidate will bring solid analysis and exploration skills, with an interest in developing their skills for process design, scripting and ETL workflows. It's an ideal opportunity to gain skills and experiences for a motivated individual.
To be successful in this role you will need to experience in:

• SQL
• Light ETL development (e.g. using GUI)
• Experience with working on wide range of complex data sets and formats.
• Experience with cloud hosted environments (AWS)
• Ability to present data to wide range of audiences
• Entity-Relationship data modelling experience
• Passion for data and a familiarity with data management best practice

It would also be beneficial to have:

• Python or other scripting experience. Familiarity with regular expression
• More complex ETL development. Data process design
• Experience with media metadata
• Experience of working with a multidiscipline team of analysts, engineers and product leads. Experience of Agile working
• Data visualisation experience (e.g. Tableau)
• Data modelling for other db type

Interview process
Interviews will be held week commencing 18th March.
Interview process:
Technical task for shortlisted candidates - approx. 30 minutes
Virtual interview - approx. one hour of technical and values-based questions
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 in the document attached below.
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.