Job Information
Open Road Media Data Engineering Intern - Paid 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. Open Road was founded in 2009 with the belief that great marketing and great content are the engines of growth for underserved authors and books. This philosophy is at the core of everything that we do. Open Road revolutionizes how publishers service authors, agents, and readers.
Summary
The Data Engineering and Analytics team is seeking one full-time, paid Data Engineering Intern. This role will work closely with the team on various tasks and projects. The members of the Data Engineering and Analytics team use rigorous analytics to generate insights that inform product, marketing, and business decisions across the company. In the meantime, we build systems, infrastructure, data products for collecting, storing, and visualizing data to foster data democracy in the company. We work in Python, and SQL and with technologies like Airflow, Django, Tableau, and Spark.
Essential Functions
Create ETL pipelines to fetch data from data sources and ingest into databases
Write/Optimize SQL queries for different views of data products
Create tableau reports with multiple data points married together
Build scripts to automate the current manual workflow of other departments
Requirements
Available approximately 40 hours per week for a minimum of 16 weeks
Experience in writing complex SQL queries to extract data from relational databases (e.g. MySQL, Redshift)
Comfortable with extensive Python coding
Willing to work with a codebase that is not originally written by you
Good communication skills; understand that being an effective Data Engineer Intern is about communicating with people as much as it is about writing code
Willing to learn any language/tools that are necessary to get the job done
This role will be a hybrid of remote work and limited in-person office attendance (at least 1 day) in New York City, NY
Compensation
Between $16.00 and $25.00 per hour, commensurate with experience.
Powered by JazzHR