Job Overview and Responsibilities

Job Overview

• Experience level: Mid-senior
• Experience required: 7 Years
• Education level: Bachelor’s degree
• Relocation assistance: No
• Visa sponsorship eligibility: No
• Skills: Python, Datasets, SDLC, ETL, SQL, SQL Server, Pandas, ORM, SQLalchemy, Urllib, Numpy, Matplotlib, PowerBI, Tableau, MS Excel - Macros, Pivot Tables, HTML, JSON, IDE, Visual Studio
• Domain: royalty audit or music administration is a must
• NOTE: This position is remote, but candidate must be based out of NY, FL, DE, MA, PA, TN, or GA

About us

Established in 1967, we stand as a prominent full-service business management firm catering to a select group of entertainers, executives, and high net worth individuals. With 30 partners and a team of over 600 staff members, we provide extensive financial services across various creative and performing arts sectors, including music, motion pictures, television, sports, literature, and more. Our firm is strategically located with offices in Los Angeles, New York City, Nashville, San Rafael, Wilmington, and London.

About job

We are seeking a Senior Python Developer with ideally Music Royalties experience to join our team of dedicated professionals.

Overview of Role: The Senior Python Developer is responsible for assisting the Firm’s music data team with taking complex data issues facing the business and simplifying them.

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 analysing 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.
   

Key Requirements

• Bachelor’s degree in information technology, Computer Science, Statistics, Engineering, Mathematics, Economics, Business Analytics, Data Science, Accounting or related field is required.
• 7+ years of previous work experience with managing large datasets and programming.
• 7 years’ experience in full SDLC methodologies and implementation methods; testing experience is a plus.
• In-depth experience in Extract, Transformation, and Load techniques.
• Expert knowledge and experience with object-oriented methodology, development, and toolsets Expert-level knowledge in Python, specifically Pandas, ORM, sqlalchemy, OS, logging, urllib, Numpy, and Matplotlib packages; Familiarity and experience in Beautiful Soup, SciPy, and Scikit-learn would be very helpful but not required.
• Solid and demonstrated experience working with data analytic tools, specifically PowerBI and Tableau; Other tool exposure and experience is a plus.
• Expert-level knowledge of Microsoft Excel tools, including Macros, Pivot Tables, and formulas (such as VLOOKUP and SUMIF); Power Pivot and Power Query is a plus.
• Expert fluency in 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.
• Advanced experience in multi-tier Architecture and associated technologies.
• Advanced knowledge in database design, loading, and schema construction to include performance, audit, and check sum processes.
• Expert working knowledge in IDEs; Visual Studio Code experience is a must. 
• Understanding of complex and advanced mathematical and accounting principles.
• Solid interpersonal skills and other key soft skills (i.e., communication, time management, emotional intelligence, adaptability, active listening, critical thinking, etc.)
• Ability to communicate with both technical and non-technical teams to understand and define problems, and to articulate proposed solutions.
• Discretion and confidentiality with regards to sensitive financial transactions is a must
• Strong soft skills including attention to detail, excellent verbal, and written communication, team-oriented, and self-motivated

Note: Candidate information, including education and work experience, is verified upon an offer of employment. Falsification of application information may be grounds for denying employment.

Why You Should Apply This Position

We offer a diverse and employee-friendly environment with great work/life balance. Our comprehensive benefits package includes:

• Multiple Medical, Dental and Vision plans (including HSA and FSA options)
• Generous paid time off policy
• Paid holidays
• Hybrid work flexibility
• 401(k) with discretionary match
• Discretionary performance bonus
• Tuition assistance and career advancement programs
• CPA program (employer-paid prep materials, paid time off to study and sit for exams, a CPA completion bonus, continued education and license renewals)
• Early office closures for major holidays Discretionary profit-sharing program
• Employee and client referral bonus
• Commuter benefits
• Wellness program