SlipstreamJobs tracks this role from the company's public career site. Apply directly on the employer's site.
The Operational Insights Analyst will be a core member of Sentric's Operational Insights team within the Revenue Optimisation Department. This role bridges music data analysis and data architecture, maintaining data structures and designing pipelines and models that power reporting on royalties and rights. You will deliver analysis tools and insights that drive operational efficiency, working closely with Rights, Royalties, and Insights teams to build trustworthy data foundations and translate data into business decisions.
Key responsibilities include:
• Support revenue assurance by tracing discrepancies through source data and transformation logic
• Partner with Royalties, Rights, and Insights teams to translate business and audit questions into robust, reusable data structures rather than one-off queries
• Track and follow up on audit outcomes, contributing to the development of revenue assurance frameworks and methodologies
• Build and maintain data models and transformation pipelines that convert raw rights, royalty, and catalogue data into clean, analysis-ready tables in AWS and Snowflake
• Provide input on schema design for reporting layers, applying database normalisation principles and referential integrity
• Build and maintain ETL/ELT pipelines moving data from source systems and royalty statement feeds into Snowflake via AWS S3 and Athena
• Write and troubleshoot SQL and Python-based transformations for royalty and usage datasets, with growing focus on performance and efficiency
• Build, maintain, and iterate on dashboards and reports (Power BI, Tableau, Looker) on curated, well-modelled data
• Evaluate and pilot AI-assisted data tooling to accelerate insight delivery
• Support engineering/product teams on upstream schema or system changes by investigating downstream impact on data models and reporting
• Present findings and recommendations clearly to technical and non-technical stakeholders
Requirements:
• 2 years' experience in analytics engineering, data analyst, or database-adjacent role, ideally within music, media, or entertainment
• Strong SQL skills including joins, aggregations, and window functions; exposure to query optimisation and schema definition (DDL, dbt) is a plus
• Experience with cloud data warehouses (e.g., Snowflake) and cloud storage/query services (e.g., AWS S3, Athena); solid understanding of ETL/ELT transformations and database design principles
• Familiarity with data visualisation tools such as Power BI, Tableau, or Looker
• Some knowledge of Python (e.g., pandas, boto3, Snowflake connector) for scripting, automation, and pipeline development is a plus
• Comfort exploring and evaluating AI-assisted data tooling for reporting and analysis is a plus
• Relevant certifications (e.g., Snowflake SnowPro Associate: Platform, AWS Certified Cloud Practitioner) or portfolio of personal/academic projects involving SQL/Python, data modelling, or AI-assisted data tooling is a plus
• Strong communication skills, able to translate technical data structures and pipeline logic into clear business insight
• Highly organised with strong attention to detail, comfortable owning both data infrastructure and analysis built on top of it
• Genuine interest in music rights, royalties, or the wider entertainment industry
• Right to work in the UK
