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

Amazon; Bengaluru; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Amazon Advertising seeks a Business Intelligence Engineer in Bengaluru to join the Advertising Services Finance Analytics Team. You will analyze performance data, develop metrics and dashboards, and partner with cross-functional teams to improve reporting and decision making.

Requirements include 3+ years of data analysis with Redshift/Oracle, SQL and Python; experience with Tableau or Quicksight; and a related bachelor's degree.

Qualifications

• 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 related field
• 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

Responsibilities

• 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 state-of-the-art platforms
• Report results in a manner which is statistically rigorous and 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
• Adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation

Skills

Data analysis

SQL

Python

Tableau/Quicksight

ETL

Data modeling

Education

Bachelor's degree or above in related field

Tools

Tableau Desktop

Quicksight

Redshift

Oracle

NoSQL

Python scripting

Job description

Description 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.

Description 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.

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.

Basic Qualifications

• 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

Preferred Qualifications

• 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.

Company - Amazon Digital Services Private Limited

Job ID: A10440205