New York Seasonal Jobs

Job Information

Open Road Media Data Engineering Intern (Summer 2020, unpaid,for-credit) in NEW YORK, New York

About Open Road Integrated Media

Open Road Integrated Media is a prestige content brand delivering digital experiences that entertain and inform readers around the world.

Laser-focused on revenue, reach, and repeat customers, the Open Road network of digital properties produces compelling stories that keep audiences engaged ? across devices, content verticals, and global territories.

About the Position

The Data Analytics team has an opening for a Data Engineering Intern (Data Product) to work 40 hours per week this summer. This position is unpaid and for-credit only! You must be eligible to receive academic credit. This is a great opportunity for career advancement.

The Data Analytics team serves a critical role in the company with stakeholders covering Marketing (Book Marketing, Audience Development, Website Content), Tech & Product, Editorial Ops, Sales & Business Development divisions. The primary goal of Data Analytics team is to convert data into values and to inform different business decisions across company by building reports, analyses, and data products.

Data engineering serves as a foundation for the entire Data Analytics team by building and maintaining a data infrastructure stack that is stable, reliable and scalable. The Data Engineering Intern (Data Product) will work closely with the Data Analysts, stakeholders from Marketing team, Developers from the Tech team to build data products from end to end (e.g. design ? prototype ? production builds). After internship, you will get hands-on experience in both front-end and back-end development.

We value Data Engineering Interns who are/have:

  • Comfortable with fast-moving work environment with quick iterations

  • Excellence in time management and delivering works in a tight deadline

  • Systematic thinking with capability of considering edge cases and boundary conditions

  • Able to dig into all the systems to track and investigate the bug when things break

  • Eager to learn and try new data engineering technology

Skills and Qualifications

  • Proficient in SQL and Python languages

  • ETL or pipeline design and implementation

  • Hands-on experience in relational databases and complex query authoring (e.g. Redshift, MySQL)

  • Knowledge of AWS products (e.g. S3, EC2)

  • Version control with git

  • Must be able to work out of our office located in the Financial District in Manhattan

  • Bonus: Knowledge of setting up and using open source Airflow as a script scheduling solution

  • Bonus: NoSQL database experience such as MongoDB

Location: New York, NY

You will receive academic credits.