Data Analytics Developer

Peermusic Neighbouring Rights; London; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A leading music rights organization is seeking a Data Analytics Developer to work in their London office. The role involves designing and developing data pipelines, creating reports and dashboards, and collaborating with a global team. Candidates should have strong skills in SQL and data engineering, with preferred experience in the music industry and proficiency in tools like Sigma Computing and Databricks. This position offers flexibility for remote work two days a week.

Qualifications

• Experience of working in data engineering or similar role.
• Ability to query and manipulate data in relational databases.
• Basic Python skills for data manipulation.
• Proficiency in Excel and other Office tools.
• Experience in the music industry is advantageous.
• Experience in architecting data lake and warehouse structures.

Responsibilities

• Design and develop data pipelines for data integration.
• Prepare automated tests for data quality.
• Assist in designing data warehouse models.
• Monitor and troubleshoot data lake processes.
• Develop and maintain Sigma reports and dashboards.

Skills

Data engineering

SQL

Python

Excel

Data Cleaning

Data manipulation

Reporting tools

PySpark

Customer-oriented

Detail-oriented

Tools

Databricks

Tableau

PowerBI

Sigma Computing

Git

Job description

Overview

Peermusic Richmond Upon Thames, England, United Kingdom

Data Analytics Developer role within the Global Tech team. The role involves design, development, and maintenance of data pipelines in the Data Studio, and design and development of reports and dashboards using Sigma Computing and other solutions. The Data Analytics Developer will work with data technologies and datasets within a collaborative 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.

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 of 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 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: Proficiency in Excel is essential; proficiency in other Office tools is beneficial.
• Data Cleaning and Manipulation: Able to work with data formats (e.g. XML, JSON, CSV/TSV) to preprocess, clean, and transform raw data into usable formats for analysis.
• Experience in the music industry is a strong advantage.
• Design: Experience of architecting data lake and warehouse structures and modelling data for analysis.
• Data manipulation: Ability to work with data formats (e.g. XML, JSON, CSV, Parquet, Avro) and perform basic analysis.
• PySpark: Proficiency for processing in a distributed environment is highly desirable.
• Large data sets: Experience with multi-million or billion-row datasets and related challenges.
• Reporting/BI tools: Experience with tools such as Tableau, PowerBI, Sigma Computing, QlikView to query data and prepare analytical reports is desirable.
• Technologies: Experience with Databricks is beneficial, as is experience with Sigma Computing. Experience with Git and GitHub.
• Linguistic: Any fluency in Spanish would be beneficial.
• Learner; curious about business processes, technology and data; enjoys researching, learning, and sharing knowledge.
• Able to work independently.
• Detail-oriented; thorough and meticulous, ensures high quality and thorough problem solving.
• Reliable; meets commitments as promised.
• Customer-oriented; approachable, responsive, provides a great user experience.

Location / Flexibility

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

Application

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

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.