Data Engineering Intern: Pipelines, SQL & BigQuery

re-zoo-me; New York, Northern (NY, KY); Hybrid; USD 41,000 - 55,000; Full time

Job summary

Optimum Media is seeking a Data Engineer Intern to support data pipelines, data infrastructure, and analytical solutions. You will work with Data Engineering and Data Analytics teams to ingest, process, and manage data across systems.

The role emphasizes hands-on experience with our data platform, ETL/ELT processes, and improving data quality and pipeline reliability while collaborating with cross-functional teams.

Qualifications

• SQL programming and data manipulation skills.
• Python coding experience and debugging ability.
• Exposure to cloud data platforms (BigQuery, Redshift, Databricks).
• Familiarity with ETL/ELT concepts and data workflows.
• Strong problem solving and willingness to learn new tools.
• Ability to collaborate with technical and non-technical stakeholders.

Responsibilities

• Support development and maintenance of data pipelines and ETL/ELT processes.
• Work with large relational databases and data warehouses to support reporting.
• Write SQL queries and Python code for data structuring and validation.
• Aggregate, onboard, and investigate data from multiple sources; troubleshoot quality issues.
• Document data processes and architectures following engineering best practices.

Skills

SQL

Python

Cloud data platforms

ETL/ELT

Data analysis

Team collaboration

Tools

Google BigQuery

Snowflake

Databricks

AWS Redshift

PySpark

Job description

Optimum Media is seeking a Data Engineer Intern to support data pipelines, data infrastructure, and analytical solutions. You will work with Data Engineering and Data Analytics teams to ingest, process, and manage data across systems.

The role emphasizes hands-on experience with our data platform, ETL/ELT processes, and improving data quality and pipeline reliability while collaborating with cross-functional teams.