Data Analytics Developer

Data Analytics Developer

Reports to: Data Analytics Manager

Who we are:

peermusic 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.

Your responsibilities:

1)Design/develop/test/document data pipelines to integrate data from various sources into the data lake, and to transform data within the warehouse.

2)Prepare automated tests to ensure that data pipelines are working as designed, and that data quality is as expected.

3)Assist in the design and implementation data warehouse models and marts to structure data for analysis purposes.

4)Assist in monitoring and troubleshooting the data lakehouse processes to ensure smooth operation and performance.

5)Develop, test, and maintain Sigma reports and dashboards per user requests.

6)Provide data extracts and basic analyses on an ad hoc basis for non-technical users.

7)Collaborate with a globally-distributed team of developers, analysts, and power users to help peermusic get the most out of our data.

What you bring to the position:

Essential:

•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.

•Software development background or experience are required.

•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.

Desirable:

•Design: 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.

•Music industry: Knowledge and experience of the music industry, in particular the publishing sector, is desirable but not essential.

•Languages: In addition to English, any fluency in Spanish would be beneficial.

Who you are:

• A 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.

•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/Flexibility

•Based from the peermusic London offices, in Richmond-on-Thames.

•Flexibility for WFH 2 days/week, in coordination with other team members.

Job Type: Full-time

Pay: £29,259.23-£78,607.75 per year

Benefits:

• Cycle to work scheme
• Work from home

Work Location: Hybrid remote in Richmond TW9 1HY