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
Posted Date : 2022-05-07
Job type : Full Time