Gelfand, Rennert & Feldman is seeking a Senior Python Developer to join its Royalty Data Intelligence team. In this remote role, you will be instrumental in simplifying complex data issues through automation, collaborating with colleagues across all 10 of the Firm's offices.
What You'll Do
- Assist in managing, storing, and accessing large volumes of music data from various industry sources.
- Design, develop, and implement ETL processes to intake multiple file types for storage in SQL Server.
- Integrate standard data wrangling processes into data ingestion.
- Perform cloud development and integration for existing and future processes.
- Develop and utilize logging, audit monitoring, and code validation processes to measure efficiency.
- Build automated processes to increase efficiency in ingesting, consolidating, normalizing, and analyzing data.
- Integrate API functionality and data from 3rd party providers into website and back-end processes.
- Act as a liaison between the Royalty Group and IT to assess software/database options and assist in change management.
- Recommend and build new data platforms/solutions to meet business requirements.
- Own and manage algorithm development projects through GitHub from design to deployment.
- Set up and manage datarooms and/or portals for clients and third parties.
- Solve complex data problems and share complex ideas verbally and visually with team members.
What We're Looking For
- A Bachelor’s Degree and 7+ years in a similar role.
- Extensive experience in full SDLC methodologies and implementation methods.
- In-depth experience in Extract, Transformation, and Load (ETL) 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.
- Solid, demonstrated experience with data analytic tools, specifically PowerBI and Tableau.
- Expert-level knowledge of Microsoft Excel tools, including Macros, Add-Ins, Pivot Tables, formulas, Power Pivot, and Power Query.
- Expert fluency in SQL-based data manipulation; Microsoft SQL Server experience is necessary.
- Advanced experience in multi-tier Architecture and associated technologies.
- Advanced knowledge in database design, loading, and schema construction.
- Expert working knowledge in IDEs; Visual Studio Code experience is a must.
- Solid interpersonal skills and other key soft skills.
- Ability to communicate effectively with both technical and non-technical teams.
- Discretion and confidentiality regarding sensitive financial transactions is a must.
- Strong attention to detail, excellent verbal and written communication, team-oriented, and self-motivated.
Nice to Have
- 8+ years in a similar role at an entertainment company or business management firm.
- Testing experience.
- Familiarity and experience with Beautiful Soup, SciPy, and Scikit-learn.
- Exposure to other relevant tools.
Technical Stack
- Languages & Libraries: Python, Pandas, ORM, sqlalchemy
- Databases & BI: SQL Server, PowerBI, Tableau
- Tools & Platforms: Microsoft Excel, Power Pivot, Power Query, GitHub, Visual Studio Code
Team & Environment
You will join a team of dedicated professionals collaborating across 10 offices. The role is part of the Royalty Data Intelligence team and acts as a liaison between the Royalty Group and the IT department.
Benefits & Compensation
- Salary range: $140,000 - $165,000
- Comprehensive benefits package
- Annual bonus
Work Mode
This is a fully remote position.
Gelfand, Rennert & Feldman is an Equal Opportunity Employer.
