Schedule Design Analyst – HYBRID

Job Overview

logoData 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 position:
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 team:
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.· 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.
To be successful in this position, you also need to be:
• 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.
If you are interested in joining the peermusic family, please send your CV and cover letter to european.hr@peermusic.com.
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.

Job Detail
Shortlist Never pay anyone for job application test or interview.

Related Jobs (1925)

Safety Information

  • Tips For Candidate

    DYOR.

  • Tips For Candidate

    Check the employer\'s offer before apply.