Data Engineer II

Horizon Media

New York, NY

Full Time

Mid Level

140k-170k

14 days ago

Job Description

About the Role

Horizon Media, founded in 1989 and headquartered in New York City with offices in Los Angeles and Toronto, is recognized as an innovative marketing and advertising firm. Known for its highly personal approach to client service and an incredible culture, Horizon is committed to building an environment of belonging where employees feel welcomed, safe, and empowered. The company values diverse perspectives and offers talented individuals opportunities to grow within a supportive and inclusive workplace.

Key Responsibilities

Assist in the development and maintenance of ETL/ELT pipelines using Spark (Java) and Python.
Work with relational databases (e.g., PostgreSQL, MySQL, SQL Server) to extract, transform, and load data.
Monitor data pipelines and troubleshoot data quality and performance issues.
Support integration of media performance data from various sources (e.g., ad servers, DSPs, third-party analytics).
Collaborate with stakeholders to understand data needs and support analytics workflows.
Contribute to documentation of data sources, data models, and technical processes.

Requirements

Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
1-3 years of hands-on experience with relational database management systems (RDBMS) and writing efficient SQL queries.
Experience with Python for data manipulation and scripting.
Experience with Apache Spark using Java or PySpark (core development and optimization).
Familiarity with data modeling, ETL concepts, and big data processing.
Strong problem-solving and analytical skills.
Attention to detail and a proactive approach to debugging and resolving issues.
Effective communication and collaboration skills.
Willingness to learn and adapt in a fast-paced environment.

Nice to Have

Experience in the media/advertising industry or handling marketing/media datasets.
Familiarity with cloud data platforms (e.g., AWS, GCP, Azure).
Exposure to workflow orchestration tools (e.g., Airflow, Dagster).

Qualifications

Formal educational background in relevant fields such as Computer Science, Engineering, or Information Systems.

Benefits & Perks

Competitive salary range of $140,000.00 - $170,000.00, with actual salary based on skills and experience.
Discretionary bonus and a variety of benefits including health insurance coverage.
Life and disability insurance.
Retirement savings plans.
Company paid holidays and unlimited paid time off (PTO).
Mental health and wellness resources.
Pet insurance, childcare resources, identity theft insurance, fertility assistance programs, and fitness reimbursement.

Working at Horizon Media

Horizon Media prides itself on its celebrated and inclusive workplace culture. The company believes in the talent of its people and the power of personal connection, fostering an environment where diversity of perspectives is valued. Horizon is committed to equal employment opportunity and creating a supportive, empowering space for all employees.

Apply Now