Data Engineer, PXT PeopleInsight

Amazon • Seattle, WA

21h

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.

We are currently seeking a talented and motivated Data Engineer. In 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.

Requirements

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

Nice To Haves

• 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

Responsibilities

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

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