The Job
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.