BI Engineer OpsTech Solutions

OpsTech Solutions organization with an unparalleled scope is part of the Amazons WW Operations & Robotics team. We design deploy and support IT infrastructure devices and Services across Amazons Global Fulfillment Centers Transportation (Middle Mile Last Mile & Logistics) and Specialty Customer Solutions (Amazon Fresh Prime Now Lockers Pantry Campus and Prime Air). Our customers range from Amazon lockers to Amazons Air Hubs.

Ops Tech Infrastructure Engineering Product Management (OTIP) is looking for a Business Intelligence Engineer to join our team. The BI Engineer is expected to drive the analytics front of our key business projects come up with insights on key metrics engage with stakeholders to earn trust and merge data intelligence efforts centrally.

The right candidate will be working with large datasets data visualization automation and will enable bringing data forward to answer complex business questions that deepen our knowledge of our business drivers.

This role requires someone with excellent team leadership and communication skills data modeling skills and the ability to work across teams including Data Science Software Dev Product Management Demand Planning Supply Planning Marketing and Finance to drive business outcomes.

Key job responsibilities
Design development and ongoing operations of scalable performant data warehouse (Redshift) tables data pipelines reports and dashboards.
Development of moderately to highly complex data processing jobs using appropriate technologies (e.g. SQL Python Spark AWS Lambda etc.
Development of dashboards and reports.
Partner with stakeholders to understand business domains requirements and expectations. Additionally working with owners of data source systems to gain insights into capabilities and limitations.
Deliver minimally to moderately complex data analysis;
Manage the timeline and deliverables of projects anticipate risks and resolve issues.
Adopt best practices in reporting: data integrity test design validation and documentation.
Have knowledge of AI (Artificial Intelligence) /ML (Machine Learning) and other industry solutions in this space to know when to apply what to solve business problems.
Have proven track record of launching new products solutions and managing projects end to end.
Excellence verbal and written communication skills.
Comfortable wearing multiple hats and go over and above to drive results.

A day in the life
A day in the life
Interface with technical and nontechnical customers delivering complete BI solutions.
Build a data structure and reporting process by working through various business parameters which establish truth in data.
Own the design development and maintenance of ongoing metrics reports analyses dashboards etc. to drive key business decisions.
Recognize and adopt best practices in reporting and analysis: data integrity test design analysis validation and documentation.
Build knowledge of latest technologies tools methodologies and best practices and distill that information across the analytics organization.
Gather insights from customers and operations teams make recommendations and help leaders across OTS organization make key business decisions.
Design and conduct experiments on the effectiveness and efficiency of different initiatives to improve key output metrics and help shape the longterm strategy.

Amazon offers a full range of benefits that support you and eligible family members including domestic partners and their children. Benefits can vary by location the number of regularly scheduled hours you work length of employment and job status such as seasonal or temporary employment.

The benefits that generally apply to regular fulltime employees include:
Medical Dental and Vision Coverage
Maternity and Parental Leave Options
Paid Time Off (PTO)
401(k) Plan

If you are not sure that every qualification on the list above describes you exactly wed still love to hear from you!

At Amazon we value people with unique backgrounds experiences and skillsets. If youre passionate about this role and want to make an impact on a global scale please apply!

3 years of analyzing and interpreting data with Redshift Oracle NoSQL etc. experience
Experience with data visualization using Tableau Quicksight or similar tools
Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
Experience with data modeling warehousing and building ETL pipelines
Experience in Statistical Analysis packages such as R SAS and Matlab

Experience in data mining ETL etc. and using databases in a business environment with largescale complex datasets
Excellent communication (verbal and written) and interpersonal skills to translate ambiguous business requirements into complex analyses and actionable insights
Strong analytic strategy skills; for this role creating analysis ideas is just as important as the ability to do the analysis

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.

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 youre applying in isnt listed please contact your Recruiting Partner.