Data Engineer I, UTR PLanning Tech

Summary: Amazon is seeking a Data Engineer I to join the UTR Planning Tech team, which builds the data infrastructure for labor planning across various Amazon business lines. The role involves designing and implementing data models and ETL pipelines, building configuration-driven frameworks, and collaborating with various stakeholders to enhance data engineering workflows using AI. Responsibilities: - Design and implement physical data models and ETL pipelines using AWS services (Redshift, S3, EMR, Glue, Lambda) and Python-based orchestration (Airflow/MWAA) - Build configuration-driven data frameworks that replace repetitive custom code with reusable, declarative patterns for ingestion, transformation, and metric curation - Develop and optimize pipelines that ingest from multiple upstream sources, apply quality controls, and produce datasets that scientists and analysts use for labor planning decisions - Implement monitoring, alarming, and data quality controls using standardized data contracts. Measure and improve dataset quality - Build tooling that enables AI agents to interact with data engineering workflows: generating SQL, validating configurations, and executing pipeline operations through natural language interfaces - Collaborate with planning scientists, software engineers, BI engineers, and product managers to translate data requirements into reusable solutions - Write secure, testable, maintainable code. Get your data models, pipeline designs, and code reviewed. Document your solutions so others can maintain them - Participate in operational excellence practices: on-call rotations, COE reviews, and pipeline health monitoring Required Qualifications: - 1+ years of data engineering experience - Experience with data modeling, warehousing and building ETL pipelines - Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala) - Experience with one or more scripting language (e.g., Python, KornShell) Preferred Qualifications: - Experience with big data technologies such as: Hadoop, Hive, Spark, EMR - Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc Required Skills: Data engineering, ETL pipelines, AWS services Important Skills: Data modeling, Query languages, Scripting languages Nice-to-Have Skills: Operational excellence, Collaboration, Documentation Benefits: 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