Business Intel Engineer II , Ads Services Finance Analytics (ASFA)

Amazon Advertising is the earth’s most customer centric advertising program and is dedicated to driving measurable outcomes for brand advertisers, agencies, authors, and entrepreneurs. Our ad solutions—leverage Amazon’s innovations and insights to find, attract, and engage intended audiences throughout their daily journeys. All Amazon teams and businesses, from Prime delivery to AWS, are guided by four key tenets: customer obsession rather than competitor focus, passion for invention, commitment to operational excellence, and long-term thinking. What unites Amazonians across teams and geographies is that we are all striving to delight our customers and make their lives easier. The scope and scale of our mission drives us to seek diverse perspectives, be resourceful, and navigate through ambiguity. By working together on behalf of our customers, we are building the future one innovative product, service, and idea at a time. Are you ready to embrace the challenge? Come build the future with us. Amazon Advertising is looking for a Business Intelligence Engineer who can work in a fast paced, data-driven environment. The selected candidate will have a passion for making data driven decisions. Successful attributes include the ability to be an effective communicator to various audiences, the capacity to remain flexible and adept at learning new tools, and the facility to implement new systems within a team atmosphere. Our environment is deadline driven and fast paced and therefore requires detail-oriented individuals comfortable interacting or working with multiple teams (business and technical). As you further your career as a Business Intelligence Engineer in Amazon Advertising, you will focus on improving corporate reporting frameworks and data visualization. You will analyze performance data, discover and solve real world problems and build metrics and business cases to improve decision making. We are focused on your success and want to build strong leaders within Amazon Advertising. You can expect to leverage your analytical skills and have full ownership of the projects you work on. Key job responsibilities Responsibilities may include: · Day to Day operations reporting. · Work with teams from across Amazon to improve data quality within their respective products and platforms · Identify root causes of data issues and develop solutions · Work with software developers / data engineers to improve data quality on our state-of-the-art platforms · Report results in a manner which is both statistically rigorous and compellingly relevant. · Model data and metadata to support ad-hoc and pre-built reporting. · Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions. · Drive operational excellence for data ingestion, transformation and publication to ensure confidence in the systems we build. · Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation. · Triage many possible courses of action in a high-ambiguity environment, making use of both quantitative analysis and business judgment About the team Advertising Services Finance Analytics Team provides data and analytics support for various orgs withing Advertising Services. This includes reporting, Automation as well as Data Science work.

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience - 2+ years of Tableau Desktop, Quicksight or other relevant data visualization software experience - Bachelor's degree or above in business administration, finance, economics, computer science, data science, engineering, or other related field, or 2+ years of Amazon RME (BB/3P) Full Time Exempt experience - Experience with data visualization using Tableau, Quicksight, or similar tools - Experience with data modeling, warehousing and building ETL pipelines - Experience in Statistical Analysis packages such as R, SAS and Matlab - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling - Experience using SQL (Structured Query Language) to pull data from a database or data warehouse - Experience using Python scripting to process data for modeling

- Master's degree or above in BI, finance, engineering, statistics, computer science, mathematics or equivalent quantitative field - Knowledge of Microsoft Excel at an advanced level, including: pivot tables, macros, index/match, vlookup, VBA, data links, etc. - 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 - Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business 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 https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.