Intern - Data Engineer
About The Position
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.
Requirements
- Bachelor's/Master’s Degree in Data Science/Statistics/Computer Science/Computer Engineering/Information Science/Mathematics or equivalent job experience
- 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
- Applicants must be authorized to work for ANY employer in the U.S.
Nice To Haves
- Graduate degree in related field, preferred
- 1-2 Years minimum relevant working experience, 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
- 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
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.
Benefits
- Pay is competitive and based on a number of job-related factors, including skills and experience.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Intern
