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.

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

　　Location: This position can be based out of New York City, White Plains (NY), Nashville (TN), Wilmington (DE), Boston (MA), or potentially elsewhere on the east coast.

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

　　A successful candidate will possess the following qualifications:

　　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

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

　　Benefits & Pay

　　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

　　This is an exempt position. Employee compensation is determined by a variety of factors including, but not limited to, employee education/training/credentials, employee work experience, work location (including if the employee will be hybrid or fully in-office), the scope and responsibilities of the role, internal peer equity, and market considerations. The expected base compensation hiring range for this position is $120,000 to $160,000 per year.

　　Gelfand, Rennert & Feldman is an Equal Opportunity Employer.

　　For information on our Job Applicant Privacy Notice, please click here (http://www.grfllp.com/job-applicant-privacy-policy/) .

　　Powered by JazzHR