Job Description
About Horizon Commerce
Horizon Commerce helps brands navigate and succeed in an increasingly complex retail media and ecommerce ecosystem. We combine advanced analytics, retail media intelligence, and proprietary technology to help clients measure incrementality, optimize investment decisions, and drive sustainable growth across major retail platforms. We value collaboration, ownership, and practical problem solving in a fast-paced, evolving environment.
Job Description Summary
The Data Solutions Engineer is responsible for designing, building, and maintaining scalable data pipelines and analytics models that support Horizon Commerce’s retail media and commerce intelligence platforms. This role focuses on data engineering and analytics enablement, partnering closely with analytics, product, and client-facing teams to ensure high-quality, reliable data used for measurement, forecasting, and optimization.
Key Responsibilities
- Design, implement, and maintain scalable data pipelines supporting retail media and ecommerce analytics platforms
- Develop and optimize dbt models and SQL transformations to ensure accuracy, consistency, and performance across datasets
- Manage data ingestion from multiple external sources, including APIs, retail media platforms, and third-party data providers
- Monitor and troubleshoot workflow orchestration systems (e.g., Airflow), ensuring reliable and timely data delivery
- Partner with analytics and product teams to translate business requirements into efficient data models and metrics definitions
- Manage cloud-based data infrastructure (e.g., AWS services, Airflow, Snowflake), including permissions, environments, and usage optimization
- Implement and maintain version control, documentation, and CI/CD practices for data workflows to support transparency and reproducibility
- Proactively identify and automate manual or repetitive data processes to improve reliability and reduce operational overhead
- Collaborate with client-facing analysts and engineers to publish verified datasets and enable reporting, forecasting, and client deliverables
- Ensure data quality, integrity, and compliance through consistent validation, monitoring, and security best practices
Qualifications
- 5-8 years of experience in data engineering, analytics engineering, or data platform roles
Experience identifying and automating manual data processes
- Exposure to infrastructure best practices such as CI/CD for data workflows
- Experience supporting data shares and client-facing data delivery workflows
- Experience maintaining or developing web scraping pipelines (e.g., Selenium)
- Experience working with retail media or ecommerce platform data (e.g., Amazon Ads, Walmart Connect, Target Roundel)
- Strong communication skills and the ability to explain technical concepts to cross-functional stakeholders
- Ability to operate independently and take ownership of critical production systems
- Experience using Git for version control and collaborative development workflows
- Experience managing service accounts, API credentials, and secure key-based authentication (e.g., public/private key management)
- Experience troubleshooting API integrations, authentication issues, schema changes, and pipeline failures
- Familiarity with AWS services supporting data platforms, including S3, Lambda, EC2, IAM roles, CloudWatch, and related infrastructure components
- Experience managing data ingestion processes such as Snowpipe or equivalent streaming/batch ingestion frameworks
- Advanced SQL skills and experience working with cloud data warehouses such as Snowflake, BigQuery, or Redshift
- Strong experience with dbt for data modeling, testing, and transformation best practices
- Experience working with ELT tools such as Fivetran and managing third-party data connectors
- Hands-on experience with workflow orchestration tools such as Airflow, including DAG management, scheduling, monitoring, and troubleshooting
- Strong proficiency in Python for building, maintaining, and troubleshooting production data pipelines
Preferred Qualifications
- Bachelor’s degree or equivalent experience in Computer Science, Data Science, Engineering, or a related quantitative field
- Experience working with retail media or ecommerce data
- Prior experience supporting client-facing analytics or consulting teams
- Experience with Git-based version control and collaborative development workflows
- Experience with analytics or business intelligence tools
- Familiarity with measurement concepts such as incrementality, attribution, and forecasting
- Familiarity with retail performance metrics such as ROAS, incremental revenue, and new-to-brand measurement
#LI-KG1
#LI-HYBRID
#HC
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
$140,000.00 - $170,000.00A 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.
Top Skills
What We Do
Horizon Media is a leader in driving business-based outcomes for marketers. The company was founded in 1989, is headquartered in New York, and has offices in Los Angeles and Toronto. With estimated billings of $8.7 billion and over 2,300 employees, Horizon is the third largest U.S. media agency according to COMvergence data. Recognized as one of the world’s ten most innovative marketing and advertising companies by Fast Company, Horizon Media has been named Media Agency of the Year by MediaPost, Adweek and AdAge and is known for its highly personal approach to client service. Renowned for its culture, Horizon is also consistently named to all the prestigious annual Best Places to Work lists published by Fortune, Forbes, AdAge, Crain’s New York Business and Los Angeles Business Journal; including “Best Workplaces for Diversity,” “Best Workplaces for Women,” and “Best Workplaces for Millennials” honors. Bill Koenigsberg, President, CEO and Founder of Horizon Media, has earned almost every industry accolade and, in 2019, garnered the marketing’s highest honor when he was inducted into the American Advertising Federation (AAF) Hall of Fame. TOGETHER WE'RE BUILDING A PLACE OF BELONGING At Horizon, diversity, equity and inclusion are pillars of our culture. Numerous studies show that a more diverse workplace benefits everyone in so many ways; employees, organizations and their clients. When people feel that they belong and are included, they become committed and feel empowered to be more innovative. And that is the workforce we strive to have. We welcome everyone and do not discriminate based on gender, race, religion, sexual orientation, age or disability. We want you to feel welcomed, safe and know that you’re a vital member of our community. For more information, visit: www.horizonmedia.com or www.horizonmedia.com/careers.
.png)
.png)
