Data Architect

Music is Universal

It’s the passionate and dedicated team at Universal Music who help make us the world’s leading music company. From A&R to finance, legal to digital, sales to marketing, Universal Music is the place to grow and develop your career within a truly commercial and innovative business that leads in everything it does.

Everyone is welcome to apply for our roles, and we are determined to ensure that no applicant or employee receives less favourable treatment because of gender, race, disability, sexual orientation, religion, belief, age, marital status, background, pregnancy, or caring responsibilities. We also recognise the importance of diversity of thought within our teams and are fully committed to embracing the talents of people with autism, dyslexia, ADHD, and other forms of neurocognitive variation.

We will always seek to make appropriate adjustments to recruitment, workplaces, and work processes to be fully inclusive to people with different needs and working styles. If you need us to make any reasonable adjustments for you from application onwards, including alternatives to the online form or to disclose a neurocognitive condition, please email UniversalMusicCareers@umusic.com.

Department Description

With a global footprint, the Universal Music Group Royalty and Copyright Product Team designs, develops, delivers and maintains a number of technical solutions to calculate royalty accountings in a timely and accurate manner to our valued artists. We’re also providing them with an extent and detailed visibility of these earning from various sources of digital incomes.

The team continuously collaborates with our international business teams to deliver innovative solutions as well as supporting best practices and new processes for a better royalty flow.

The Role

The Data Architect will lead the design and evolution of our Royalties and Copyright data models and processes. This role is responsible for defining and driving the data architectural strategy, ensuring the scalability and performance of our systems. As a senior technical leader, you will collaborate with executives, engineering teams, and stakeholders to deliver solutions that align with business goals and industry best practices.

Key Responsibilities

Be innovative

• Developing data management projects which will move UMG closer to its future goals.

• Designing a data infrastructure that supports complex data analytics services.

• Oversee system performance, reliability and compliance considerations.

• Form up the solution and ensure that it is delivered to the development team in an appropriate form.

Be a leader

• Lead the design and implementation of enterprise data architecture on AWS

• Providing technical leadership and direction for the Royalty data teams.

• Provide technical mentorship to senior engineers across the organization.

• Build positive relationships with business stakeholders and development teams.

• Document and agree requirements to form a strategic roadmap.

• Orchestrate development by leading a data analyst team.

• Establish and enforce data architectural guidelines.

• Strong leadership, communication, and interpersonal skills, with the ability to influence and engage stakeholders at all levels.

• Identify opportunities for process optimization, automation, and innovation across our landscape.

Be Collaborative

• Collaborate with business units to gather and analyse requirements and translate them into functional and technical solutions.

Skills and Experience required

Must have

• A proven track record to use data modelling techniques such as entity-relationship diagrams, dimensional modelling, and schema design to represent data structures and relationships in a logical and conceptual way.

• Knowledge of database management systems like MySQL, PostgreSQL, cloud-based databases to store, query, and manipulate data in a structured and consistent way.

• Strong hands-on experience with AWS Cloud services:

• Amazon RDS / Aurora

• IAM for data security

• Amazon S3

• AWS Glue

• Step Functions

• AWS Lambda

• Advanced SQL skills and proficiency in Python or Scala

• Experience in large data migration project where data is moved, transformed and consolidated from different sources and formats.

• Ability to set standards for data quality tools usage such as data profiling, data cleansing, data validation, and data auditing which will be essential to ensure data is accurate, complete, consistent, and relevant.

• Ability to implement data governance tools like data catalogs, dictionaries, lineages, and policies required to define and enforce the rules for managing the data lifecycle and usage.

• Deep understanding of data governance, privacy, and regulatory compliance

• Self-starter, business focussed leader with strong initiative

• Strong leadership, communication, and interpersonal skills, with the ability to influence and engage stakeholders at all levels

Nice to have

• Music industry business knowledge is highly desirable.

• Experience migrating data from legacy systems, specifically IMB AS400 / DB2 environments, to modern cloud platforms (preferably AWS)

Just So You Know…

The company presents this job description as a guide to the major areas and duties for which the jobholder is accountable. However, the business operates in an environment that demands change and the jobholder’s specific responsibilities and activities will vary and develop. Therefore, the job description should be seen as indicative and not as a permanent, definitive, and exhaustive statement.

Job Category:

Royalties & Copyright