Data Engineer, Amazon PeopleInsights eXperience (APIX)

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.

As part of Amazon PeopleInsights eXperience (APIX) team at Amazon you will be part of the Data team that builds the foundational data infrastructure and analytics tools for people analytics capabilities. We create secure scalable PXT LakeHouse solutions that enable teams across PXT to access and analyze data effectively while maintaining data this role you will design build and maintain scalable data pipelines and infrastructure collaborate with product managers business intelligence engineers and HR business partners to transform complex HR Ops experience and engagement data into actionable insights that drive Amazons people strategy. Your technical expertise will help us make data-driven decisions that enhance the employee experience across Amazons global workforce.

Key job responsibilities
Key job responsibilities
In this role you will:
* Design and implement high performant and cost-efficient data lake infrastructure using AWS big data stack Spark Hive SQL Apache Airflow AWS Glue EMR S3 Redshift and OLAP technologies.
* Collaborate with Business Intelligence Engineers to recognize and help adopt best practices in building semantic layers in reporting and analysis optimize SQL queries for fast cost-efficient access.
* Follow software best practices including coding standards code reviews and testing for all related data processing systems.
* Work directly with customers to integrate new data types curate data profiles perform data quality checks and incorporate feedback.
* Empower technical and non-technical internal customers to drive their own analytics and reporting (self-serve reporting) and support ad-hoc data generation and reporting when needed.
* Be comfortable with a degree of ambiguity and willing to develop quick proof of concepts iterate and improve
* Actively support and foster a culture of inclusion.

A day in the life
Successful candidate should have experience working with big data building data lakes and data processing services experience with one or more query language (e.g. SQL PL/SQL HiveQL SparkSQL) and scripting language (e.g. Python Scala). They are effective at seeing data patterns and building generic data solutions to improve user experience.

About the team
The Amazon People Insights team transforms the creation and delivery of actionable people-centric insights for HR Operations and corporate leaders across Amazon - empowering efficient data-driven and timely workforce decisions aligned with Amazons objective to be Earths Best Employer.

- 3 years of data engineering experience
- 1 years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
- 1 years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies experience
- 1 years of developing and operating large-scale data structures for business intelligence analytics using data modeling experience
- 1 years of developing and operating large-scale data structures for business intelligence analytics using SQL experience
- 1 years of developing and operating large-scale data structures for business intelligence analytics using Oracle experience
- Experience with data modeling warehousing and building ETL pipelines

- 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)

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 - 132100.00 - 178800.00 USD annually