Data Engineer II

Job Description

Horizon Media, founded in 1989 by Bill Koenigsberg, is recognized as one of the most innovative marketing and advertising firms. We are headquartered in New York City, with offices in Los Angeles and Toronto. A leader in driving business solutions for marketers, Horizon is known for its highly personal approach to client service.  Renowned for its incredible culture, Horizon is consistently named to all the prestigious annual Best Places to Work lists published by Fortune, AdAge, Crain’s New York Business and Los Angeles Business Journal. Together we are building a place of belonging.

At Horizon, we understand the value that different perspectives can bring to our clients and culture, so we strive for an environment where our employees feel welcomed, safe and empowered. We value YOU and believe that your authentic voice and unique perspective allows us to create a more rewarding culture, and experience, together.

Our simple recipe for success? We hire talented people (thinkers, doers, dreamers, makers), challenge them and give them every opportunity to grow.

Job Summary

As a Data Engineer Level 2, you will be support the design and implementation of enterprise-wide analytics solutions that transform raw data into actionable business insights. This role combines deep expertise in data architecture, visualization development, and analytics engineering to create scalable solutions that enable data-driven decision-making across the organization.

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.

Qualifications

Required:

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

  • Python for data manipulation and scripting.

  • Apache Spark with 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).

#LI-KG1

#LI-HYBRID

#HM

Horizon Media is proud to be an equal opportunity workplace.  We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.

Salary Range

A successful applicant’s actual base salary may vary based on factors such as individual’s skill sets, experience, training, education,  licensure/certifications, and qualifications for the role.  As an organization, we take an aptitude and competency-based hiring approach.  We provide a competitive total rewards package including a 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.