Senior Python Developer for Music Royalties

Position Summary Gelfand, Rennert & Feldman is seeking a Senior Python Developer to join our team of dedicated professionals. This is a remote position but this candidate should be based and operating in the Eastern Time Zone (EST). They will be collaborating with teams across all (10) Gelfand, Rennert & Feldman offices. The Senior Python Developer is responsible for assisting the Firm’s Royalty Data Intelligence (“RDI”) team with taking complex data issues facing the business and simplifying them through automation. Primary 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 (PDF, 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 and manage algorithm development projects through GitHub from start-to-end: design, development, Quality Assurance (QA), deployment, experiment, analysis • Set up and manage datarooms and/or portals for clients and other third parties • Act as a resource to the firm 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 Qualifications: • 3+ years of experience working in music royalties is required • Bachelor’s Degree and 7+ years in a similar role is required • 8+ years in a similar role at an entertainment company or business management firm is preferred • ~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, Add-Ins Pivot Tables, and formulas (such as VLOOKUP and SUMIF); Power Pivot and Power Query is required • 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 • 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 About Gelfand, Rennert & Feldman Founded in 1967, Gelfand, Rennert & Feldman ("GRF") is a leading full-service business management firm for an exclusive assortment of entertainers, executives and select high net worth individuals. Our 30 partners and over 600 staff members deliver comprehensive financial services in the fields of music, motion pictures, television, sports, literature, and other creative and performing arts. Our firm has offices in Los Angeles, New York City, Nashville, San Rafael, Wilmington, and London. This is a exempt position. The annualized base pay range for this role is expected to be between $140,000 - $165,000. Actual base pay could vary based on factors including but not limited to experience, subject matter expertise, geographic location where work will be performed, and the applicant's skill set. The base pay is just one component of the total compensation package for employees. Other rewards may include an annual bonus and a comprehensive benefits package. Candidate information, including education and work experience, is verified upon an offer of employment. Falsification of application information may be grounds for denying employment. Gelfand, Rennert & Feldman is an Equal Opportunity Employer. For information on our Job Applicant Privacy Notice, please click here. #LI-TN1 #LN-CH1 Founded in 1967, Gelfand, Rennert & Feldman ("GRF") is a leading full-service business management firm for an exclusive assortment of entertainers, executives and select high net worth individuals. Our 30 partners and over 600 staff members deliver comprehensive financial services in the fields of music, motion pictures, television, sports, literature, and other creative and performing arts. Our firm has offices in Los Angeles, New York City, Nashville, San Rafael, Wilmington, and London. The following language is for US based roles only For California Applicants: Information on your California privacy rights can be found here For Indiana Applicants: It is unlawful for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component. For Maryland Applicants: I UNDERSTAND THAT UNDER MARYLAND LAW, AN EMPLOYER MAY NOT REQUIRE OR DEMAND, AS A CONDITION OF EMPLOYMENT, PROSPECTIVE EMPLOYMENT OR CONTINUED EMPLOYMENT, THAT ANY INDIVIDUAL SUBMIT TO OR TAKE A POLYGRAP OR SIMILAR TEST. AN EMPLOYER WHO VIOLATES THIS LAW IS GUILTY OF A MISDEMEANOR AND SUBJECT TO A FINE NOT EXCEEDING $100. For Massachusetts Applicants: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this shall be subject to criminal penalties and civil liability. For Montana Applicants: If hired, the employment relationship is governed by the Wrongful Discharge from Employment Act. Mont. Code Ann. Section 39-2-901. For Rhode Island Applicants: Focus is subject to Chapters 29-38 of Title 28 of the General Laws of Rhode Island and is therefore covered by the state’s workers’ compensation law. If you willfully provide false information about your ability to perform the essential functions of the job, with or without reasonable accommodations, you may be barred from filing a claim under the provisions of the Workers’ Compensation Act of the State of Rhode Island if the false information is directly related to the personal injury that is the basis for the new claim for compensation. The Company complies fully with the Americans with Disabilities Act. Apply tot his job