Business Intelligence Engineer, Special Projects & Investigations - Amazon

Description Amazon's Selling Partner Risk organization is seeking an exceptional Business Intelligence Engineer to build and scale our bad actor detection, analysis, and prevention efforts by creating and maintaining robust ETL pipelines, tables, features, and dashboards. We work internally and partner closely with external teams to build and provide better solutions for uses across our organization. This role plays a crucial role in transforming our business problems into functional and useful data sets that are used for a wide variety of MOs that quickly shift and adapt as the business improves. As a Business Intelligence Engineer, you will be in the midst of efforts to wrangle big data together, pare it down, and drive meaningful changes in the business of fraud, risk, and abuse. We aren't interested in building for the sake of building. Every solution we implement is designed to thwart bad actors from being successful and causing harm on the store. Help us find bad actors that absolutely do not want to be found. Top candidates for this role will have excellent SQL, excel, Strong ETL creation/optimization skills, and communication skills with the ability to take business problems and translate them into data solutions with speed, precision, and accuracy. Experience with python is a plus, but not required. A natural curiosity and an ability to understand a system, look for the vulnerabilities, and surface abusive accounts or actions in data is a very nice to have. Key job responsibilities Design, develop and maintain scaled, automated, user-friendly solutions including ETLs, Tables, Queries, Analysis, and Dashboards - additionally, top candidates will have familiarity with anomaly detection and alerting mechanisms. About the team Here at Selling Partner Services, we embrace our differences. We are committed to furthering our culture of inclusion. We have 14 employee-led affinity groups, reaching 10,000+ employees in chapters globally. We have innovative benefit offerings, and we host annual and ongoing learning experiences, including our DEI Ambassador Program. Amazon's culture of inclusion is reinforced within our 16 Leadership Principles, which remind team members to seek diverse perspectives, learn and be curious, and earn trust. Basic Qualifications - 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience - Experience with data visualization using Tableau, Quicksight, or similar tools - Experience with data modeling, warehousing and building ETL pipelines - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling Preferred Qualifications - Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift - Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets Amazon 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. 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.