Principal Data Modeller

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 and data engineers to ensure 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 mentoring colleagues, will not involve line management responsibilities.

Interview Process

• Virtual interview - approximately one hour of values based questions
• Take home exercise
• Virtual interview - approximately 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 the 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.
• Update 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.
• Mentor, coach 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 of 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 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, with a structured approach and the ability to bring others 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.