Wait, What Do You Do?

Pay: $35/hourLocation-specific pay — pay source
Applicants for employment with The Company will never be asked to provide money (even if reimbursable) as part of the job application or hiring process. Please review our Fraud FAQ for further details. 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.
Read the full posting

What you’ll work on

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.
Write SQL queries & Python code for data structuring, data validation, process automation, and data engineering workflows.

From the employer’s posting

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.

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.

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.

See how this role fits your experience

Add your resume to compare the role’s scope, tools and requirements with your experience.

Upload resume Add LinkedIn

Work setup and employment type unconfirmed

Not confirmed in this saved copy: work setup, employment type. Check the full posting

Tools in this posting

bash
python
sql
aws
bigquery
databricks

Source

- 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

- 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.

- 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

- 1-2 Years minimum relevant working experience, preferred - Intermediate SQL programming skills, including working with relational databases, data manipulation, and data transformation - Comfortable reading, writing, troubleshooting, and understanding Python code

- 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

- 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.

- 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

- 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

All 10 tools

Find answers in the posting

Already applied? Track this application

About applying

Apply opens the employer’s site in a new tab. Add your outcome here after you submit.

Source details & eligibility

Before you apply

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

Applicants for employment with The Company will never be asked to provide money (even if reimbursable) as part of the job application or hiring process. Please review our Fraud FAQ for further details. 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.

Location & working pattern

Long Island City, NY, US, 11101

Working pattern and location restrictions need checking in the full posting.

Work authorization

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. Applicants for employment with The Company will never be asked to provide money (even if reimbursable) as part of the job application or hiring process. Please review our Fraud FAQ for further details.

More source context

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.

Open source at www.optimumcareers.com ↗Read the full description ↓

Posting history

Status in our records: Active
First seen by us: Sep 10, 2026
Recorded sightings: 5

These dates show when we found the listing. Check the employer’s website to confirm it is still accepting applications.

Report an error

Skills in this posting

bashpythonsqlawsbigquerydatabricksredshiftsnowflakesparkpyspark

Job description

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 are seeking 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
1-2 Years minimum relevant working experience, 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.

Applicants for employment with The Company will never be asked to provide money (even if reimbursable) as part of the job application or hiring process. Please review our Fraud FAQ for further details.

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.