Data Engineer Ii, Pxt Peopleinsight

• 3+ years of Data Engineering experience
• Experience with data modeling, warehousing and building ETL pipelines
• 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• 1+ years of experience with at least one of the modern programming language such as Python, JS, Java, Scala.

Are you driven by the excitement of unraveling intricate data puzzles? Does your DNA resonate with collaborative problem-solving? Do you thrive on witnessing the ripple effects of your contributions in the larger scheme of things? If you've nodded along to any of these questions, welcome to our PeopleInsights team! We're not just a team; we're a dynamic cohort of engineers dedicated to leveraging cutting-edge innovations for Amazon's PXT Business Analytics tools and software. Together, we confront tangible challenges head-on, poised to revolutionize customer experiences.
We are looking for experienced, self-driven Data Engineer. In this role, you will be building complex Data Engineering and business intelligence applications using AWS stack. You should have deep expertise and passion in working with large data sets, data visualization, building complex data processes, performance tuning, bringing data from disparate data stores and programmatically identifying patterns. You should have excellent business acumen and communication skills to be able to work with business owners to develop and define key business questions and requirements. You will provide guidance and support for other engineers with industry best practices and direction. PeopleInsight (PI) has culture of data-driven decision-making, and demands timely, accurate, and actionable business insights.
Key job responsibilities
In this role you will:

• Design, implement, and support business critical data warehouse / data lake infrastructure using AWS big data stack, Python, Redshift, Glue/lake formation, EMR/Spark/Scala, Athena etc in a stable, low cost model.
• Collaborate with Business Intelligence Engineers to recognize and help adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation
• Internalize our customer challenges and derive creative solutions which apply new and innovative technology.
• Work directly with customers to integrate new data types, equipment, and incorporate feedback.
• Empower technical and non-technical, internal customers to drive their own analytics and reporting (self-serve reporting) and support ad-hoc reporting when needed.
• Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers.
• Be comfortable with a degree of ambiguity and willing to develop quick proof of concepts, iterate and improve
• Apply software best practices including coding standards, code reviews, source control management, agile development, build processes, and testing.
• Actively support and foster a culture of inclusion.

A day in the life
Successful candidate would have extensive experience working with big data, building data warehouses and data processing services. They are effective at seeing data patterns and building generic data solutions to improve user experience.
About the team
Our mission is to harness the power of people data to empower PXT and people leaders to make decisions that help Amazon become the Earth’s Best Employer.
We are open to hiring candidates to work out of one of the following locations:
Seattle, WA, USA

• 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)
• Experience working on and delivering end to end projects independently.
• Knowledge of distributed systems as it pertains to data storage and computing

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 $105,700/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.

Health insurance