Business Intelligence Engineer II, Ship Tech | Visibility

The ShipTech BI team is looking for a smart and ambitious individual to support developing the operational reporting structure in Amazon Logistics.
The potential candidate will support analysis, improvement and creation of metrics and dashboards on Transportation by Amazon, In addition, they will work with internal customers at all levels of the organization - Operations, Customer service, HR, Technology, Operational Research. The potential candidate will enjoy the challenges and rewards of working in a fast-growing organization. This is a high visibility position.


As an Amazon Data Business Intelligence Engineer you will be working in one of the worlds largest and most complex data warehouse environments. You should have deep expertise in the design, creation, management, and business use of extremely large datasets. You should have excellent business and communication skills to be able to work with business owners to develop and define key business questions, and to build data sets that answer those questions. You should be expert at designing, implementing, and operating stable, scalable, low cost solutions to flow data from production systems into the data warehouse and into end-user facing applications. You should be able to work with business customers in understanding the business requirements and implementing reporting solutions. Above all you should be passionate about bringing large datasets together to answer business questions and drive change.

Key Responsibilities:
- Design automated solutions for recurrent reporting (daily/weekly/monthly).
- Design automated processes for in-depth analysis databases.
- Design automated data control processes.
- Collaborate with the software development team to build the designed solutions.
- Learn, publish, analyze and improve management information dashboards, operational business metrics decks and key performance indicators.
- Improve tools, processes, scale existing solutions, create new solutions as required based on stakeholder needs.
- Provide in-depth analysis to management with the support of accounting, finance, transportation and supply chain teams.
- Participate in annual budgeting and forecasting efforts.
- Perform monthly variance analysis and identify risks & opportunities.

- 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