Data Engineer

The Data Engineer is responsible for building, maintaining, and optimizing Broadway Direct’s data infrastructure. This role ensures reliable data pipelines, high data integrity, and scalable systems that support ticketing, marketing, CRM, and reporting across the organization. The Data Engineer will own data architecture across Snowflake, Salesforce, and AWS, leveraging tools such as Fivetran for ingestion, dbt for transformation, and HighTouch for reverse ETL and operational activation. This role partners closely with analytics, marketing, and ticketing teams to enable data-driven decision making. While some operational data tasks are supported by a Data Engineering Intern, this role is accountable for designing systems that reduce manual work, improve reliability, and scale efficiently.

Data Infrastructure & Pipeline Engineering

• Design, build, and operate scalable data pipelines across Salesforce, Data Warehouse, and external systems
• 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 warehouse 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

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.

The main office is centrally located in the Theatre District. Works hours are Monday through Friday, 10am to 6pm. This position works in a professional, high-paced office environment.

This position is a full-time exempt. Ability to work some evenings and weekends may be required.  A standard company confidentiality agreement/NDA is required.

While performing the duties related to this job, the employee is regularly required to have visual acuity, talk, and hear while communicating with executives and other staff members. This position requires sitting, standing, bending, and walking. The employee may occasionally be asked to lift and/or move items up to 10 pounds.

This job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee. Other duties, responsibilities and activities may change or be assigned at any time with or without notice.

Employment for this position may be contingent on passing a skills test.

Nederlander has been a family-owned purveyor of live entertainment since 1912.  We operate historic theaters, produce,, and present the best in theatrical and concert events, and innovate new ways to engage future generations of theatergoers.

Broadway Direct is a national consumer brand that is an official and trusted source for all things Broadway.  Broadway Direct presents its customers with relevant Broadway news as well as informing consumers where to purchase authentic tickets online for any Broadway show in NYC and Broadway shows on tour across the country.

Broadway Direct was founded by the Nederlander Producing Company of America. Nederlander owns and/or operates nine Broadway Theatres in New York City including the Richard Rodgers Theatre (HAMILTON), The Gershwin Theatre (WICKED) and The Minskoff Theatre (THE LION KING).

The Nederlander Organization and Broadway Direct are committed to a workplace where everyone is free from bias, prejudice, discrimination, and harassment.  The organization strives to ensure a welcoming work environment where everyone belongs and is valued, encouraged & respected for their unique contributions. We are focused on building a culture that acknowledges and values Diversity, Equity, and Inclusion.

Nederlander Productions and its Affiliates provide equal employment opportunities. Discrimination of any type will not be tolerated. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex national origin, sexual orientation, gender identity, disability, protected veteran status or any other characteristics protected by state, federal and local law. Nederlander Productions employees take part in yearly Anti-discrimination, Anti-harassment, DEIB, Anti-Bullying training and Anti-Racism training.