Sr Data Wrangler job at Symphonic Distribution, Inc.

Job Description

Sr. Data Wrangler

Symphonic Distribution is a 100% independent music distribution and marketing company headquartered in downtown Tampa, FL and with a strong presence in New York City, Nashville, and major music markets across the world. We focus on distributing, promoting and developing great independent artists, record labels, and many more. Not only do we want to work with some prolific creators, we want to also work with creative, passionate, positive and forward thinking individuals. Maybe this is you? If so, then below you will find an opportunity to join Symphonic. As a company, we want to have an environment that is inclusive, diverse and accepting so that everyone, regardless of their background, race or sexual orientation has a chance to do great things.

In a Nutshell //

We are looking for a highly motivated and detail-oriented Sr. Data Wrangler who has strong leadership skills and the ability to work independently, as well as coordinate with team members. The Sr. Data Wrangler will be responsible for managing and ensuring the quality, integrity, and processing of royalty data. Duties include coordinating, “wrangling”, cleansing, joining, and calculating large data sets from multiple sources, while maintaining high quality data standards and achieving monthly targets. This is a critical role that interacts with finance team members, clients, business partners, and multiple departments. This position reports to the Director of Royalties. This role will work remotely in Tampa, FL, reporting to the office in downtown Tampa as needed.

What you will do //

Merge many large data sources into a single, clean dataset; identifying and resolving gaps and discrepancies in royalty and related data.
“Wrangle”, format / transform, raw data into a more usable form, using complex data models, system workflows, and SQL.
Ensure collected data is in the correct format with excellent quality and integrity, including complex contract models, distribution rates, and calculations.
Identify outliers in data and resolve discrepancies
Suggest improvements and best practices to enhance the royalties data process and workflow
Identify, communicate and solve complex issues
Plan and execute work independently and take ownership of your area
Achieve robust goals and turnaround times within a fast-paced and multi-faceted environment
Provide and coordinate niche client support and reporting regarding royalty-related matters
Produce reports and/or dashboards as needed
Maintain and/or create documentation of royalty-related processes as needed
Contribute to evolving our technology, processes, and culture

What you need to have //

Bachelor’s Degree or equivalent
5+ years experience working with complex, large data sets in a professional environment
Experience performing “data wrangling”, data cleansing, and/or “data munging”
Advanced proficiency with Transact-SQL and/or mySQL syntax
Advanced proficiency with relational databases including normalization, schemas, and table relationships / joins
Advanced proficiency with importing CSV and TAB delimited text / flat files to SQL using MS SQL Server Management Studio (SSMS)
Advanced proficiency with MS Excel, including VLOOKUP, pivot tables, SUMIF and other formulas / formatting
Incredible attention to detail
Outstanding organizational and time-management skills
Exceptional analytical and critical thinking
Excellent interpersonal and communication skills
Self-starter who can effectively collaborate and coordinate with remote colleagues
Motivation and energy to work with a sense of urgency while producing an excellent level of quality, and while meeting critical monthly timelines and weekly targets
Curiosity and a drive to continuously learn and improve

What will set you apart //

Experience with Snowflake and/or Mode
Experience with data-driven Software as a Service (SaaS) applications
Experience with remote client support / virtual help desk
Experience with accounting concepts and data
Knowledge of best practices in royalty data scrubbing and reporting

Additional Insights

This position reports to the Director of Royalties

About Symphonic

Symphonic Distribution enables content creators to fully maximize their music’s revenue and grow their global audience. The company focuses on working with: record labels, artists, managers, producers, social media influencers, and even distributors just like us to get their messages seen and heard. While our core business is to distribute music digitally and physically for the many talented creators that we have the honor of working with, we focus on a number of services, such as: Physical Distribution, User Generated Content Monetization on YouTube, Tik Tok, Triller, Instagram, Release Promotion such as Playlist pitching, marketing diagnostics, strategy and a number of other very important services to ensure that creators are maximizing and collecting on as many royalties as possible. Symphonic also showcases one of the largest partnership networks available, partnering with Spotify, Apple Music, Pandora, Amazon, and many other services where music can be consumed on. Check out more about us on our website at www.symphonic.com.

Interested in this position?

Click here to learn how to get in touch