Data Engineer, AFT BI Content
Amazon.com Services LLC•3h ago
United StatesOnsite$101.3K–$160KFull-timeEntry Level1+ yrs exp
H-1B verified · 2310 LCAs
Top focus
Data EngineerVp DataData Warehouse Engineer
- Every day, millions of packages move through Amazon's fulfillment network, powered by robotics, machine learning
- massive data systems. The Amazon Fulfillment Technologies (AFT) Data Engineering team builds and operates the analytical data infrastructure behind this network. Our pipelines process billions of transactions daily from robotic fulfillment centers, powering productivity measurement, capacity planning
- operational decision-making tools used by leaders across 1,000+ sites globally. As a Data Engineer on this team, you will build and maintain data pipelines that transform raw operational signals (robotic pick/stow events, labor activity, shipment tracking) into reliable analytical datasets. You will work across Amazon's data stack including Redshift, Spark/EMR
- Amazon's internal data catalog (Andes) to deliver data that drives real-time and weekly business decisions at scale. Key job responsibilities * Build and maintain ETL/ELT pipelines that process fulfillment center operational data * Write and optimize SQL for complex analytical transformations in Redshift and Spark * Support data quality monitoring and respond to data pipeline incidents * Implement data models following established patterns (star schema, additive models) * Collaborate with Business Intelligence Engineers and scientists to understand data requirements * Document data pipelines, schemas
- lineage for team knowledge sharing * Support existing data infrastructure and assist with migrations to newer platforms A day in the life You will start your day checking pipeline health dashboards and addressing any overnight failures. You might spend the morning writing SQL to transform raw robotics data into productivity metrics, then pair with a senior engineer in the afternoon to design a new data model. You will participate in code reviews, contribute to on-call rotations
- work with business stakeholders to understand what questions they need data to answer. About the team Amazon Fulfillment Technologies (AFT) powers Amazon's global fulfillment network. We invent and deliver software, hardware
- data science solutions that orchestrate processes, robots, machines
- people. We harmonize the physical and virtual world so Amazon customers can get what they want, when they want it. The AFT Data Engineering team specifically owns the data pipelines and analytical tables that measure fulfillment center performance. Our data powers leadership decision-making from individual site managers to VP-level business reviews.
- Bachelor's degree in Computer Science, Computer Engineering, Information Technology
- related fields - 1+ years of data engineering experience - Experience with data modeling, warehousing and building ETL pipelines - Experience with one or more scripting language (e.g., Python, KornShell, Scala) - Experience with database, data warehouse or data lake solutions
- Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda
- IAM roles and permissions - Experience with big data technologies such as: Hadoop, Hive, Spark, EMR - Experience with data visualization software (e.g., AWS QuickSight or Tableau) or open-source project Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability
- other legally protected status. 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 https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner. The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications
- location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off
- parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits . USA, WA, Bellevue - 101,300.00 - 160,000.00 USD annually
Required skills
PythonSQLRedshiftSparkAWSETLdata modelingdata warehousingKinesisHadoopHiveEMRAWS Gluedata visualizationTableau