Senior Data Engineer II - Amex Ads, Offers, and Dining Technology

American Express
New York, Chicago
Workplace: OnsiteFull timeUSD 123,000 - 215,250 annuallyFunction: Solutions Engineering & Sales EngineeringExperience: 8+ yearsEducation: bachelorsSkills: ["Problem-solving","Communication","Stakeholder management","Cross-functional collaboration","Mentorship"]

Design, develop, and deliver scalable data pipelines and data architecture for dining analytics and reporting. Build reliable batch and incremental ETL/ELT workflows ingesting Rooam POS data from AWS S3 into Snowflake, transform it into analytics-ready datasets, and optimize Snowflake models for staging to business-ready layers. Ensure data quality with validation, monitoring, and alerting, partner cross-functionally across product and analytics teams, and lead technical discussions while mentoring engineers.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
American Express
American Express
2 days ago

Senior Data Engineer II - Amex Ads, Offers, and Dining Technology

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 4 hours agoStatus: Live

Job Summary

Design, develop, and deliver scalable data pipelines and data architecture for dining analytics and reporting. Build reliable batch and incremental ETL/ELT workflows ingesting Rooam POS data from AWS S3 into Snowflake, transform it into analytics-ready datasets, and optimize Snowflake models for staging to business-ready layers. Ensure data quality with validation, monitoring, and alerting, partner cross-functionally across product and analytics teams, and lead technical discussions while mentoring engineers.
Location: New York, Chicago
Workplace: Onsite
Employment Type: Full time
Job Function: Solutions Engineering & Sales Engineering
Seniority: Mid level

Key Responsibilities

  • •Lead the design, development, and implementation of scalable data pipelines and data architecture for dining analytics and downstream applications.
  • •Build and maintain batch and incremental ETL/ELT workflows, including ingesting Rooam POS data from AWS S3 into Snowflake.
  • •Design and optimize Snowflake data models across staging, curated, and business-ready layers to support reporting and operational use cases.
  • •Develop scalable data processing solutions using Python, SQL, and AWS services with performance, reliability, and maintainability in mind.
  • •Implement data quality validation, reconciliation, monitoring, and alerting; tune Snowflake performance and support governance with metadata, documentation, lineage, and secure access.

Pay and Benefits

Salary: USD 123,000 - 215,250 annually
Perks:Health InsuranceDentalVisionLife InsuranceDisability Insurance401kPaid Parental

Key Requirements

  • •8+ years of experience in data engineering, software engineering, or enterprise data platforms.
  • •Strong hands-on expertise in Snowflake, SQL (including advanced query optimization), Python, and ETL/ELT pipeline development and orchestration.
  • •Experience designing and implementing scalable data pipelines and cloud-based data integration solutions.
  • •Strong understanding of data warehousing, dimensional modeling, and modern data lake/lakehouse architectures.
  • •Experience with data quality frameworks, reconciliation, schema evolution, and production monitoring; familiarity with CI/CD, Git, and Infrastructure as Code is preferred.
Experience:8+ yearsData engineeringData warehousingEnterprise data platformsETL/ELTData pipelinesAWS cloud
Education:Bachelor's
Skills:Problem-solvingCommunicationStakeholder managementCross-functional collaborationMentorship
Languages:English
Tech Stack:SnowflakeSQLPythonAWSAWS S3ETLELTRooam POSData modelingDimensional modelingData warehousingData lakeLakehouseCI/CDGitInfrastructure as CodeObservabilityMetadataLineage

Company Brief

American Express
Provides global payment, credit, and travel-related financial services for consumers and businesses. Best known for its charge and credit cards, merchant payment network, and premium customer rewards and servicing.
Industry: Payments
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: New York City, United States
Founded: 1850
WebsiteLinkedIn