Principal Data Modeller
Share
Job Location:
Monthly Salary:
Posted on:
Vacancies:
Job Summary
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: depending on relevant skills knowledge and experience. The expected salary range for this role reflects internal benchmarking and external market insights.
Were happy to discuss flexible working. If youd like to please indicate your preference in the application though theres 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 teams 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.
Interview process
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 wed 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.
Required Experience:
Staff IC
Key Skills
- Business Development
- Classroom Experience
- Dayforce
- Go
- Cloud Computing
- AWS
- Teaching
- Administrative Experience
- Leadership Experience
- negotiation
- SAS
- Data Analysis Skills
About Company
The best of the BBC, with the latest news and sport headlines, weather, TV & radio highlights and much more from across the whole of BBC Online.
