About Open Road Integrated MediaOpen 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.
SummaryThe 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 FunctionsCreate ETL pipelines to fetch data from data sources and ingest into databasesWrite / Optimize SQL queries for different views of data productsCreate tableau reports with multiple data points married togetherBuild scripts to automate the current manual workflow of other departmentsRequirementsAvailable approximately 40 hours per week for a minimum of 16 weeksExperience in writing complex SQL queries to extract data from relational databases (e.
g. MySQL, Redshift)Comfortable with extensive Python codingWilling to work with a codebase that is not originally written by youGood communication skills;
understand that being an effective Data Engineer Intern is about communicating with people as much as it is about writing codeWilling to learn any language / tools that are necessary to get the job doneThis role will be a hybrid of remote work and limited in-person office attendance (at least 1 day) in New York City, NYCompensationBetween $16.
00 and $25.00 per hour, commensurate with experience.Powered by JazzHR