Operational Insights Analyst
Core
Maintain data structures, build pipelines and models for royalty and rights reporting, and deliver analysis tools to drive operational efficiency in music publishing.
Role type
Operational Insights Analyst (Data Engineering & Analysis)
Builds
Data models, ETL/ELT pipelines, and reporting dashboards for royalty and rights data.
Domain
Music Publishing / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL, Python, AWS, Snowflake, Power BI/Tableau/Looker, relational database design, ETL/ELT pipeline development, schema design
Preferred skills
C#, TypeScript, ReactJS, .NET, CWR standard, music publishing industry knowledge, AI-assisted development tools
Technologies
AWS, Snowflake, S3, Athena, Power BI, Tableau, Looker, C#, TypeScript, ReactJS, .NET
Responsibilities
Trace revenue discrepancies through source data and transformation logic; build and maintain ETL/ELT pipelines moving data to Snowflake; write and troubleshoot SQL and Python transformations; design schemas for reporting layers; build and iterate on dashboards; pilot AI-assisted data tooling; support engineering teams on upstream schema changes.
Seniority
Mid-level, hands-on IC