VP, Architecture & Data Engineer

Horizon Media; New York (NY); On-site; USD 180,000 - 230,000; Full time

Job summary

An established industry player is seeking a Technical Data Engineer to lead the architecture and implementation of a modern data stack. This exciting role involves designing and optimizing data pipelines using cutting-edge technologies like dbt, Fivetran, and Snowflake. You will be at the forefront of data transformation initiatives, ensuring data quality and scalability while collaborating with cross-functional teams. This position offers a unique opportunity to drive innovation and analytical capabilities, all within a vibrant and supportive work environment. If you're passionate about data engineering and eager to make a significant impact, this is the perfect opportunity for you.

Benefits

Health insurance coverage

Life and disability insurance

Retirement savings plans

Unlimited paid time off (PTO)

Mental health and wellness resources

Pet insurance

Childcare resources

Identity theft insurance

Fertility assistance programs

Fitness reimbursement

Qualifications

• 5+ years of experience as a data engineer with expertise in dbt, Fivetran, and Snowflake.
• Strong knowledge of SQL and experience with data modeling concepts.

Responsibilities

• Architect and implement data pipelines using dbt, Fivetran, and Snowflake.
• Collaborate with analysts and scientists to translate business needs into technical specs.

Skills

dbt

Fivetran

Snowflake

SQL

Git

CI/CD

Python

AWS

Education

Bachelor's degree in Computer Science or related field

Tools

AWS

Git

CI/CD

Job description

Job Description

VP, Architecture & Data Engineer - Horizon Media

Overview
We are seeking an expert-level Technical Data Engineer to architect and implement our modern data stack at Horizon Media. This role will be responsible for designing, building, and optimizing our data pipelines using Snowflake, dbt, and Fivetran, while ensuring data quality, scalability, and business value. The ideal candidate will possess deep technical expertise and hands-on experience with these technologies to drive our data transformation initiatives.

Key Responsibilities

1. Architect and implement advanced data pipelines using dbt, Fivetran, and Snowflake to support analytics, reporting, and machine learning initiatives
2. Design and develop complex data models in dbt, implementing best practices for modularity, testing, and documentation
3. Configure and optimize Fivetran connectors for diverse data sources, ensuring efficient and reliable data ingestion
4. Implement sophisticated data transformation logic using Snowflake's native capabilities and dbt macros
5. Develop and maintain CI/CD pipelines for dbt projects, ensuring code quality through automated testing and deployment
6. Optimize query performance and resource utilization in Snowflake through careful warehouse sizing, materialization strategies, and query tuning
7. Implement data quality checks and monitoring across the entire data pipeline
8. Design and implement data versioning strategies to support multiple environments and enable seamless rollbacks
9. Collaborate with data analysts, data scientists, and business stakeholders to translate business requirements into technical specifications
10. Provide technical leadership and mentorship to junior data engineers on best practices and design patterns

Qualifications

1. 5+ years of hands-on experience as a data engineer with at least 3 years of deep expertise in dbt, Fivetran, and Snowflake
2. Advanced knowledge of SQL, including complex query optimization and performance tuning in Snowflake
3. Proven experience designing and implementing large-scale dbt projects, including custom macros, packages, and testing frameworks
4. Extensive experience configuring and troubleshooting Fivetran connectors for various data sources
5. Strong understanding of data modeling concepts (dimensional modeling, data vault, etc.) and their implementation in dbt
6. Experience with version control systems (Git) and CI/CD pipelines for data engineering workflows
7. Familiarity with Python or other programming languages for data processing and automation
8. Experience with data quality frameworks and implementation of testing strategies
9. Knowledge of cloud infrastructure (AWS preferred) and how it integrates with the modern data stack
10. Experience in media, advertising, or related industries preferred

Technical Skills

1. dbt: Advanced modeling, custom macros, packages, documentation, testing frameworks
2. Fivetran: Connector configuration, troubleshooting, custom transformations, API integration
3. Snowflake: Performance optimization, resource management, security configuration, stored procedures
4. SQL: Advanced query writing, performance tuning, window functions, optimization techniques
5. Git: Branch management, code review processes, collaborative development
6. CI/CD: Implementing automated testing and deployment for data pipelines
7. Python: Data processing, automation, custom connectors (beneficial)
8. AWS: S3, Lambda, Glue, and other data-related services (beneficial)

This role offers the opportunity to work at the cutting edge of data engineering, implementing best-in-class solutions using modern data stack technologies while driving innovation and analytical capabilities across Horizon Media's operations.

Salary Range

$180,000.00 - $230,000.00

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.