Data Engineer, Amazon PeopleInsights eXperience (APIX)

Amazon • Seattle, WA

1d

About The Position

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.

Requirements

• 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

Nice To Haves

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

Responsibilities

• 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.

Benefits

• 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
• parental leave

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed