Data Engineer, Amazon PeopleInsights eXperience (APIX)

DESCRIPTION

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 Amazon PeopleInsights eXperience (APIX) team! We're not just a team; we're a dynamic cohort of engineers dedicated to leveraging innovations for Amazon's 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 tomorrow's 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 integrity. In 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 Amazon's people strategy. Your technical expertise will help us make data-driven decisions that enhance the employee experience across Amazon's 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 Amazon’s objective to be Earth’s Best Employer.

BASIC QUALIFICATIONS

• 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

PREFERRED QUALIFICATIONS

• 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 https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner