Intern - Data Engineer

Optimum; New York (NY); On-site; USD 41,000 - 55,000; Full time

Job summary

Optimum Media Engineering in New York is seeking a Data Engineer Intern to join the Data Solutions Team. The Intern will help develop and maintenance of data pipelines, data infrastructure, and analytical data solutions.

You will work closely with Data Engineering and Data Analytics teams to ingest, process, and manage data across various systems. The role offers hands-on experience with our data platform and technologies, including BigQuery, Snowflake, Databricks, and more, while developing

Qualifications

• Bachelor's/Master’s degree in Data Science/Statistics/CS/Engineering/Information Science/Math or equivalent
• Graduate degree in related field preferred
• Intermediate SQL programming with relational databases
• Comfortable reading, writing Python code
• Exposure to cloud data platforms (BigQuery, Redshift, Databricks)
• Familiarity with ETL/ELT and data processing workflows
• Strong problem-solving and willingness to learn
• Team-oriented with good communication
• Exposure to Snowflake or similar data warehouses
• Familiarity with PySpark/Spark
• Experience scripting and deploying ETL jobs; cron jobs a plus
• Git, GitHub or similar versioning a plus
• Statistical analysis or ML experience a plus
• Media, Television, Advertising, or Digital Marketing experience a plus

Responsibilities

• Collaborate with data engineers to maintain data pipelines and ETL/ELT processes
• Work with BigQuery, Snowflake, Databricks to support data processing and reporting
• Write SQL queries and Python code for data structuring and validation
• Aggregate, onboard and investigate data from multiple sources
• Document data processes, architecture and development activities

Skills

SQL

Python

ETL/ELT concepts

Data structures

Process automation

Data validation

Problem-solving

Team communication

Cross-functional collaboration

Cron jobs

Linux

Git

GitHub

Data warehousing

Spark / PySpark

Education

Bachelor's/Master’s Degree in Data Science/Statistics/Computer Science/Computer Engineering/Information Science/Mathematics or equivalent

Graduate degree in related field, preferred

Tools

Google BigQuery

AWS Redshift

Databricks

Snowflake

Git / GitHub

Bash scripting

Linux

Job description

Requisition ID12127-Posted08/11/2026-Optimum Media Engineering-News & Advertising-USA.NY.Long Island City-Corp

Introducing Optimum Media. Driven by the power of Optimum, Optimum Media is our innovative multiscreen advertising sales and media consultancy business servicing small to medium business as well as national, political, media & entertainment and agency clients across the United States.

Our team is comprised of Sales Executives, Software Engineers, Data Analysts, Ad Operations, Marketing Professionals, Product Managers and more.

If you are tech-savvy, data-driven, client focused, and solutions oriented this brand is for you!

Job Summary

The Data Solutions Team is a core part of Optimum Media. Our team incorporates data engineering, data management, data onboarding, and data analysis into a singular group. We are the data specialists that ensure the highest operational efficiency of reporting and analytics within the organization and areseeking a Data Engineer Intern to support the development and maintenance of data pipelines, data infrastructure, and analytical data solutions. The Intern will work closely with Data Engineering and Data Analytics teams to help ingest, process, and manage data across various systems. This role will assist in the development and improvement of data solutions, data quality processes, and data pipeline reliability while gaining hands‑on experience with our data platform and technologies.

Responsibilities

• Collaborate with data engineers and cross-functional teams to support the development and maintenance of data pipelines, data structures, and ETL/ELT processes.
• Work with large relational databases and data warehouse platforms (e.g. Google BigQuery, Snowflake, Databricks) to support data processing and reporting needs.
• Write SQL queries & Python code for data structuring, data validation, process automation, and data engineering workflows.
• Aggregate, onboard, and investigate data from multiple sources; identify and troubleshoot data quality issues.
• Document data processes, architecture, and development activities following established engineering best practices.

Qualifications

• Bachelor's/Master’s Degree in Data Science/Statistics/Computer Science/Computer Engineering/Information Science/Mathematics or equivalent job experience
• Graduate degree in related field, preferred
• Intermediate SQL programming skills, including working with relational databases, data manipulation, and data transformation
• Comfortable reading, writing, troubleshooting, and understanding Python code
• Exposure to cloud data platforms and technologies such as Google BigQuery, AWS Redshift or Databricks
• Familiarity with ETL/ELT concepts and data processing workflows
• Strong problem-solving skills and willingness to learn new technologies and tools
• Team-oriented with strong communication skills and the ability to collaborate with both technical and non-technical stakeholders
• Exposure to Snowflake or other cloud-based data warehouse technologies, preferred
• Familiarity with PySpark, Spark or other distributed data processing technologies through coursework, projects, or internships, preferred
• Experience scripting and deploying ETL jobs, cron jobs and code changes, preferred
• Experience with Linux or Bash scripting is a plus
• Experience with Git, GitHub, or other code versioning tools is a plus
• Basic statistical analysis, data science, or machine learning experience is a plus
• Experience in Media, Television, Advertising, or Digital Marketing is a plus

We are an Equal Opportunity Employer committed to recruiting, hiring and promoting qualified people of all backgrounds regardless of gender, race, color, creed, national origin, religion, age, marital status, pregnancy, physical or mental disability, sexual orientation, gender identity, military or veteran status, or any other basis protected by federal, state, or local law.

The Company collects personal information about its applicants for employment that may include personal identifiers, professional or employment related information, photos, education information and/or protected classifications under federal and state law. This information is collected for employment purposes, including identification, work authorization, FCRA-compliant background screening, human resource administration and compliance with federal, state and local law.

Pay is competitive and based on a number of job-related factors, including skills and experience. The starting pay rate/range at time of hire for this position in the posted location is$35.00/ hour. The rate/range provided herein is the anticipated pay at the time of hire, and does not reflect future job opportunity.

We appreciate your interest in this opportunity. Applicants must be authorized to work for ANY employer in the U.S. Please note that at this time, we do not provide visa sponsorship for employment.