Principal Data Modeller

Glasgow, GBR, G511DA
London, GBR, W1A 1AA
Newcastle-upon-Tyne, GBR, NE991RN
Salford, GBR, M50 2QH

JOB DETAILS

JOB BAND: D
CONTRACT TYPE: Permanent, Full-time
DEPARTMENT: BBC Product Group
LOCATION: Hybrid, with base option of
• Newcastle - Broadcasting Centre
• Glasgow - Pacific Quay
• Salford - Quay House
• London - Broadcasting House
PROPOSED SALARY RANGE: £65,000-£74,250 depending on relevant skills, knowledge and experience. The expected salary range for this role reflects internal benchmarking and external market insights.

We're happy to discuss flexible working. If you'd like to, please indicate your preference in the application - though there's no obligation to do so now. Flexible working will be part of the discussion at offer stage.

PURPOSE OF THE ROLE

The Principal Data Modeler role supports how data is used across the BBC. Sitting in the Product Data Domains team you will be modelling data used by products throughout the organisation. The team's focus is developing highly governed, trusted datasets in the data warehouse that act as a single source of truth. You will be part of an agile team alongside product data managers, analytics engineers, data engineers to ensuring maximum value to the BBC.

WHY JOIN THE TEAM

You will be working on cross-product strategic projects and 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 does involve the mentoring of colleagues, will not involve line management responsibilities.

• Virtual interview - approx. one hour of values-based questions
• Take home exercise
• Virtual interview - approx. one hour of technical proficiency and questions relating to the exercise

YOUR KEY RESPONSIBILITIES AND IMPACT

• Lead the development of analytical data models at the conceptual, logical and physical level that reflects the business processes within product group.
• Work closely with the Analytics Engineers and Product Data Managers that implement the data models in the Data Warehouse.
• Define best practices in data modelling and database design and ensure standards are adhered to across the team.
• Updating existing models to enhance the efficiency and performance of data delivery.
• Collaborate and gather requirements from a wide variety of stakeholders and effectively communicate how your models support their business needs.
• Build and maintain strong working relationships where you might, as a specialist, have to manage the expectations of more senior colleagues.
• Mentoring, coaching and support other team members in developing data modelling skills through knowledge transfer.

YOUR SKILLS AND EXPERIENCE

ESSENTIAL CRITERIA:

• Deep understanding of data modelling techniques, including dimensional STAR and snowflake schemas, ideally also entity relationship modelling and/or data vault
• Excellent SQL skills for extracting and manipulating data
• Strong understanding of data warehousing concepts and database technologies
• Excellent communication skills, with demonstrable experience in presenting to both technical and non-technical audiences.
• Understanding data quality frameworks and how they apply to building data warehouses

DESIRED BUT NOT REQUIRED:

Technical Skills

• Strong analytical and problem-solving skills, with the ability to architect scalable and efficient data solutions.
• Comfortable working alongside cross-functional teams interacting with product managers, analytics engineers, data scientists, and data analysts.
• A good understanding of on-demand audio and video media products, with a knowledge of key competitors.
• Knowledge of data ingestion patterns and methods

Teamwork and stakeholder management

• Ability to listen to others' ideas and build on them
• Ability to prioritise. A structured approach and ability to bring other on the journey.
• Strong attention to detail

If you can bring some of these skills and experiences, along with transferable strengths, we'd love to hear from you and encourage you to apply.

Before your start date, you may need to disclose any unspent convictions or police charges, in line with our Contracts of Employment policy. This allows us to discuss any support you may need and assess any risks. Failure to disclose may result in the withdrawal of your offer.

Disclaimer

This job description is a written statement of the essential characteristics of the job, with its principal accountabilities, incorporating a note of the skills, knowledge and experience required for a satisfactory level of performance. This is not intended to be a complete, detailed account of all aspects of the duties involved.

Please note: If you were to be offered this role, the BBC will conduct Employment screening checks which include Reference checks; Eligibility to work checks; and if applicable to the role, Safeguarding and Adverse media/Social media checks. Any offer made is conditional on these checks being satisfactory.

The BBC is committed to redeploying employees seeking suitable alternative employment within the BBC 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.

Information at a Glance This is your BBC

At the BBC you can create and innovate in an inclusive environment while contributing to some of the world's best loved content, and the BBC's mission to inform, educate and entertain.

Find out more about the BBC Life at BBC

• Fair pay and flexible benefits including a competitive salary package, a flexible 35-hour working week, 25 days annual leave with the option to buy an extra 5 days, a defined pension scheme and discounted dental, health care and gym.
• Excellent career and professional development.
• Support in your working life, including flexible working which you can discuss with us at any point during the application, selection or offer.
• A values-based organisation where the way we do things is important as what we do.

Benefits may vary if you are joining on an FTC basis.

Learn more about life at the BBC and our values in our candidate pack.

Candidate pack You belong

We have a working environment where we value and respect every individual's unique contribution, so all our employees feel that they can belong, thrive and achieve their full potential.

We want to attract the broadest range of talented people to join us. The more diverse our workforce, the better able we are to respond to and reflect our audiences in all their diversity.

We welcome applications from individuals, regardless of age, gender, ethnicity, disability, sexual orientation, gender identity, socio-economic background, religion and/or belief.

Find out more about diversity, inclusion and belonging in our strategy below.

Disability confident

We are a disability confident employer. If you need to discuss adjustments or access requirements for the interview process, or to carry out this role, please contact us via email and we'd be happy to discuss:

BBC Group and Public Services, Broadcasting House, Portland Place, London, United Kingdom, W1A 1AA. BBC Studios Distribution Limited, company no: , registered address: 1 Television Centre, 101 Wood Lane, London, United Kingdom W12 7FA.