Data Engineer I

The CA Retail Analytics team powers data-driven decision-making for one of Amazon's fastest-growing retail organizations. We support critical business functions across 3P, Prime, Marketing, Finance, Cross Border Product, North America Language Experience, Supply Chain Excellence , Canada Customer and Seller Experience, Delivery Speed and Experience, and other emerging CA Stores initiatives. As CA's footprint expands, we're building the foundational data infrastructure to enable self-service analytics, GenAI integration, and proactive insights at scale.

We're seeking a Data Engineer who thrives on building scalable, reliable data systems that unlock business value. You are expected to architect and build large-scale, high-performance data integration and data models that power business-critical analytics across CA Stores. You'll design and implement robust data solutions that handle massive data volumes from our Data Warehouse and distributed software systems, enabling reporting, dashboards, and strategic decision-making for stakeholders across the organization. This is a foundational role where you'll transform CA's analytics from reactive, fragmented solutions into a systematic, scalable data architecture that serves as the backbone for current and future business needs.

Key job responsibilities
What You'll Do
Build Scalable Data Infrastructure
• Design and implement robust ETL/ELT pipelines using AWS technologies (Redshift, S3, Glue, EMR, Lambda) to consolidate and normalize data across CA program footprints
• Architect dimensional data models and semantic layers that enable self-service analytics and GenAI tools
• Develop automated data quality frameworks with monitoring, alerting, and anomaly detection to ensure data reliability

Drive Operational Excellence
• Optimize cluster performance and reduce IMR costs through systematic node assessment, query tuning, and resource management
• Eliminate technical debt by building centralized data models and eliminating duplicate pipelines, and implementing lifecycle management
• Establish data engineering best practices including version control, code reviews, testing frameworks, and comprehensive documentation

Enable Innovation & Self-Service
• Build AI-ready datasets with well-curated metadata and NLP-friendly schemas to support GenAI initiatives and conversational analytics
• Partner with BIEs, Data Scientists, and Product teams to deliver production-grade datasets that power strategic insights
• Create repeatable, extensible data products and frameworks that scale across multiple CA business domains

Above all you should be passionate about working with huge data sets and someone who loves to bring datasets together to answer business questions and drive change.

About the team
Amazon Canada Stores is scaling quickly, and current data solutions were not built for the level of cross-domain complexity we are now operating in. The impact will be visible in how quickly leaders can access consistent metrics, how efficiently teams build on shared datasets, and how sustainably we scale new initiatives.

Basic 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.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or 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 the employer's site 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, and 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, and parental leave. Learn more about our benefits at the employer's site.

USA, WA, Seattle - 101,300.00 - 160,000.00 USD annually