Data Engineer

Job Category: Broadway Direct Requisition Number: DATAE001102

Posted: May 21, 2026

Full-Time

On-site

New York, NY 10036, USA

Description

Data Infrastructure & Pipeline Engineering

Design, build, and operate scalable data pipelines across Salesforce, Snowflake, and external systems (ticketing, lottery, partners)

Leverage Fivetran and API-based ingestion frameworks to standardize and automate data ingestion from third-party platforms

Own API, webhook and file-based ingestion systems (SFTP, third-party feeds), ensuring reliability and observability

Manage AWS infrastructure supporting data ingestion, processing, and orchestration

Data Warehouse & Modeling

Own Snowflake data architecture, including schema design, transformations, and data modeling

Develop and maintain transformation layers using dbt, including modular, testable, and well-documented models

Build canonical datasets and dimensional models supporting analytics, CRM, ticketing, and pricing

Optimize warehouse performance, cost, and scalability through clustering, partitioning, and query optimization

Manage schema evolution and deprecation of legacy data structures

Data Quality, Governance & Reliability

Establish data quality frameworks using dbt tests, monitoring tools, and pipeline validation checks to detect and resolve inconsistencies, duplication, and missing data

Implement automated validation, monitoring, and alerting across pipelines

Own data hygiene standards across customer, order, and transaction datasets

Automation & Systems Optimization

Develop Python-based workflows to automate ingestion, transformation, and operational processes

Reduce manual workflows through system design, tooling, and pipeline reliability improvements

Leverage HighTouch to operationalize data by syncing curated datasets back into Salesforce and other business systems

Partner with third-party developers to maintain ticket lottery systems

Continuously improve pipeline performance, latency, and failure recovery

Reporting & Data Enablement

Build and maintain data pipelines supporting core reporting (sales, marketing performance, partner reporting)

Enable downstream analytics and BI through clean, accessible, and well-modeled datasets

Dynamic Pricing Data Infrastructure & Modeling Support

Own the data infrastructure supporting dynamic pricing models

Design and maintain model-ready datasets across pricing, inventory, and demand signals using Snowflake and dbt

Partner with internal teams and external consultants to operationalize pricing models within Snowflake

Enable rapid iteration, backtesting, and deployment of pricing strategies

Qualifications

Expertise

Strong proficiency in SQL and advanced data modeling (dimensional + canonical)

Experience building and operating data pipelines using Python and modern data stack tools (Fivetran, dbt, HighTouch or similar)

Deep experience with Snowflake or similar cloud data warehouses

Experience working with CRM systems (Salesforce preferred)

Experience managing data infrastructure in AWS or similar cloud environments

Strong understanding of ETL/ELT design patterns, APIs, and distributed data systems

What Success Looks Like

Reliable, scalable data pipelines with minimal manual intervention

Improved data quality and reduced duplication/errors

Faster reporting and improved data accessibility across teams

Successful deployment and iteration of pricing models supported by robust data systems

Growth & Development Opportunities

Opportunity to lead data architecture strategy, build scalable infrastructure, and directly impact revenue through pricing optimization systems.

Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.