Operational Insights Analyst

The Operational Insights Analyst will play a central role within Sentric's Operational Insights team, sitting within the Revenue Optimisation Department. This role sits at the intersection of music data analysis and data architecture: you'll maintain data structures and conceive of pipelines and models that power reporting on Royalties and Rights, while also delivering analysis tools and insight that helps drive operational efficiency. You'll work closely with the Rights, Royalties and Insights teams as both a creator of trustworthy data foundations and a translator of that data into business decisions.
Key Responsibilities
• Support revenue assurance activities by tracing discrepancies back through both source data and transformation logic.
• Partner with the Royalties, Rights and Insights teams to translate business and audit questions into robust, reusable data structures rather than one-off queries.
• Assist in tracking and following up on audit outcomes and contribute to the development and refinement of revenue assurance frameworks and methodologies.
• Working alongside senior team members, contribute to the build and maintenance of 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, primary/foreign key relationships and referential integrity across datasets.
• Build and maintain ETL/ELT pipelines that move data from source systems and royalty statement feeds into Snowflake, via AWS S3 and Athena.
• Write and troubleshoot SQL and Python-based transformations to process royalty and usage datasets, developing a growing focus on performance and efficiency over time.
• Build, maintain and iterate on dashboards and reports (e.g. Power BI, Tableau or Looker) on top of curated, well-modelled data.
• Evaluate and pilot AI-assisted data tooling (e.g. AI-generated reports) to accelerate insight delivery where appropriate.
• Support engineering/product teams on upstream schema or system changes, by helping to investigate and flag downstream impact on data models and reporting.
• Present findings and recommendations clearly to both technical and non-technical stakeholders.
2 years' experience in an analytics engineering, data analyst, or database-adjacent role, ideally within music, media or entertainment.
Strong SQL skills, including joins, aggregations and window functions; some exposure to query optimisation and schema definition (DDL, dbt) is a plus.
Experience interacting with cloud data warehouses (e.g. Snowflake) and cloud storage/query services (e.g. AWS S3, Athena) with experience of ETL/ELT transformations and solid understanding of database design principles.
Familiarity with data visualisation tools such as Power BI, Tableau or Looker.
Some knowledge of Python (e.g. pandas, boto3, or the 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.
Certification relevant to the stack (e.g. Snowflake SnowPro Associate: Platform, AWS Certified Cloud Practitioner, or equivalent) is a plus, as is a portfolio of personal or academic projects involving SQL/Python, data modelling, or AI-assisted data tooling.
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 the analysis built on top of it.
A genuine interest in music rights, royalties or the wider entertainment industry.

Employment type
Full-time

Work arrangement
No