Data Engineer - Sony Music Entertainment - New York, NY

The Orchard is a leading distributor of digital music and film. We have almost 20 million songs in our catalogue, which accounts for over 20% of the music that’s currently available on Spotify and iTunes. Our growing film business has more than 10 theatrical releases planned in 2016 and a 2015 Oscar Nominated documentary film. The Orchard’s YouTube channels have 100 billion lifetime views.

We have a robust technology practice that includes Product Managers, QA Engineers and Software Engineers who work diligently to provide our clients with cutting edge solutions. Some of our most exciting projects focus on data-driven insights and analytics tools as well as optimization of monetization and reach for our YouTube business.

The Orchard is looking for a Data Engineer to join our dynamic NYC development team.

Responsibilities:
Create and maintain systems to load and transform very large data sets from digital media retailers (iTunes, Spotify, YouTube, etc) as well as social media sources. Work with a cross-functional team to create data-driven insights and reports for business stakeholders. Work with the Software Engineering team to create customer-facing analytics tools and visualizations. Deliver big data analytics to end users.

Qualifications:
Experience with AWS ecosystem. Some preferred services are RDS, SQS, SWF. Proven experience with ETL and MapReduce (SWF or EMR). Expertise with distributed data stores (Redshift). Familiarity with noSQL technologies (mongoDB, DynamoDB). Proficient in scripting language of choice. Python preferred, Ruby and PHP a plus. Highly proficient in SQL. Experience with MySQL a strong plus. Deep understanding of data structures and schema design. Detail-oriented, proactive problem solving skills.

About The Orchard®

The Orchard is an independent music and video distribution company that provides an innovative and comprehensive sales and marketing platform for content owners. With our industry-leading technology and operations, we partner with companies of all sizes to make their music and videos available across hundreds of digital and mobile outlets around the world, and physical retailers too. We work with our clients to maximize their revenue, and provide them with the latest and greatest digital marketing tools and sophisticated sales analytics to help them run their businesses efficiently and effectively.

The Orchard was founded in 1997 in New York City to foster independence and creativity in the music industry. Our headquarters are in New York and London, with operations in more than 25 markets around the world, including France, Spain, Germany, Mexico, Argentina, India, Australia and more. At The Orchard, the focus is to provide a comfortable, social and engaging environment to encourage productivity, creativity and personal/business relationships. From monthly potlucks and game nights to company kickball teams and other staff perks, our employees like what they do and where they do it.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.