Data Engineer, AWS GDSP A&I

Amazon Web Services (AWS); Seattle (WA); On-site; USD 132,100 - 178,800; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Parental leave

Job summary

Amazon Web Services, Inc. is seeking a Data Engineer to design and maintain scalable data solutions that support metrics, reports, and dashboards for the Private Pricing Program. You will collaborate with business leaders and engineering teams to deliver data-driven insights and enable self-service analytics.

The role requires strong SQL, data modeling, ETL/ELT, and experience with AWS data services. You will help build production-grade data pipelines and contribute to data quality and

Qualifications

• 3+ years of data engineering experience.
• 1+ years building and operating large-scale BI data structures using ETL/ELT processes.
• 1+ years building and operating large-scale BI data structures using OLAP technologies.
• 1+ years building and operating large-scale BI data structures using data modeling.
• 1+ years building and operating large-scale BI data structures using SQL.
• 1+ years building and operating large-scale BI data structures using Oracle.
• Experience with data modeling, warehousing and ETL pipelines.

Responsibilities

• Design, develop, and maintain scalable data solutions for metrics, reports, analyses, and dashboards.
• Collaborate with technology teams to extract, transform, and load data from diverse sources using AWS services and internal tools.
• Build and deliver high-quality datasets that support data science initiatives and customer reporting requirements.
• Automate and optimize reporting processes to enable self-service analytics for stakeholders.
• Translate business problems into technical analysis requirements.
• Apply analytical rigor to answer business questions and drive data-driven decisions.
• Develop measurement frameworks that quantify customer experience and drive outcomes.
• Create queries and visualizations for ad-hoc requests and ongoing reporting needs.
• Write efficient, optimized queries with deep knowledge of data structures.
• Adopt best practices in reporting including data integrity and documentation.
• Troubleshoot data quality issues and audit pipelines and queries.

Skills

Data engineering

ETL/ELT

OLAP

Data modeling

SQL

Oracle

Tools

AWS Redshift

S3

AWS Glue

EMR

Kinesis

Firehose

Lambda

IAM

Non-relational databases

Job description

Description Amazon Web Services (AWS) is a dynamic and rapidly growing business within Amazon and the leader in providing secure, reliable, scalable, and innovative services that help over a million businesses, governments, education, and not for profits across the globe scale and grow! AWS provides a wide set of scalable services to meet customer needs.

Amazon Web Services (AWS) is a dynamic and rapidly growing business within Amazon and the leader in providing secure, reliable, scalable, and innovative services that help over a million businesses, governments, education, and not for profits across the globe scale and grow! AWS provides a wide set of scalable services to meet customer needs. At AWS, the Global Deal Strategy and Programs (GDSP) team drives cloud adoption and business growth through innovative pricing strategies. The organization comprises two specialized teams: Strategic Customer Engagements, which guide transformative deals with industry leaders, and Private Pricing Programs & Experiences, which scales and optimizes pricing solutions across our diverse customer base. Within GDSP, you will develop deep expertise in cloud economics, hone your strategic thinking, and directly impact AWS's market leadership while working with latest technologies and global clients.

The AWS Global Deal Strategy and Programs (GDSP) organization is responsible for the Private Pricing Program. The Private Pricing Analytics and Insights (PPA&I) team owns building scalable analytical solutions that enable the GDSP organization with actionable insights to make data-driven decisions. This role will focus on Data Engineering, and Analytics related to the Private Pricing Program, requiring deep technical skills, strong business acumen and a deep analytical background to provide actionable data-driven insights and decision support.

As a Data Engineer on this team, you will drive efficiency in data handling processes, setup product analytics, drive advanced analysis and build new metrics which are key inputs to improve the health, scale and growth of the Private Pricing Program. You will work collaboratively with the business leaders operations, and engineering teams on many non-standard and unique business problems and support business initiatives by collecting required and related data from external/internal sources.

The ideal candidate should have strong communication skills and ability to prioritize effectively to ensure timelines are met. You will own projects from engaging with customers to production and delivery of a suite of tools used by the organization to make key business decisions. You should be a self-starter, comfortable with ambiguity, able to think big and be creative (while still paying careful attention to detail). You think in terms of architecture, not just code. You proactively work to improve the consistency and integration between your team’s BI solutions and any related systems or artifacts.

Key job responsibilities

• Design, develop, and maintain scalable data solutions for metrics, reports, analyses, and dashboards that support analytical and business needs
• Collaborate with technology teams to extract, transform, and load data from diverse sources using AWS services and internal tools
• Build and deliver high-quality datasets that support data science initiatives and customer reporting requirements
• Automate and optimize reporting processes to enable self-service analytics for stakeholders
• Translate business problem statements into technical analysis requirements
• Apply analytical and statistical rigor to answer business questions and drive data-driven decisions
• Develop measurement frameworks that quantify customer experience and drive business outcomes
• Create queries and visualizations for ad-hoc requests, projects, and ongoing reporting needs
• Write efficient, optimized queries with deep knowledge of data structures and query optimization techniques
• Adopt best practices in reporting and analysis including data integrity, design, validation, and documentation
• Troubleshoot operational data quality issues and audit existing data pipelines and queries
• Recommend improvements to back-end data sources for increased accuracy and simplicity

Basic Qualifications

• 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

Preferred Qualifications

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

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including 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, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.

USA, NY, New York - 145,300.00 - 196,600.00 USD annually

USA, TX, Austin - 132,100.00 - 178,800.00 USD annually

USA, WA, Seattle - 132,100.00 - 178,800.00 USD annually

Company - Amazon Web Services, Inc.

Job ID: A10376397