Senior Data Engineer II - Amex Ads, Offers, and Dining Technology
About The Position
The Senior Data Engineer II will lead the design, development, and implementation of scalable data pipelines and data architecture for dining analytics, reporting, and downstream business applications. The role focuses on ingesting Rooam point-of-sale data from AWS S3 into Snowflake, building reliable batch and incremental ETL/ELT workflows, and shaping data into analytics-ready datasets and business-ready layers. The engineer will develop and optimize data solutions using Python, SQL, Snowflake, and AWS services, while ensuring data quality, platform performance, reliability, and maintainability. The role works across Product, Business, Analytics, Architecture, and Engineering teams to define requirements and deliver scalable solutions. It also includes technical leadership, mentoring, engineering best practices, platform automation and observability, and support for enterprise data governance through metadata, documentation, lineage, and secure data access. The position is part of American Express Ads, Offers, and Dining Technology, which develops advertising, offers, and dining platforms to enhance the Membership experience. The team supports technology that connects diners, restaurants, and the broader American Express ecosystem. American Express describes its work model as onsite, hybrid, or fully virtual depending on the role and business needs; the specific arrangement for this position is not stated.
Requirements
- Bachelor's or Master's degree in Computer Science, Engineering, Information Systems, or a related field.
- At least 8 years of experience in Data Engineering, Software Engineering, or Enterprise Data Platforms.
- Strong hands-on expertise in Snowflake, SQL and advanced query optimization, and Python.
- Experience developing and orchestrating ETL/ELT pipelines.
- Experience designing and implementing scalable data pipelines and cloud-based data integration solutions.
- Strong understanding of data warehousing concepts, dimensional modeling, and modern data lake/lakehouse architectures.
- Experience implementing data quality frameworks, reconciliation processes, schema evolution handling, and production monitoring.
- Familiarity with CI/CD pipelines, Git, Infrastructure as Code, and automated deployment practices.
- Excellent problem-solving, communication, stakeholder management, and cross-functional collaboration skills.
- Proven ability to lead end-to-end delivery of enterprise-scale data engineering initiatives across multiple teams.
Responsibilities
- Lead the design, development, and implementation of scalable data pipelines and data architecture for dining analytics, reporting, and downstream business applications.
- Build and maintain reliable batch and incremental ETL/ELT workflows, including ingesting Rooam POS data from AWS S3 into Snowflake and transforming it into analytics-ready datasets.
- Design and optimize Snowflake data models, including staging, curated, and business-ready data layers.
- Develop scalable data processing solutions using Python, SQL, and AWS cloud services, ensuring performance, reliability, and maintainability.
- Implement data quality validation, reconciliation, monitoring, and alerting for Rooam POS data.
- Partner with Product, Business, Analytics, Architecture, and Engineering teams to define data requirements and deliver scalable data solutions.
- Optimize Snowflake performance by tuning SQL queries, optimizing storage strategies, and managing compute resources.
- Lead technical design discussions, mentor engineers, and promote engineering best practices across data engineering initiatives.
- Improve platform reliability through automation, CI/CD, observability, documentation, and operational excellence.
- Support enterprise data governance by maintaining metadata, documentation, lineage, and secure access to data assets.
Benefits
- Competitive base salaries
- Bonus incentives
- 6% company match on retirement savings plan
- Free financial coaching and financial well-being support
- Comprehensive medical, dental, vision, life insurance, and disability benefits
- Flexible working model, with hybrid, onsite, or virtual arrangements depending on role and business need
- 20+ weeks of paid parental leave for all parents, offered for pregnancy, adoption, or surrogacy
- Free access to global on-site wellness centers staffed with nurses and doctors, depending on location
- Free and confidential counseling support through the Healthy Minds program
- Career development and training opportunities
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
