Principal Analytics Developer

The Principal Analytics Developer is a new role that will support the newly created Product Data Domain teams. The role requires strong skills in dimensionally modelling, conforming and integrating data from multiple sources, as well as experience in leading strong analytics engineering teams.
Responsibilities:
 

• Planning workloads and delegating tasks in agile environment
• Assisting with the daily operation of the organisation, including support and incidents
• Able to provide feedback to team members, including constructive areas for development
• 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 technology & Airflow.
• Using your expert knowledge of the company 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.

   

Requirements:
 

• Extensive (5+ years) experience in managing teams building data warehouses / analytics from a diverse set of data sources (including event streams, various forms of batch processing)
• At least 5 years’ experience in a Data Analyst, Data Modelling, Data Engineering or Analytics Engineering role, preferably in digital products, with an interest in data modelling and ETL processes
• Proven experience in dimensionally modelling complex data at the conceptual, logical and physical layer.
• Experience of designing STAR Schemas
• Excellent SQL skills for extracting and manipulating data. Experience of using tools such as DBT, Looker and Airflow would be an advantage.
• Good knowledge of analytical database systems (Redshift, Snowflake, BigQuery).
• Comfortable working alongside cross-functional teams interacting with Product Managers, Engineers, Data Scientists, and Analysts.
• Knowledge of digital products and their components, as well as what metrics affect their performance.
• An understanding of how digital products use experimentation.
• Some experience coding in R or Python.
• A good understanding of on-demand audio and video media products, with a knowledge of key competitors.
   

Will be a plus:

• Ability to listen to others’ ideas and build on them 
• Ability to clearly communicate to both technical and non-technical audiences.
• Ability to collaborate effectively, working alongside other team members towards the team’s goals, and enabling others to succeed, where possible.
• Ability to prioritise. A structured approach and ability to bring other on the journey. 
• Strong attention to detail