Data Engineer II

Amazon.com Services LLC seeks a Data Engineer II to design, build, and operate production SQL data pipelines in a cloud data warehouse, while contributing to a semantic layer that enables AI driven analytics at enterprise scale.

Location

Bellevue, WA (onsite)

Compensation

USD 132,100 - 178,800 per year

Responsibilities

• Design, implement, and operate production SQL pipelines in a cloud data warehouse to handle large volumes of daily operational data with reliability, freshness, and observability.
• Model entity schemas, define metric formulas, and own end-to-end data lineage from raw sources through transformations to consumption.
• Ship features across backend services and frontend UI for the team's tools, enabling data capture, review, and action at the source.
• Contribute to a semantic layer encoding business context for AI agents to consume.
• Collaborate with business stakeholders to translate operational expertise into structured, machine-readable definitions.
• Own the operational health of what you build, including production alerts, on-call responsibilities, ticket intake, and access controls such as row-level security, plus pipeline observability.
• Design, build, and operate production data pipelines that process daily operational data from multiple upstream sources with strong reliability and observability.
• Ensure downstream consumers and AI agents can trust numbers by maintaining end-to-end data lineage from source to consumption.
• Contribute to full-stack web applications used by business teams, shipping features across backend services and frontend UI to make data captureable, reviewable, and actionable at the source.
• Extend the semantic layer with version-controlled definitions of metrics, entities, relationships, and business context so operational knowledge lives in code and can be consumed by AI agents and LLM-based tools.
• Partner with business stakeholders to translate domain knowledge into structured, machine-readable definitions and tables.
• Continuously seek opportunities to reduce manual analysis by moving the platform toward natural language interfaces, richer entity relationships, and more autonomous investigation.
• Explore emerging techniques in semantic data modeling, knowledge representation, retrieval, and prompt engineering to improve how AI systems reason over our data.
• Write design docs, scope documents, and runbooks that make the team's work reviewable, maintainable, and durable.

Requirements

• 3+ years of data engineering experience.
• Bachelor's degree or above in Computer Science, Computer Engineering, Data Science, Electrical Engineering, or related fields, or 3+ years of professional software development experience.
• Experience with one or more object oriented programming languages (for example Java, C/C++, Python).
• Experience with data warehouse technical architectures, data modeling, infrastructure components, ETL/ELT and reporting/analytic tools and environments, data structures, and hands-on SQL coding.
• Experience with Redshift, Oracle, NoSQL, etc.

Technologies

• SQL
• Python
• Java
• C
• C++
• Redshift
• Oracle
• NoSQL
• S3
• AWS Glue
• EMR
• Kinesis
• FireHose
• Lambda
• IAM

Benefits

• Health insurance
• 401(k) matching
• Paid time off
• Parental leave