Data Engineer
New York, NY

Job Description

Overview

Sony Music Entertainment is a global recorded music company with a roster of current artists that includes a broad array of both local artists and international superstars, as well as a vast catalog that comprises some of the most important recordings in history. Sony Music Entertainment is a wholly owned subsidiary of Sony Corporation of America.

Sony Music Entertainment is undergoing a huge transformation driven by Data, Analytics, and Cognitive technologies. We have created a new team, lead by our CDO, focused on advancing Sony Music's data strategy & capabilities around the world.

Using data-centric strategies, with design and technology principles in mind, we are developing products, tools, apps, and more that deliver actionable insights that help shape strategic thinking and drive business solutions for our labels. The teams goals are to:

* Provide business intelligence and technology solutions for use across the company's labels and business units
* Create predictive tools and analytics platforms to enhance Sony Music's capabilities in artist and partner discovery, solutions, commercial strategy, marketing, and A&R
* Enhance service to Sony Music's artists and business partners
* Grow commercial opportunities

The Data Engineer will join the newly created Data Strategy team and will report to the EVP of Data Strategy, Chief Data Officer. This role will explore and build products using the latest and greatest in Data Analytics, Cognitive Services, Machine Learning and more. This role is based at Sony Music's offices in New York.

Sony Music is committed to providing equal employment opportunity for all persons regardless of age, disability, national origin, race, color, religion, sex, sexual orientation, gender, gender identity or expression, pregnancy, veteran or military status, marital and civil partnership/union status, alienage or citizenship status, creed, genetic information or any other status protected by applicable federal, state, or local law.

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.
* Process millions of rows of data daily to provide analytics to our end users.
* Take advantage of our continuous integration and deployment.
* Participate in technical design and peer review for new projects.

Qualifications

* Experience using Snowflake and Google Cloud Platform preferred.
* Experience with AWS ecosystem. Some preferred services are Redshift, RDS, S3, and 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 collabora