Senior Python Developer

Senior Python Developer (Remote - East Coast)

Experience level: Mid-senior

Experience required: 7 Years

Education level: Bachelor’s degree

Job function: Information Technology

Industry: Entertainment

Relocation assistance: No

Visa sponsorship eligibility: No - only USC/Native Required

NOTE: This position is remote and can be based out of NY, FL, DE, MA, PA, TN, or GA

Job Details:

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

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.

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

MUST HAVE

• Bachelor’s degree in information technology, Computer Science, Statistics, Engineering, Mathematics, Economics, Business Analytics, Data Science, Accounting or related field 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, sqlalchemy, 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.

ADDITIONAL INFORMATION

• This is a remote position, and the candidate can be based anywhere in NY, FL, DE, MA, PA, TN or GA.

Industry

• Entertainment/Musical

Employment Type

Full-time

Job Type: Full-time

Pay: $120,000.00 - $130,000.00 per year

Compensation package:

• Overtime pay
• Performance bonus

Experience level:

• 8 years

Education:

• Master's (Required)

Experience:

• Python, PANDAS, ORM, and Matplotlib packages.: 8 years (Required)
• sqlalchemy, OS, logging, urllib, Numpy,: 8 years (Required)
• (Excel, Text, JSON, HTML, etc.) through ETL processes: 8 years (Required)
• data analytic tools, specifically PowerBI and Tableau: 7 years (Required)
• Microsoft Excel tools , Macros, Pivot Tables, and formulas: 7 years (Required)
• VLOOKUP and SUMIF, Power Pivot and Power Query is a plus: 7 years (Required)
• SQL-based data manipulation: 7 years (Required)
• IDEs; Visual Studio Code experience is a must.: 7 years (Required)
• Royalty audit or music administration exp. required: 7 years (Required)
• Testing, Beautiful Soup, SciPy, and Scikit: 6 years (Required)
• database design, loading, and schema construction: 6 years (Required)

Work Location: On the road