Job Analysis

Posted on Edited on Symbols count in article: 7.1k Reading time ≈ 6 mins.

Amazon

Assessments

Assessments

WORK STYLE ASSESSMENT

These assessments are centered around Amazon’s peculiar culture and Leadership Principles, and typically take 10-20 minutes to complete. In these assessments, we ask you to choose the extent to which a statement represents your work style. For instance, we may ask you which of the two statements “I like for things to be clearly structured,” or “I look forward to the opportunity to learn new things,” best describes you.

WORK SAMPLE SIMULATION

These assessments ask you to complete virtual tasks related to a specific position and typically take 20 minutes - one hour to complete. They may ask you to make decisions based on our Leadership Principles, complete activities critical to success at Amazon, and demonstrate your problem-solving, prioritization, and interpersonal abilities. Depending on the role you are applying for, the assessment may ask you to interpret data from a chart, answer a customer question, choose how to resolve an issue, multitask, or find the right information from multiple sources.

Tips

  • For any Software Development Engineer I & II applicants we recommend reviewing our Software Development Topics to help you prepare for technical evaluations and interviews. For all other roles, no advance preparation is required to complete the assessment(s). Just be yourself and do your best.
  • Some questions may ask about your work style. Try not to overthink them or spend too much time on any one question. We want to get to know the authentic you, as there are many types of successful people at Amazon.
  • Before starting your assessment, read any information provided carefully since things like timing, deadlines, and assessment types can vary depending on the team.

The formalities

  • Most assessments are conducted virtually unless administered as part of a hiring event or on-site interview day.
  • During your assessment, be in a quiet and comfortable place with no distractions.
  • Review provided instructions carefully, as some assessments must be completed by a particular date. If an assessment deadline is missed, we’re unable to grant extensions. Many assessments are also timed, so be sure to set aside an appropriate amount of time.
  • All assessments require the internet, have a computer with a reliable connection and access to email. You will be notified of any additional technical requirements in advance.
  • If you have any special requirements, questions or concerns, please reach out to us as we are committed to making reasonable provisions for all individuals.
  • Technical assistance is available for all assessments should you experience a disruption that you cannot resolve (e.g. assessment freezes or crashes). If an issue occurs, use the contact information provided in the assessment.
    We take your data privacy very seriously. To learn about how we store your results review our privacy policy.
    All assessments must be completed solely by the applicant.

After assessments

  • In most cases, you will be notified via email if we’re moving forward with your application. You can also check your status any time in our application portal.
  • After you complete the assessment, certain roles may require you to participate in a phone/virtual interview, or come on-site for an in-person interview, which allows us to dive deeper into your skills and experience to learn even more about you. To help prepare, explore our prep guides for phone and in-person interviews.

Phone Interview Questions:

  • Which leadership principles are the most important for this role?
  • What are the conventions for this group?
  • What are the popular abbreviations in this group?
  • The preferred dashboarding tool is QuickSight or Tableau?
  • The preferred data analysis type: predictions or visualizations?
  • What is the group members’ favorite framework and programming languages?

OA Questions

  • What do I need to prepare for the onsite interview?

Jeff Bezos Letter to Stakeholders

1998

  • Hire and Develop the Best
    • Will you admire this person?
    • Will this person raise the average level of effectiveness of the group they’re entering?
    • Along what dimension might this person be a superstar?

2003

  • Customer Obsession
  • Ownership
  • Think big: Long-term value > Short-term value
  • Earn Trust

2005

  • Dive Deep: math-based decision making
  • Dive Deep: judgement-based decision making

2016

  • Disagree and commit
  • Bias for Action

Business Intelligence Engineer - Prime Video Product and Tech Finance

Industry Research - Streaming
What does Business Intelligence Engineer do in Amazon?

Contact

Requirements

You will be responsible for end to end production of key business reporting to leadership on a weekly basis, building scalable data solutions to complex problems and performing ad-hoc deep dives to better understand and value performance metrics.

In doing so, you will partner with key stakeholders from Finance, Product and Tech as well as data engineering and analytics teams globally.

This opportunity is ideal for a driven individual who is passionate about technology, video entertainment and looking for a challenge in a high growth, new business environment.

Some of the key responsibilities of this role will include:

  • Business Reporting: Ownership of the end to end production of business review reporting; from developing and maintaining data structures, monitoring pipelines and building Tableau/QuickSight/Excel reports.
  • Business Translation: Gather business requirements and translate these into scalable solutions that work well within the overall data architecture.
  • Business Metrics: Providing informed analysis, insight and recommendations around our business metrics to drive optimization and more effective decision making.
  • Data Engineering: Design and implement large-scale data structures to support the business needs.
  • Data Analysis: Proactive investigation and root cause analysis of areas of interest, concern, or any unusual trends in business metrics.
  • Team Work with Tech: Build strong relationships with data engineering and analytics teams to enhance upstream data sources and develop data processes to enable more scalable and accurate reporting.
  • Documentation: Produce comprehensive documentation for dataset and business metrics.
  • Data Engineering: Managing redshift data cluster performance by creating and monitoring reporting, ensuring processes are optimized and promoting best practices to users.
  • Team Work with None-tech: Supporting the Finance and Business teams as required on ad hoc and longer term analysis requests.

BASIC QUALIFICATIONS
· Educated to degree level in a math, statistics, computer science or equivalent technical field.
· BI, Database, Data Warehousing: Will have relevant experience in a business intelligence role, including data warehouse and business intelligence tools, techniques and technology.
· SQL: Evidence of expert proficiency in large database manipulation through SQL
· Tableau, Python: Must have experience with Tableau, Python.
· Redshift: Experience with Redshift including complex querying, analytical functions, and database tuning for optimal query performance with large data sets.
· Excel: Excellent MS Excel
· Data Science: Must show evidence of using data to inform decisions.
· Project Experience: Must have a demonstrable track record of delivering results.
· English: Must demonstrate fluency in English language both written and verbal

PREFERRED QUALIFICATIONS
· MBA or Master’s degree in Computer Science, Engineering, Statistics, Mathematics or related field

TODOS

  • Video Market Research
  • Self Research: Amazon Prime Video
  • Competitors Research: Netflix
  • SQL (window function, self-join, case when, aggregate function)
    • DON’T RUN TEST!
    • JOIN difference
    • JOIN result
    • Explain pk, fk, partition key
    • Explain RANK() & DENSE__RANK()
    • Query tuning & optimization
  • Python
    • two sum
    • define max/min function
    • dictionary/counter count word counts
  • ML: What you did
  • Stats: Z-Score, P Value, Confusion Metrics… AWS Certified Machine Learning
  • Case: LP
  • Metrics Design: quantify parameter…

Key Metrics

  • Communication