Overview

Peermusic Richmond Upon Thames, England, United Kingdompeermusic is the world’s largest independent music publishing and neighbouring rights administration company, operating from 39 offices in 31 countries. We publish or administrate millions of songs and recordings for thousands of clients around the globe, and we process billions of statement lines to make sure we collect and pay the royalties due to our clients.The Data Analytics Developer role sits within the Global Tech team, which develops and maintains the core business applications and websites used by peermusic’s operational staff - including the “Data Studio”, our cloud data lakehouse in Databricks which ingests data from a range of internal and external sources, and a range of business intelligence and analytics tools in Sigma Computing. The Data Analytics Developer role has responsibility for design, development, and maintenance of data pipelines in the Data Studio, and the design and development of reports and dashboards using Sigma Computing and other solutions.This role provides a great opportunity to work with some leading data technologies and interesting datasets within a great team.This job description sets out the main areas and duties for the role. However, the company is always evolving, and the role’s responsibilities and activities may develop and change over time.Peermusic is proud to be an equal opportunity workplace. Incoming applications are only evaluated for their professional qualifications, regardless of race, skin color, religion, gender, sexual identity, nationality, severe disability or age.Responsibilities

Design/develop/test/document data pipelines to integrate data from various sources into the data lake, and to transform data within the warehouse.Prepare automated tests to ensure that data pipelines are working as designed, and that data quality is as expected.Assist in the design and implementation data warehouse models and marts to structure data for analysis purposes.Assist in monitoring and troubleshooting the data lakehouse processes to ensure smooth operation and performance.Develop, test, and maintain Sigma reports and dashboards per user requests.Provide data extracts and basic analyses on an ad hoc basis for non-technical users.Collaborate with a globally-distributed team of developers, analysts, and power users to help peermusic get the most out of our data.Skills/Experience

Experience of working in data engineering or similar role, implementing data pipelines, integrations, or ETL/ELT between a variety of types of sources and targets.SQL: Ability to query and manipulate data in relational databases is critical.Python: Basic Python skills for data manipulation are required.Microsoft Office suite: A high degree of proficiency in Excel is essential, and proficiency in other Office tools is beneficial.Data Cleaning and Manipulation: Able to work with a variety of data formats (e.g. XML, JSON, CSV/TSV, etc.) to preprocess, clean, and transform raw data into usable formats for analysis.Experience in the music industry is a strong advantageDesign: Experience of architecting data lake and warehouse structures, and modelling data for analysis purposes.Data manipulation: Able to work with a variety of data formats (e.g. XML, JSON, CSV, Parquet, Avro, etc.) and perform basic analysis/manipulation.PySpark: Proficiency in PySpark for processing in a distributed environment is highly desirable.Large data sets: Experience of working with multi-million or billion-row datasets, and the associated challenges and best practices.Reporting/BI tools: Experience of using reporting/BI tools (e.g. Tableau, PowerBI, Sigma Computing, QlikView, etc.) to query data and prepare analytical reports is highly desirable.Technologies: Experience of Databricks is particularly beneficial, as is experience of Sigma Computing. Experience with Git and GitHub.Languages: In addition to English, any fluency in Spanish would be beneficial.Learner: curious about how the business process as well as the technology and the data, wants to be exposed to new challenges and learn new skills, likes to research and learn, likes sharing knowledge with others.Able to work independently.Detail-oriented; thorough and meticulous, ensures high-quality, gets to the bottom of a problem, pays attention to the small details.Reliable; does what they say they will, when they say they will.Customer-oriented; approachable, responsive, provides a great user experience.Location and Flexibility

Based from the peermusic London offices, in Richmond-upon-Thames. Flexibility for WFH 2 days/week, in coordination with other team members.How to Apply

Please send us your CV + cover letter to. We are looking forward to receiving your application!Seniority level

Entry levelEmployment type

Full-timeJob function

Information TechnologyIndustries

Music

#J-18808-Ljbffr