2 Array Functions Jobs

DESCRIPTION Within Amazon, the Selling Partner Risk team launches products and services that detect and prevent abuse on our store before it impacts a customer. We work with business partners across the organization to find and close gaps that lead to abuse and create and enforce selling policies that help ensure we have a fair marketplace. Our product and program managers work hand in hand with our engineering and science partners to develop and implement innovative solutions that help Sellers become successful and stop bad actors at scale, globally. We are seeking a candidate who loves solving complex problems, is passionate about stopping bad actors and protecting customers. Plus, good analytical skills and a proven track record of being able to successfully identify a solution, prepare a plan and execute it with good results. Key job responsibilities We are seeking an exceptional Business Analyst to drive analysis and insights to help our teams make meaningful business decisions. As a Business Analyst, you will focus on improving the success of Sellers in our store by analyzing data, discovering and solving real world problems, and building metrics and business cases to improve customer experience. We are focused on your success and want to build future leaders within Amazon. A key component of the role is to identify process and system improvement opportunities by monitoring existing metrics, analyzing data, and partnering with scientists, risk managers and program managers within the team. You will design and develop automated reporting solutions to surface potential gaps of existing mechanism and support data-driven decisions. You will define business logic with business owners and deploy heuristic solutions. Lastly, you will enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format. BASIC QUALIFICATIONS - 3+ years of tax, finance or a related analytical field experience - 3+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience - 3+ years of business or financial analysis experience - Bachelor's degree or equivalent - Experience defining requirements and using data and metrics to draw business insights - Experience with Excel - Experience with SQL PREFERRED QUALIFICATIONS - 3+ years of business analyst, data analyst or similar role experience - Experience working in risk, fraud, or ML organizations. - Ability to create detailed business analysis, outlining problems, opportunities and solutions for a business stakeholders. - Familiar with defining configuration specifications and business analysis requirements - Experience working in risk, fraud or compliance organizations. - Advance SQL proficiency -write complex SQL statements and ability to manipulate a massive amount of data, creating dashboards/on demand reports 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 for more information. If the country/region you're applying in isn't listed, please contact your Recruiting Partner.

DESCRIPTION At Amazon.com, we strive to be Earth's most customer-centric company. To support this vision, we need exceptionally talented, bright, and driven people. If you would like to help us build the place to find and buy anything online, this is your chance to work hard, have fun, and make history. Key job responsibilities An ideal candidate for this role: - Use machine learning techniques to forecast AM Goals for improved long term and short term capacity planning. - Employ the appropriate algorithms to discover patterns of risks, redundancies and inefficiencies. - Design experiments, test hypotheses, and build actionable models to optimize AM operations. - Solve analytical problems, and effectively communicate methodologies and results. - Build predictive models to forecast risks for seller selction and operations and help predict workflow and capacity requirements for AM operations. - Draw inferences and conclusions, and create dashboards and visualizations of processed data, identify trends, anomalies. - Work closely with internal stakeholders such as business teams, engineering teams, and partner teams and align them with respect to your focus area A day in the life As a Business Analyst, you will help develop an analytic solution to drive deep dives, provide insights into the health and state of the Operations and measure business impact. You will transform data into actionable business information, and will make it readily accessible to stakeholders. You will own the design, creation, and management of extremely large datasets. From Day 1, you will be challenged with a variety of tasks, ranging from creating datasets, reports, dashboards to metadata modeling, pipeline monitoring. You will interact with internal program and product owners, and technical teams to gather requirements, structure scalable and perform data solutions, and gain a deep understanding of key datasets. You will design, implement and drive adoption of new analytic technologies and solutions and promote industry standard best practices. You will be responsible to tune query performance against large and complex data sets. You will help translate analytic insights into concrete, actionable recommendations for business or product improvement. BASIC QUALIFICATIONS - 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience - 5+ years of business or financial analysis experience - Experience defining requirements and using data and metrics to draw business insights - Experience making business recommendations and influencing stakeholders PREFERRED QUALIFICATIONS - 3+ years of business analyst, data analyst or similar role experience 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 for more information. If the country/region you're applying in isn't listed, please contact your Recruiting Partner.