Gelfand, Rennert & Feldman, a well-established entertainment accounting firm in New York, Nashville and Los Angeles, is seeking an ETL Developer for our Royalty Group in the Century City, Nashville or White Plains office. This position can also be fully remote.

Responsibilities include :

As a member of the GR&Fs music data team, you will take the complex data issues facing the business and make them simple

Assist the Royalty Group manage and store large volumes of music data obtained from record companies, music publishers, PROs and DSPs in connection with their engagements

Develop automated processes to increase efficiency in ingesting, consolidating, normalizing, and analyzing data

Act as liaison between Royalty Group with IT department to assess software, database, and programming options available and assist in implementation

Recommending and building new data platforms/solutions as required to meet and exceed business requirements

Own algorithm development projects from start-to-end: design, develop, QA, deploy, experiment, and analyze

Assist in training the Royalty Group on the use of newly develop automated processes

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

A successful candidate will possess the following qualifications:

Bachelors degree in Information Technology, Computer Science, Statistics, Engineering, Mathematics or related field

Five or more years of previous work experience working in managing large datasets and programming

Expert knowledge of Excel, including Macros, Pivot Tables and formulas Power Pivot and Power Query

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

Expert knowledge in SQL Server Studio, SQL Server Integration Services, SQL Server Analytic Services, and SQL Server Reporting Services

In-depth experience in Extract, Transformation, and Load techniques

Advanced knowledge in database design, loading, and schema construction to include performance, audit, and check sum processes

In-depth experience using scripting languages such as R and Python for data analysis

Experience working with data visualization tools such as Tableau and data lake/warehouse SaaS solutions is preferred

Understand basic mathematical and accounting principles

You have the ability to communicate with both technical and non-technical teams to understand and define problems, and articulate proposed solutions

Discretion and confidentiality with regards to sensitive financial transactions

The candidate must be self-motivated, detail oriented and possess excellent verbal and written communication skills, as well as being able to work well in a team environment

This is a non-exempt position. Salary is competitive based on experience. Comprehensive benefits package includes: Medical, Dental, Vision, Wellness, 401, a generous paid time off policy and up to ten paid holidays per year. We offer a diverse and employee-friendly environment with great work/life balance. Gelfand, Rennert & Feldman is an Equal Opportunity Employer.

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

About Gelfand, Rennert & Feldman Founded in 1967, Gelfand, Rennert & Feldman 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 500 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.

Powered by JazzHR

Job Details:

Posted Date : 2022-05-07

Job type : Full Time

Learn More & Apply

Apply