Data Engineer II, AFX - AWS Investments

- The role requires a bachelor's or master's degree along with extensive experience in data engineering, analysis, warehousing and modeling.
- Strong skills in SQL, NoSQL, Redshift and Oracle are essential. A minimum of 2 years of data analysis and 3 years of engineering experience is expected. Candidates should have experience delivering end-to-end projects independently, programming in modern languages, and designing systems from the ground up. Excellent knowledge of data warehousing concepts, large datasets, and performance tuning is important. Experience gathering requirements and defining business metrics for reporting is also required. Strong communication and presentation abilities are necessary to interface with business and technical teams.
- - Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
- - Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)
- - Prior experience in programming using Python

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.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $118,900/year in our lowest geographic market up to $205,600/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.
AWS Sales, Marketing, and Global Services (SMGS) is responsible for driving revenue, adoption, and growth from the largest and fastest growing small- and mid-market accounts to enterprise-level customers including public sector. The AWS Global Support team interacts with leading companies and believes that world-class support is critical to customer success. AWS Support also partners with a global list of customers that are building mission-critical applications on top of AWS services.

Amazon Web Services (AWS) is looking for an innovative and passionate data engineer to architect and build new capabilities for our AWS Investments Platform. A singular goal of this platform is to provide our field personnel with secure, highly available, scalable and performant solutions and services so that they can continue to provide excellent service to our customers. You will have the opportunity to join a dynamic team with diverse skill sets, be able to influence our technical direction and build exciting new capabilities that operate at Amazon scale.

We are looking for a hands-on Data Engineer with experience developing and delivering data platforms as we build the next iteration of our system. Come join a team at the beginning of a product life cycle and help define the way AWS does business with its key customers. As a Data Engineer in this team, you will be working on building and maintaining complex data pipelines, assembling large and complex datasets to generate business insights and to enable data driven decision-making. You will interface with several key stakeholders of this platform including our product, program leaders and with our key technical partners across AWS.

Core responsibilities may include:
- Design data schema and operate internal data warehouses and SQL/NOSQL database systems.
- Design data models, implement, automate, optimize and monitor data pipelines.
- Own the design, development and maintenance of ongoing metrics, reports, analytics, dashboards, etc. to drive key business decisions.
- Analyze and solve problems at their root, stepping back to understand the broader context.
- Manage Redshift/Spectrum/EMR infrastructure, and drive architectural plans and implementation for future data storage, reporting, and analytic solutions.
- Work on different AWS technologies such as S3, Redshift, Lambda, Glue, etc. to provide new capabilities and increase efficiency.
- Work on data lake platform and different components in the data lake such as Hadoop, Amazon S3 etc.
- Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
- Must possess strong verbal and written communication skills, be self-driven, and deliver high quality results in a fast-paced environment.
- Conduct rapid prototyping and proof of concepts.
- Conceptualize and develop automation tools for bench marking data collection and analytics.
- Interface with other teams to extract, transform, and load data from a wide variety of data sources using AWS big data technologies.

Inclusive Team Culture
Here at AWS, we embrace our differences. We are committed to furthering our culture of inclusion. We have ten employee-led affinity groups, reaching 40,000 employees in over 190 chapters globally. We have innovative benefit offerings, and host annual and ongoing learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences. Amazon’s culture of inclusion is reinforced within our 14 Leadership Principles, which remind team members to seek diverse perspectives, learn and be curious, and earn trust.

Work/Life Balance
Our team puts a high value on work-life balance. It isn’t about how many hours you spend at home or at work; it’s about the flow you establish that brings energy to both parts of your life. We believe striking the right balance between your personal and professional life is critical to life-long happiness and fulfillment. We offer flexibility in working hours and encourage you to find your own balance between your work and personal lives.

Mentorship & Career Growth
Our team is dedicated to supporting new members. We have a broad mix of experience levels and tenures, and we’re building an environment that celebrates knowledge sharing and mentorship. Our senior members enjoy one-on-one mentoring and thorough, but kind, code reviews. We care about your career growth and strive to assign projects based on what will help each team member develop into a better-rounded engineer and enable them to take on more complex tasks in the future.


Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the bias 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.






About the team
About AWS

Diverse Experiences
AWS values diverse experiences. Even if you do not meet all of the qualifications and skills listed in the job description, we encourage candidates to apply. If your career is just starting, hasn’t followed a traditional path, or includes alternative experiences, don’t let it stop you from applying.

Why AWS?
Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform. We pioneered cloud computing and never stopped innovating — that’s why customers from the most successful startups to Global 500 companies trust our robust suite of products and services to power their businesses.

Inclusive Team Culture
Here at AWS, it’s in our nature to learn and be curious. Our employee-led affinity groups foster a culture of inclusion that empower us to be proud of our differences. Ongoing events and learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences, inspire us to never stop embracing our uniqueness.

Mentorship & Career Growth
We’re continuously raising our performance bar as we strive to become Earth’s Best Employer. That’s why you’ll find endless knowledge-sharing, mentorship and other career-advancing resources here to help you develop into a better-rounded professional.

Work/Life Balance
We value work-life harmony. Achieving success at work should never come at the expense of sacrifices at home, which is why we strive for flexibility as part of our working culture. When we feel supported in the workplace and at home, there’s nothing we can’t achieve in the cloud.