Business Intelligence Engineer II, Prime Video Marketplace

Would you like to shape the future of the video entertainment industry for movies, TV and live sports events? Does solving complex problems within large scale systems excite you? If you answered yes, come build the future of entertainment with us!Prime Video offers customers a vast collection of movies, series, and sports—all available to watch on hundreds of compatible devices. U.S. Prime members can also subscribe to 100+ channels including Max, discovery+, Paramount+ with SHOWTIME, BET+, MGM+, ViX+, PBS KIDS, NBA League Pass, MLB.TV, and STARZ with no extra apps to download, and no cable required. Prime Video is just one of the savings, convenience, and entertainment benefits included in a Prime membership. More than 200 million Prime members in 25 countries around the world enjoy access to Amazon’s enormous selection, exceptional value, and fast delivery.Are you interested in shaping the future of entertainment? Prime Video's technology teams are creating best-in-class digital video experience.As a Prime Video technologist, you’ll have end-to-end ownership of the product, user experience, design, and technology required to deliver state-of-the-art experiences for our customers. You’ll get to work on projects that are fast-paced, challenging, and varied. You’ll also be able to experiment with new possibilities, take risks, and collaborate with remarkable people.We’ll look for you to bring your diverse perspectives, ideas, and skill-sets to make Prime Video even better for our customers. With global opportunities for talented technologists, you can decide where a career Prime Video Tech takes you!The team works in a dynamic environment where innovating on behalf of our customers is at the heart of everything we do. If this sounds exciting to you, please read on.As a Business Intelligence Engineer, you will partner with cross-functional stakeholders to gather, translate, and report customer insights which will have a direct impact on decision making and strategy for Prime Video Marketing and Content Acquisition teams. You will create key business reporting to our stakeholders and third party partners, build scalable data solutions to complex problems and perform analytical deep dives. In doing so, you will have the opportunity to work with the one of the largest and most complex data warehouses in the world and collaborate with multiple Tech, Finance, Product, and BI teams across the globe.This position requires high judgment, excellent analytical abilities, a creative mind to invent solutions to improve our interaction with the customer; it also offers broad exposure to various business, financial, and technical teams across Amazon. You should thrive and succeed in an entrepreneurial and ambiguous environment. If you are passionate about video entertainment, detail oriented, organized, and systematically break down problems with ease, we would love to speak with you!Key job responsibilities- Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions- Apply advanced analytics and statistics to derive impactful insights into customer behavior- Recognize and adopt best practices in reporting and analysis: test design, analysis, validation, and documentation- Build strong relationships with data engineering and analytics teams to enhance upstream data sources and develop data processes that enable more scalable and accurate reporting- Support Marketing and Content Acquisition teams as required on ad-hoc and longer term analysis requestsA day in the lifeYour day may begin with gathering video streaming trends, utilizing complex SQL queries to analyze data from millions of Prime Video customers. This involves transforming raw data into insightful visualizations and dashboards, identifying key trends and anomalies. You then apply advanced analytics to dive deep on viewing patterns, offering strategic insights to the Content Acquisition team. Collaboration with the Marketing department follows, in which you provide data-driven recommendations for an upcoming email campaign's targeting.Basic qualifications- Experience with data visualization using Tableau, Quicksight, or similar tools- Experience writing complex SQL queries- Knowledge of SQL and data warehousing conceptsPreferred qualification - Experience with forecasting and statistical analysis- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets- Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the businessAmazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.Los Angeles County applicants: Job duties for this position include: work safely and cooperatively with other employees, supervisors, and staff; adhere to standards of excellence despite stressful conditions; communicate effectively and respectfully with employees, supervisors, and staff to ensure exceptional customer service; and follow all federal, state, and local laws and Company policies. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness and professionalism, and safeguard business operations and the Company’s reputation. Pursuant to the Los Angeles County Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.