Amazon · amazon.jobs · checked today
Business Intelligence Engineer, eCS Data Engineering and Analytics
Are you interested in diving deep into the data and engineering the metrics model that drives continuous improvement for Amazon’s eCommerce systems? Do you have solid problem-solving abilities, metrics-driven decision making and want to solve problems with solutions that will meet the growing worldwide need for Amazon’s products? Then eCommerce Services is the team for you.
Skills, with evidence
- Data modelling
Experience with data modeling, warehousing and building ETL pipelines
must have - Python
Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
must have - SQL
Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
must have - Warehousing
Experience with data modeling, warehousing and building ETL pipelines
must have - AWS
Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
must have · not practised here - Data quality
Identifying data needs and driving data quality improvement projects.
- Dashboards & BI
- Experience with data visualization using Tableau, Quicksight, or similar tools
not practised here
Your plan
- The SQL screen: correct, then fast≈ 1 h
SQL · Data quality
- Average order value by countryFoundations
- Line items per orderFoundations
- Revenue by buyer countryFoundations
- Customers who never orderedFoundations
- Hiring funnel by roleFoundations
- Python: the data-wrangling round≈ 2 h
Python
- Clean spreadsheet headers into column namesFoundations
- Events normalization jobFoundations
- List the distinct composite keysFoundations
- Deduplicate rows, first one winsFoundations
- Render a byte count for humansFoundations
- Data modelling: the round most people fail≈ 2 h
Data modelling · Warehousing
- Marketplace core entitiesFoundations
- Cinema seat bookingFoundations
- City parking baysFoundations
- Dating app matchesFoundations
- Food delivery ordersFoundations
- Say it out loud≈ 1 h
15 drills · Foundations + Intermediate≈ 6 hours
Not covered by the plan: AWS, Dashboards & BI.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 7 dremoved the moment Amazon closes it