Data Engineer, PXT PeopleInsight

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 youve nodded along to any of these questions welcome to Amazon PeopleInsights eXperience (APIX) team! Were not just a team; were a dynamic cohort of engineers dedicated to leveraging innovations for Amazons PXT Business Analytics tools and software. Together we confront tangible challenges head-on poised to revolutionize customer experiences in unforeseen ways. Every day we embark on a journey of invention pioneering fresh solutions that shape tomorrows landscape.

We are currently seeking a talented and motivated Data this role you will be building data engineering 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. APIX 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 should have 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 Earths Best Employer.

- 1 years of data engineering experience
- 1 years of analyzing and interpreting data with Redshift Oracle NoSQL etc. experience
- Experience with data modeling warehousing and building ETL pipelines
- Knowledge of writing and optimizing SQL queries in a business environment with large-scale complex datasets
- Experience with one or more scripting language (e.g. Python KornShell Scala)

- Experience with any ETL tool like Informatica ODI SSIS BODI Datastage etc.
- Experience with big data processing technology (e.g. Hadoop or ApacheSpark) data warehouse technical architecture infrastructure components ETL and reporting/analytic tools and environments

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 for more information. If the country/region youre applying in isnt 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 WA Seattle - 101300.00 - 160000.00 USD annually