×
Register Here to Apply for Jobs or Post Jobs. X

Support Engineer, LMAQ-DE

Job in San Francisco, San Francisco County, California, 94199, USA
Listing for: Amazon
Full Time position
Listed on 2026-02-20
Job specializations:
  • IT/Tech
    Data Engineer, Cloud Computing
Salary/Wage Range or Industry Benchmark: 60000 - 80000 USD Yearly USD 60000.00 80000.00 YEAR
Job Description & How to Apply Below

The Last Mile Org focuses on technology, products, and programs that enable the efficient, safe, and customer-friendly delivery of packages. The DE team within LMAQ builds and maintains the data ecosystem comprises scalable data infrastructure, data pipelines, datasets and tools for Geospatial, Hub, DTO and Safety Orgs. The BIE, Tech, Product, Program teams of these orgs use this ecosystem to generate reporting, analyses, deep dives that create roadmap for last mile products and processes.

The data engineering support role focus on providing on-call support, troubleshooting and investigating tickets, conducting root cause analyses, and improving operational health. They are also responsible for fixing issues, communicating with stakeholders, and proactively monitoring alarms and metrics to ensure the overall health of the services they support.

Key Job Responsibilities
  • Monitor & Optimise Redshift clusters:
    Monitor Amazon Redshift clusters, identify long-running queries, and optimize them to maintain cluster performance and ensure healthy operational state
  • Monitor Data Pipelines & ETL Jobs
    • a. Continuously monitor Glue, Airflow, Lambda, Redshift, Spark, EMR and Kinesis jobs.
    • b. Identify failures, performance degradation, or bottlenecks in real time.
  • Troubleshoot Data Pipeline Failures
    • a. Diagnose issues in extraction, transformation, loading, schema mismatches, and data quality.
    • b. Perform impact analysis and apply immediate fixes.
  • Provide continuous support of existing data engineering products/tools/platforms/solutions that DE built and even extend them for new use cases onboard.
  • Handle On-Call / Incident Response
    • a. Own the end-to-end on-call rotation, respond to Pager Duty alerts, and restore systems within SLA.
    • b. Work directly with data engineering teams to resolve critical incidents.
  • Conduct Root Cause Analysis (RCA)
    • a. Perform RCA for every major incident.
    • b. Document findings and propose long-term preventive solutions.
  • Manage Data Quality & Validation
    • a. Validate accuracy, completeness, freshness, lineage, and schema consistency.
  • Optimize Queries & Performance
    • a. Optimize inefficient SQL (Athena/Redshift/Presto/Spark).
    • b. Tune warehouse performance, resolve WLM queue issues, and reduce compute cost.
  • Maintain Metadata, Catalogs & Schemas
    • a. Manage Glue Catalog, partition refresh, schema evolution, table permissions, and lineage.
    • b. Ensure smooth integration between S3, Glue, Athena, Redshift, and Lake Formation.
  • Support Deployments & Release Management
    • a. Assist in promoting ETL jobs, model code, and pipeline configurations through CI/CD.
    • b. Validate deployments and perform rollback when necessary.
  • Collaborate with BI, Product & Stakeholders
    • a. Work with BI teams, analysts, PMs, and upstream/downstream owners.
    • b. Provide data accessibility support & answer data troubleshooting queries.
  • Maintain Documentation & SOPs
    • a. Maintain playbooks, runbooks, troubleshooting guides, and data dictionaries.
    • b. Ensure knowledge transfer and training for new team members.
  • Basic Qualifications
    • 2+ years of scripting language experience
    • Strong SQL and debugging skills
    • AWS (S3, Glue, EMR, Lambda, Redshift, Athena)
    • Strong Python and Pyspark skills
    • Understanding of data modelling, ETL, and batch/streaming pipelines
    • Experience with version control and CI/CD (Git, Code Pipeline)
    • Good communication for stakeholder-facing troubleshooting
    • Good to have GenAI Skillset, but not mandatory
    Preferred Qualifications
    • Experience with AWS, networks and operating systems

    Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit (Use the "Apply for this Job" box below). for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

    Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

    #J-18808-Ljbffr
    To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
    (If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
     
     
     
    Search for further Jobs Here:
    (Try combinations for better Results! Or enter less keywords for broader Results)
    Location
    Increase/decrease your Search Radius (miles)

    Job Posting Language
    Employment Category
    Education (minimum level)
    Filters
    Education Level
    Experience Level (years)
    Posted in last:
    Salary