Data Engineer III

Job Description

Who We Are 

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 an Analytics Engineering Architect, you will be responsible for leading 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. You will establish standards for data transformation, testing, and documentation while partnering with leadership to align analytics initiatives with business objectives. 

What You'll Do

(40%) Design and Implement Enterprise Analytics 

• Architect and oversee implementation of enterprise-wide data modeling strategies in Snowflake  

• Define and maintain dbt modeling standards and best practices across the organization  

• Design scalable solutions for complex analytical problems spanning multiple data domains  

• Lead the development and implementation of reusable analytics frameworks and components  

• Drive implementation of advanced performance optimization strategies for large-scale data transformations  

(30%) Technical Leadership and Innovation 

• Partner with leadership to align analytics initiatives with business objectives  

• Drive adoption of modern engineering tools with emphasis on dbt development practices  

• Establish best practices for engineering across the organization  

• Evaluate and recommend new technologies and approaches to improve capabilities  

• Lead technical discussions and decision-making with executives, bridging engineering teams and stakeholders 

(15%) Visualization Development and Strategy 

• Lead the design and implementation of enterprise-wide visualization solutions  

• Establish visualization standards and best practices across the organization  

• Architect scalable and performant dashboard solutions  

• Optimize data models and queries for visualization performance  

• Guide the development of interactive analytics applications  

• Ensure visualizations effectively communicate business insights

(15%) Team Leadership and Mentorship  

• Mentor and guide junior analytics engineers in dbt development and analytics engineering best practices 

• Review and approve technical designs and perform code reviews 

• Foster a culture of innovation and continuous improvement within the team 

• Lead knowledge sharing initiatives and internal training programs 

Qualifications: 

• Bachelor’s degree in computer science, Statistics, Mathematics, or related field 

• 10+ years of experience in analytics, data engineering, or related field  

Experience with dbt with expertise in: 

• Package development and dependency management 

• Custom macro development 

• Testing framework implementation 

• CI/CD pipeline integration 

• Expert-level knowledge of data modeling, dimensional design, and analytics engineering best practices  

• Advanced proficiency in SQL and Python  

• Proven experience leading and mentoring technical teams  

• Excellence in stakeholder management and technical communication  

• Track record of successfully delivering enterprise-scale solutions 

Proven expertise in data visualization development, including:  

• Experience building enterprise-scale dashboards 

• Strong understanding of data visualization best practices 

• Expertise in visual design principles and data storytelling 

• Experience with multiple visualization platforms 

Minimum 3 years of experience with Snowflake, including:  

• Performance optimization and query tuning 

• Security and access control implementation 

• Resource monitoring and cost optimization 

• Data warehouse architecture design 

Preferred skills: 

• Prior experience with marketing and advertising data 

• Experience with Streamlit for building data visualizations & applications 

• Knowledge of other modern data visualization frameworks (D3.js, Plotly, etc.) 

• Familiarity with machine learning visualization techniques 

• Building pipelines in support of chat applications 

• Publishing applications to Snowflake’s marketplace 

 #LI-KG1

#LI-HYBRID

#HM

The statements herein are intended to describe the general nature and level of work being performed by employees and are not to be construed as an exhaustive list of responsibilities, duties and skills required of personnel so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the employer. 

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.