Data Engineer, PXT PeopleInsight

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 our PeopleInsights team! We're not just a team; we're a dynamic cohort of engineers dedicated to leveraging cutting-edge innovations for Amazon's PXT Business Analytics tools and software. Together, we confront tangible challenges head-on, poised to revolutionize customer experiences.
We are looking for experienced, self-driven Data Engineer. In this role, you will be building complex data engineering and business intelligence 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. You will provide guidance and support for other engineers with industry best practices and direction. PeopleInsight (PI) has culture of data-driven decision-making, and demands timely, accurate, and actionable business insights. Key job responsibilities
In this role you will:
- 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. A day in the life
Successful candidate would have experience working with big data, building data warehouses and data processing services. They are effective at seeing data patterns and building generic data solutions to improve user experience. About the team
Our mission is to harness the power of people data to empower PXT and people leaders to make decisions that help Amazon become the Earth’s Best Employer. We are open to hiring candidates to work out of one of the following locations: Seattle, WA, USA

BASIC QUALIFICATIONS

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