Data Engineer , Retail Consumables, CADE

Job summary
Amazon Retail Consumables Analytics & Data Engineering (CADE) team is looking for an experienced and technically skilled Data Engineer. Consumables is one of the pillars of amazon core retail and fastest growing business and the CADE team supports Data Warehousing and Data Engineering needs of Consumables organization. As a DE in this team, you will be responsible for developing the data architecture components that scales for the ever-evolving data needs. You will be instrumental in applying AWS data engineering service and tools offerings to solve challenging problems in big data processing, data warehouse design, and enabling self-service.

As a Data Engineer in the team you will focus on automation and optimization for all areas of DW/ETL maintenance and deployment. You will work closely with the Business Intelligence Engineers, Data Scientists, Software Development teams and other business stakeholders on many non-standard and unique business problems and use creative problem solving to deliver actionable output in data gathering, transformation, ingestion and storage. As a Data Engineer, you will mentoring other junior resources , provide technical leadership, lead data engineering initiatives and build end-to-end analytical solutions that are highly available, scalable, stable, secure, and cost-effective

A qualified candidate must have demonstrated ability to manage large-scale data modeling projects, identify requirements and tools, and build scalable data warehousing solution and manage AWS resources. Drive operational excellence by automation of processes and by the adoption of new technologies and best practices. If you love solving challenging problems and like to move fast in a growing and changing environment, this role is right fit for you. We use data to guide our decisions and we always push the technology and process boundaries of what is feasible on behalf of our customers. The most successful members of our team are obsessed with helping our customers in creative ways, bring clarity to ambiguity through data driven experimentation, and think big to build solution extensible enough to handle existing and upcoming use cases.

Basic Qualifications

B.S. degree in mathematics, statistics, computer science, Engineering or a similar quantitative field.

5+ Years of experience in Data Warehousing and Data Engineering domain

Demonstrated strength in SQL, data modeling, ETL development, and data warehousing

Experience working with cloud systems (AWS, Azure etc) , database technologies (Redshift , Oracle, SQL server, DynamoDB etc) and cloud services like EMR, Athena, Aurora, Kinesis, Lambda, S3, EC2, etc.

Experience in maintaining data warehouse systems and working on large scale data transformation using EMR, Hadoop, Hive, or other Big Data technologies

Experience in working and delivering end-to-end projects independently.



Programming experience in languages like Python, Ruby, Java etc

Preferred Qualifications

· Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations
· Experience working with AWS tools like Redshift, S3, EMR, Lambda etc is a plus.
· Proven success in communicating with users, other technical teams, and senior management to collect requirements, describe data modeling decisions and data engineering strategy.
· Experience providing technical leadership and mentoring other engineers for best practices on data engineering.

The base pay range for this position is $132,100 - 178,800 per year. Pay is based on market location and may vary depending on job-related knowledge, skills, and experience. A sign-on payment and restricted stock units may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered. Applicants should apply via Amazon's internal or external careers site.






Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.