Business Data Analyst – Level 1 (m/f/d)

About ICEICE is a music technology company built by rightsholders, for rightsholders. We simplify the complexities of the music royalty chain through an innovative suite of licensing, processing, and copyright services, enabling our customers to accurately and efficiently compensate songwriters and composers for the use of their works.Serving over 330,000 rightsholders and leveraging a copyright database comprising 55 million musical works, ICE’s operations touch 250+ territories to distribute more than €1bn in royalties per year, with a total of over €5bn distributed to date.About The RoleAs ICE is transforming from a successful service company to a technology company, we are looking for a highly motivated data analyst to be part of the Data and Analytics team within the Product Operations department.With ICE having successfully launched a new Copyright platform, the Data and Analytics team is at the forefront of providing valuable and actionable insights for our customers and internal stakeholders. As a member of the team you will be responsible for building and maintaining dashboards and reports, as well as providing automated reporting solutions and on demand ad-hoc analysis on a daily basis. You will learn about the ICE business and the complexities of copyright data management and work across a range of operational and technical areas.Key Responsibilities:Data extraction based on customer and internal requestsApply best practices to analytics code (ex: version control, testing, continuous integration)Developing and improving documentation on ICE’s data modelsData analysis to support operational & strategic decision-makingDashboard development to support customer & internal reportingTrain business users on how to use data visualisation tools and other solutionsWorking with Engineering to develop automated data pipelines for recurring requestsRequirements and Qualifications:Work experience or domain knowledge regarding music copyright / online royalty admin services.An understanding of ICE’s databases and their functions.Strong proficiency in SQL and experience with data modelling concepts and techniques.Strong proficiency in Python.Hands-on experience with Snowflake data warehouse.Experience with version control systems, such as Github.Strong analytical and problem-solving skills, with the ability to analyze complex data scenarios and provide effective solutions.Experience with the creation of reporting and its corresponding tools, e.g. Tableau, Looker, PowerBI, and Quicksight.Familiarity with cloud-based data platforms (e.g., AWS, Azure, Google Cloud) is a plus.Experience with DBT (Data Build Tool) and it's ecosystem is a plus.What we offer:Competitive local benefits based on your locationWe promote flexible working regarding time and/or placeBoth mental and physical health initiativesCorporate pension scheme Comprehensive training and development opportunities Industry insider events, team socials and company eventsEnhanced holiday allowance We welcome candidates from all backgrounds, regardless of age, disability, gender, gender identity, gender expression, race, religion or belief, sexual orientation, socioeconomic background, and any other protected characteristic.We are committed to making all stages of our recruitment process accessible to candidates with disabilities. Please speak to our recruitment team and we will work with you to make reasonable adjustments to ensure you can perform at your best throughout your application.