Data Engineer II

Horizon media

New York, NY

Full Time

Mid Level

140k-170k

13 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 a strong company culture. The company values diverse perspectives, employee empowerment, and growth, and has been consistently named to prestigious Best Places to Work lists. The role of Data Engineer II involves supporting the design and implementation of enterprise-wide analytics solutions that transform raw data into actionable business insights, combining expertise in data architecture, visualization development, and analytics engineering to 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.

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 and writing efficient SQL queries.
Proficiency in Python for data manipulation and scripting.
Experience with Apache Spark using Java or PySpark for 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 with a bachelor's degree in a relevant field.

Benefits & Perks

Competitive salary range of $140,000.00 - $170,000.00.
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 inclusive and empowering culture, valuing authentic voices and diverse perspectives. The company emphasizes employee growth, challenge, and a supportive environment where talent is nurtured and recognized for their contributions.

Apply Now