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.
We're Looking for Someone With
Proven product engineering experience, ideally including C#, TypeScript, ReactJS, or similar
A solid understanding of relational databases and cloud platforms (AWS)
Hands-on experience with, or genuine curiosity about, AI-assisted development and agentic coding tools
Excellent communication and collaboration skills
A pragmatic, principled approach to quality and continuous improvement
Bonus Points
Experience running .NET applications in AWS
Experience with the CWR standard
Familiarity with the music publishing industry
Experience establishing or contributing to team practices around AI-assisted engineering (tooling choices, review standards, responsible use)
Requirements
Right to work in the UK
Ability to work on-site at the Liverpool office (hybrid role)

Employment type
Full-time

Work arrangement
No