Data Engineer, Compensation, CPSA

Amazon • Seattle, WA

4d • $101,300 - $160,000 • Onsite

About The Position

Amazon Compensation Data team is looking for Data Engineer (DE) to join our team for modernizing data warehouses serving business intelligence, data science and AI customers globally. Your role will involve designing, implementing, and supporting scalable solutions for metadata management, data pipeline orchestration, ETL, data modelling and data visualization with the tools available from AWS – including Sage Maker Unified Studio, Redshift, Glue, S3, IAM, Cloudwatch, and Apache Airflow. As DE you will be managing data infrastructure, building automated CDK based solution. You will work with stakeholders to gather requirements for data logging, storing, transforming and reporting. The ideal candidate will be passionate about working with big data sets and have the expertise to utilize these datasets to answer business questions and drive for best-in-class analytics, dashboard design and new innovative approaches. The ideal candidate will be entrepreneurial and innovative, thriving on solving challenging, ambiguous problems.

Requirements

• 1+ years of data engineering experience
• Experience with data modeling, warehousing and building ETL pipelines
• Experience with SQL
• Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala)
• Experience with one or more scripting language (e.g., Python, KornShell)
• Bachelor's degree in Computer Science, Engineering, Statistics, Mathematics, Finance or related field.
• Hands on experience with Python/Scala, writing complex data transformations in spark and automating pipelines.
• Comfortable using AWS services such as EMR(Hive/Spark), Redshift, S3, Glue, Cloudformation.
• Experience in at least one modern scripting or programming language, such as Python, Java, Scala, or NodeJS

Nice To Haves

• Experience with big data technologies such as: Hadoop, Hive, Spark, EMR
• Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc.

Responsibilities

• Work on the modernization of one of compensation data warehouses serving customers globally.
• Architect scalable data infrastructure solutions.
• Partner with business, product, and data science teams to deliver analytics and insights that drive day-to-day decision-making across the organization.
• Build end-to-end systems from ideation, experimentation through production deployment.
• Design and implement AI agents that automate complex decisions.
• Work directly with customer teams to identify automation opportunities and measure impact.
• Own the full project lifecycle: data pipelines, deployment, and monitoring.

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
• sign-on payments
• restricted stock units (RSUs)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level