Data Analyst, Royalties
- New York, NY
- Employees can work remotely
TIDAL is a global music and entertainment streaming platform committed to creating a deeper connection between artists and fans through its library of more than 70 million songs, over 250,000 high quality videos, and available in over 60 countries. In addition, TIDAL offers its subscribers exclusive access to high-profile music and music videos, original content series, podcasts, documentaries, livestream concerts, tickets, merchandise and live experiences. Together, TIDAL and Square will be music-obsessed and artist-focused while we explore new artist tools, listener experiences, and access to financial systems that help artists be successful.
We are looking for a Data Analyst, Royalties who will ensure our royalties calculations and reports are accurate and aligned with all contractual obligations and internal policies. You will work with multiple teams (engineering, accounting, business affairs and BI teams) to establish requirements and support the development, automation and delivery of customized reports.
You will join the Royalty Reporting team that builds and tailors the processes that take large datasets from across our platform, to calculate the royalties due to Music Rights Holders and report on both the royalties and on wider datasets that we share with our stakeholders.
You have experience with large datasets (terabyte scale) and querying databases to create ad-hoc data analysis. You will have experience with database structures, and proficient in both SQL and Excel (can perform complex functions) with experience using ETL tools in a microservice architecture.
Support the monthly and quarterly Royalties reporting process, ensure the accurate delivery of reports to stakeholders, perform analysis of deliverables, and conduct quality review
Provide ad-hoc support for multiple teams (Accounting, Legal, Licensing, etc.) as well as external music labels and rights holders that require data analysis
Work with our technical engineers to help develop our Royalties system and process enhancements to perform royalties calculations, product configuration and reporting
Create and maintain operational dashboards to analyze royalties related trends
Create scripts to automate workflows and remove repetitive tasks and monitor data integrity to ensure high level of accuracy
Evaluate information gathered from multiple sources, reconcile and resolve conflicts, decompose high-level information into details, and validate deliverables
- Bachelor's degree in relevant field with strong academic performance
4+ years of using databases, analytical tools, and writing complex SQL queries to solve problems
2+ years of experience with data visualizations and dashboard creation that can help guide decisions
Proficient in working with system applications, data modeling, database schemas, workflow and validation rules, backend data tables, formula fields, reports & dashboards
High Familiarity with data platforms such as Redshift, Tableau, Databricks, and Airflow
Ability to work on multiple projects simultaneously under tight deadlines
Strong analytical, problem solving and interpersonal skills while effective at writing and presenting analyses for all types of users
Experience working in the music industry is a plus
We’re working to build a more inclusive economy where our customers have equal access to opportunity, and we strive to live by these same values in building our workplace. Square is a proud equal opportunity employer. We work hard to evaluate all employees and job applicants consistently, without regard to race, color, religion, gender, national origin, age, disability, pregnancy, gender expression or identity, sexual orientation, citizenship, or any other legally protected class.
We believe in being fair, and are committed to an inclusive interview experience, including providing reasonable accommodations to disabled applicants throughout the recruitment process. We encourage applicants to share any needed accommodations with their recruiter, who will treat these requests as confidentially as possible.
Additionally, we consider qualified applicants with criminal histories for employment on our team, and always assess candidates on an individualized basis.
At Square, we want you to be well and thrive. Our global benefits package includes:
- Healthcare coverage
- Retirement Plans
- Employee Stock Purchase Program
- Wellness perks
- Paid parental leave
- Paid time off
- Learning and Development resources
Square, Inc. (NYSE: SQ) builds tools to empower businesses and individuals to participate in the economy. Sellers use Square to reach buyers online and in person, manage their business, and access financing. Individuals use Cash App to spend, send, store, and invest money. And TIDAL is a global music and entertainment platform that expands Square's purpose of economic empowerment to artists. Square, Inc. has offices in the United States, Canada, Japan, Australia, Ireland, Spain, Norway, and the UK.