Data Analytics Developer

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

Benefits:

• 💻 Great opportunity to work with leading data technologies and interesting datasets.
• 🌍 Work within a great team.

Qualifications:

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

Company:

peermusic

Location:

Richmond, United Kingdom