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