Operational Insights Analyst
- Location
- Liverpool, England, United Kingdom
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 … 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 ...