Data Engineer

PRS for Music; London; On-site; GBP 45,000 - 65,000; Full time

Job summary

PRS for Music is seeking a Data Engineer to join our Data Engineering Team, focusing on developing analytics assets across Azure Synapse Analytics, SQL Server, and Oracle. The role involves collaborating with data engineers to support solutions used by analysts and various business functions. Responsibilities include creating ETL/ELT data pipelines, migrating legacy applications, and ensuring the effective delivery of data visualizations. We value diversity and expect applicants to bring their individuality to work, showcasing various experiences and skills.

Benefits

25 days holiday entitlement

Work from anywhere for up to two months a year

Enhanced maternity and paternity leave

Retail and gym discounts

Qualifications

• Experience with Data Analytics and Data Science is essential.
• Familiarity with Cloud Platforms for building and migrating data engineering workloads is beneficial.

Responsibilities

• Develop, build and test cloud hosted ETL/ELT data pipelines from various data sources.
• Monitor and support legacy applications and assist in their migration to a modern stack.
• Collaborate with other Data Engineers to enhance skills and technical capabilities.
• Assist in establishing a modern data culture across the organization.
• Build and support delivery of data visualization products.
• Manage development tasks using Jira.

Skills

Data Engineering Background

Experience in Data Analytics

Experience with Microsoft Azure Synapse Analytics

Experience with SQL Server Analysis Services

Oracle Database and PL/SQL Packages

Tools

Microsoft Azure

Oracle

Jira

Job description

Overview

Music wouldn't exist without the work of songwriters, composers and publishers. We're here to represent them and make sure that they are paid for their work. After more than a century in the industry, we continue to innovate as a world-leading organisation.

We are seeking a Data Engineer working with our Data Engineering Team to provide development capability for analytics assets across Azure Synapse Analytics (Azure SQL Data Warehouse), SQL Server and Oracle OCI.

You will also work closely with other data engineers within the team to support and develop existing solutions utilise by the Data Analysts, Data Product Owners, Data Scientist and various business functions to support PRS's ambitious growth plans and 160K members.

Data Engineering development collaborate with all CIO Teams and business functions to ensure our core systems and applications work as expected.

The team cover all parts of the software development life-cycle performing analysis, design, development and testing for our projects and programmes as well as providing third line support and delivering Business As Usual (BAU) enhancements.

The core systems looked after by the team support the processing of the usage of our members rights from many platforms where music is used, including from our joint ventures, through to our member distributions. The financial aspects behind the processing, including forecasting future financial activity, are also supported. All of which is the heartbeat of PRS.

We employ a wide range of skills within the team, manage several technologies centred on Oracle and Microsoft bespoke and commercial applications. The ethos of the team is to support, innovate and collaborate, enabling us to deliver the best service to our customers.

Responsibilities

As our Data Engineer, some of your day-to-day duties will include

• Develop, build and test cloud hosted ETL/ELT data pipelines from a variety of data sources to make data accurate and easy to use.
• Monitor and support legacy applications and help to progressively migrate them to a more modern stack on cloud infrastructure.
• Proactively collaborate with Data Engineers to enhance technical skill sets particularly with an initial focus on Microsoft technologies extending out towards Oracle.
• Assist with the establishment of a modern data culture across the organisation
• Build and support delivery of data visualisation products.
• Implement and manage development tasks using Jira

About you

At PRS for Music, we want you to bring the best version of yourself to work. We believe that celebrating individuality promotes a culture of acceptance and openness. Along with being whoever you want to be, in an ideal world you will also have:

ESSENTIAL

• Data Engineering Background.
• Experience in Data Analytics and Data Science.
• Experience with Microsoft Azure Synapse Analytics.
• Experience with SQL Server Analysis Services (SSAS) - Tabular and OLAP Models.
• Oracle Database and PL/SQL Packages.

DESIRABLE

• Beneficial: experience with Cloud Platforms for building and migrating data engineering workloads (Azure, OCI, AWS, GCP)
• Experience with SQL Server Integration Services (SSIS)
• Hands on experience of Jira
• Knowledge and/or experience of machine learning/AI
• Excellent Excel skills.

We know that the world isn't always ideal, so please don't rule yourself out if you have other qualities to bring to the party.

What's in it for you?

Here are just a few things that set PRS for Music apart from the crowd:

• We trust, value, and support our people to make the difference
• We believe that diversity of thought and experience provides the platform for innovation and creativity
• We are consciously inclusive and have eight Affinity Groups which you can join and make an impact
• We invest in the development of our people to drive our ambitions forward
• We offer a range of family friendly leave including enhanced maternity and paternity, grandparent, fertility, reproductive and menopause support.
• We know time to rest and recharge is important which is why we offer 25 days holiday entitlement with the option to top up twice annually up to a maximum of 30 days
• Employees can work from anywhere in the world for up to two months of the year
• Plus a whole range of other benefits, including retail discounts, gym discounts, season ticket or bicycle loan.

The Process
Our interview process for this role is simple:

• First stage interview will take place virtually on MS Teams.
• Second stage interview will take place in person at our London Bridge Hub.

We use competency-based questions within our interviews. This allows you to provide examples of situations where you have had to demonstrate the required skills relevant to the role you are applying for. To assist your preparation for interview, research the STAR method to aid bringing your examples to life.

Location

We offer a hybrid working model, allowing employees to work from home up to three days a week.

To ensure the health and safety of all our employees, if you wish to work from home for more than 2.5 days per week, we will conduct a quick and easy remote-working assessment.

If you sound like you could be the right person for the job, apply now.

At PRS we are committed to equity, diversity, inclusion and belonging for all. We have taken a holistic approach to ensure that no one feels excluded regardless of age, class, sexuality, gender, race, religion, or ability. We value the needs of everyone in our organisation and strive to build an environment where our employee's contributions are recognised in order that everyone may thrive.