Business Intelligence Engineer II, Amazon Time & Pay Innovation

$89,600 - $185,000/Yr

Amazon - New York, NY

Full-time - Mid Level

New York, NY

10,001+ employees

Sporting Goods, Hobby, Musical Instrument, Book, and Miscellaneous Retailers

About the position

The Business Intelligence Engineer II role at Amazon focuses on innovating and enhancing the Time & Pay (ATP) systems that support a vast number of employees across various Amazon sectors. This position is crucial for building data infrastructure and generating insights from large datasets, impacting decisions on product design and implementation. The role involves collaboration with engineers, product managers, and leadership to drive business intelligence and analytics excellence, ultimately empowering Amazon's global workforce.

Responsibilities

• Own the design, development, and management of scalable solutions for ongoing metrics, reports, analyses, dashboards, etc. to support business needs.
• Perform variance analyses and identify risks and opportunities.
• Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
• Own all SQL, Redshift, Quicksight, Tableau functions - ad hoc, recurring, and troubleshooting.
• Build models, dashboards, and BI tools for real-time reporting and large-scale offline use cases.
• Provide self-service tooling that supports both basic metrics reporting and some simple drill downs.
• Create persistent and scalable metrics to provide business insights into the product development function.
• Work closely with Product Managers, Data Engineers, and software engineering teams to drive implementations of solutions.
• Provide data management processes such as accessing raw data feeds, building queries and macros, writing VBA code, organizing data, and designing reports that present status-at-a-glance visualization for business performance.
• Retrieve and analyze large sets of data using Excel, SQL, and other data management systems.
• Build and manage related key performance indicators (KPIs) to measure, control, and benchmark reporting processes.
• Monitor existent metrics, build new metrics, and partner with internal teams to identify process and system improvement opportunities.
• Generate complex queries to dive deep on process issues.

Requirements

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

Nice-to-haves

• 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

Benefits

• Full range of medical benefits
• Financial benefits including equity and sign-on payments
• Comprehensive employee benefits package