Data Engineer II, Sales Data Services (SDS)
Amazon Web Services
Analytics
AWS
Aws Glue
Big Data
Business Intelligence
Cloud
Cloud Computing
Cloud Data Warehouse
Cloud Operations
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Lake
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
Digital Marketing
ETL
Informatica
Information Technology (IT)
IT Services
Reporting and Analytics
Software Development
SQL
Job Description
Amazon Advertising’s Sales Data Services (SDS) team is hiring a Data Engineer II to build and support data warehouse and data lake infrastructure for pan-Amazon sales intelligence.
Responsibilities
- Design, implement, and support data warehouse and data lake infrastructure using AWS big data stack, Python, and Redshift
- Develop and manage ETLs to pull data from multiple data lakes and create a unified data model for analytics and reporting
- Enable self-serve analytics by supporting both technical and non-technical internal customers
- Provide ad-hoc reporting support as needed for internal stakeholders
- Build deep understanding of large data sources to determine which data to use, and when, to solve business problems
- Manage numerous concurrent requests, prioritizing strategically and collaborating across teams to deliver results
- Mentor other engineers, contribute to positive team culture, and help grow the team
Requirements
- 3+ years of data engineering experience
- 1+ years developing and operating large-scale data structures for BI analytics using ETL/ELT processes
- 1+ years developing and operating large-scale data structures for BI analytics using OLAP technologies
- 1+ years developing and operating large-scale data structures for BI analytics using data modeling
- 1+ years developing and operating large-scale data structures for BI analytics using SQL
- 1+ years developing and operating large-scale data structures for BI analytics using Oracle
- 3+ years of in the job offered or a related occupation experience
- 1+ years developing and operating large-scale BI data structures using each: ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform)
- Bachelor’s degree (or foreign equivalent) in Computer Science, Engineering, Information Systems, Mathematics, or a related field
- Experience with data modeling, warehousing, and building ETL pipelines
Technologies
- AWS
- Python
- Redshift
- ETL
- ELT
- OLAP
- SQL
- Oracle
- Data warehouse, data lake, data modeling, data warehousing
- ETL pipelines
- S3
- AWS Glue
- EMR
- Kinesis
- FireHose
- Lambda
- IAM
Benefits
- Sign-on payments
- Restricted stock units (RSUs)
- Health insurance (medical, dental, vision, prescription)
- Basic Life & AD&D insurance
- 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
Preferred Qualifications
- Experience with AWS technologies such as Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
- Experience with non-relational databases/data stores, including object storage, document or key-value stores, graph databases, or column-family databases
Location: Seattle, WA (onsite)
Compensation: USD 132,100 - 178,800 per year
Similar Jobs
