Data Engineering Consultant, Data Platform Engineering Team, WWPS U.S Federal ProServe

Amazon - Arlington, VA

Full-time - Mid Level

Arlington, VA

Sporting Goods, Hobby, Musical Instrument, Book, and Miscellaneous Retailers

About the position

The Data Engineering Consultant role within the Data Platform Engineering Team at AWS focuses on helping U.S. Federal agencies implement innovative cloud computing solutions. The position involves building complex data engineering and business intelligence applications using AWS technologies, with an emphasis on data visualization, performance tuning, and integration of disparate data sources. The consultant will work closely with business owners to define key business questions and provide guidance to other engineers, ensuring the delivery of actionable business insights.

Responsibilities

• Design, implement, and support data warehouse/data lake infrastructure using AWS big data stack, Python, Redshift, QuickSight, Glue/lake formation, EMR/Spark, Athena, etc.
• Develop and manage ETLs to source data from various financial, AWS networking, and operational systems and create a unified data model for analytics and reporting.
• Creation and support of real-time data pipelines built on AWS technologies including EMR, Glue, Redshift/Spectrum, and Athena.
• Collaborate with other Engineering teams, Product/Finance Managers/Analysts to implement advanced analytics algorithms that exploit our rich datasets for financial model development, statistical analysis, prediction, etc.
• Continual research of the latest big data and visualization technologies to provide new capabilities and increase efficiency.
• Use business intelligence and visualization software (e.g., QuickSight) to develop dashboards used by senior leadership.
• Empower technical and non-technical internal customers to drive their own analytics and reporting (self-serve reporting) and support ad-hoc reporting when needed.
• Work closely with team members to drive real-time model implementations for monitoring and alerting of risk systems.
• Manage numerous requests concurrently and strategically, prioritizing when necessary.
• Partner/collaborate across teams/roles to deliver results.
• Mentor other engineers, influence positively team culture, and help grow the team.

Requirements

• 3+ years of data engineering experience
• Experience with data modeling, warehousing, and building ETL pipelines
• Experience with SQL
• Bachelor's degree in computer science, engineering, analytics, mathematics, statistics, IT or equivalent

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)
• Master's degree in computer science, engineering, analytics, mathematics, statistics, IT or equivalent
• Prior experience in programming using Python

Benefits

• Mentorship and career growth opportunities
• Work-life balance initiatives
• Inclusive team culture
• Diverse experiences encouraged