Senior Data Engineer with DBT and Airflow-Onsite NYC

TITLE: Senior Data Platform Engineer w/DBT & Airflow
LOCATION: New York City (midtown)
HYBRID ONSITE 4 DAYS IN THE OFFICE
NO C2C 3RD PARTY VENDORS!!
NO RELOCATION!!

JOB DESCRIPTION:
EXPERIENCED DATA ENGINEER MUST HAVE HANDS ON EXPERIENCE WITH DEPLOYMENTS, DBT, AIRFLOW, PYTHON AND AWS.

The Data Platform Engineer will be responsible for the design, build, and maintenance of Company's data platforms used for both analytics and for the integration of business and customer-facing applications. This role plays a critical part in advancing cloud-native data architecture and enabling reliable, scalable analytics and production data use cases. The Data Platform Engineer will design, build, and operate core components of the enterprise data platform, including robust data pipelines, scalable cloud infrastructure, and optimized data models that power business intelligence and operational systems across the organization. This position requires strong hands-on engineering expertise along with the ability to contribute to platform-level architecture, ensuring the data ecosystem is performant, secure, and positioned to scale with evolving business needs.


Specific Functions/Activities  SUMMARY:

• Design, build, and maintain scalable, reliable AWS-based data architecture
• Develop and optimize production-grade Python data pipelines
• Own end-to-end ELT workflows using DBT and Apache Airflow
• Design, implement, and optimize data models to support analytics and operational reporting
• Improve platform reliability, observability, and performance across the data stack
• Contribute to architectural decisions for scalability, security, and cost optimization
• Partner with DevOps to implement CI/CD, infrastructure-as-code, and automated deployments
• Evaluate and recommend new technologies to evolve MSG's data platform

REQUIRED EXPERIENCE:

• 4-7 years experience building and maintaining production data pipelines
• 4 years Python development experience (production-grade code)
• 2 years experience with DBT
• 2 years experience with Apache Airflow (or equivalent orchestration tools)
• Strong SQL and data modeling expertise (dimensional normalized modeling)
• Hands-on experience with AWS data services (S3, Redshift, Glue, Athena, DynamoDB)
• Experience designing scalable data architectures in cloud environments
• Experience troubleshooting and supporting production systems
• Strong communication skills and ability to work directly with business stakeholders
• Bachelor's degree in Computer Science, Engineering, or related field

Preferred

• Infrastructure as Code (Terraform or CloudFormation)
• CI/CD and DevOps practices