Responsibilities

Assist the Royalty Group in managing, storing, and accessing large volumes of music data obtained from record companies, music publishers, PROs and DSPs in connection with their engagements.
Design, Develop, and Implement processes that intake multiple file types (Excel, Text, JSON, HTML, etc.) through ETL processes to store in existing SQL Server instances.
Integrate and include standard data wrangling processes into data ingestion.
Cloud Development and Integration for existing and future processes.
Develop and utilize logging, audit monitoring, and code validation processes to measure efficiency, profitability, and resource optimization.
Develop automated processes to increase efficiency in ingesting, consolidating, normalizing, and analyzing data.
Integrate API functionality and data from 3rd party providers to include website and back-end processes; Advanced knowledge of website functionality and JSON format(s) is necessary.
Act as liaison between Royalty Group and IT department to assess software, database, and programming options available and to assist in related change management, implementation, and training.
Recommend and build new data platforms/solutions as required to meet and/or exceed business requirements.
Own algorithm development projects from start-to-end: design, development, Quality Assurance (QA), deployment, experiment, analysis.
Set up and manage datarooms for clients and other third parties.
Act as a resource to the Royalty Group to solve complex data problems and share complex ideas verbally and visually in an understandable manner with team members.
Other projects and duties, as assigned.

Must Have Qualifications

Bachelor's degree in information technology, Computer Science, Statistics, Engineering, Mathematics, Economics, Business Analytics, Data Science, Accounting or related fields is required.
Minimum 7+ years of previous work experience with managing large datasets and programming.
7 years' experience in full SDLC methodologies and implementation methods.
Experience working with Python, specifically Pandas, ORM, SQL alchemy, OS, logging, urllib, NumPy, and Matplotlib packages.
Experience in Design, Develop, and Implement processes that intake multiple file types (Excel, Text, JSON, HTML, etc.) through ETL processes to store in existing SQL Server instances.
Experience working with data analytic tools, specifically PowerBI and Tableau; Other tool exposure and experience is a plus.
Experience working with Microsoft Excel tools, including Macros, Pivot Tables, and formulas (such as VLOOKUP and SUMIF); Power Pivot and Power Query is a plus.
Experience with SQL-based data manipulation; This role will work with an array of disparate data sources so experience writing efficient, performance-optimized queries is required and Microsoft SQL Server experience is necessary.
Experience within IDEs; Visual Studio Code experience is a must.
Royalty audit or music administration exp. required.

NICE TO HAVE

Testing experience is a plus.
Familiarity and experience in Beautiful Soup, SciPy, and Scikit-learn would be very helpful but not required.
Advanced knowledge in database design, loading, and schema construction to include performance, audit, and check sum processes.