This job has expired, please see additional jobs below
Data Engineer
Sony Music Entertainment
New York, NY, United States
Job Details - this job has expired, please see similar jobs below
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 had more than 10 theatrical releases 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 Engineerto 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 hundreds of million of rows of analytics to end users daily.
• Take advantage of our continuous integration and deployment
• Participate in technical design and peer review for new projects
Qualifications:
• Experience with AWS ecosystem. Some preferred services are Redshift, RDS, S3, SWF.
• Proven experience with ETL frameworks (Airflow, Luigi, or our own open sourced garcon).
• Expertise with at least one distributed data stores (Redshift, Cassandra, Snowflake).
• Familiarity with noSQL technologies (mongoDB, DynamoDB).
• Proficient in scripting language of choice. Python is strongly preferred, PHP a plus.
• Highly proficient in writing SQL for a relational datastore (MySQL, PostgreSQL).
• Knowledge of technologies that can deal with Big Data is a Big Plus (Kafka, Spark, Hive, Hadoop/MapReduce).
• Ability to write automated tests (unit, functional, and integration) to ensure code works as expected.
• Desire to collaborate with other engineers through peer code reviews.
• 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.
The Orchard is committed to providing equal employment opportunity for all persons regardless of age, disability, national origin, race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, veteran or military status, genetic information or any other status protected by applicable federal, state, or local law.