Business Intelligence Engineer II, AWS Infrastructure Supply Chain Intelligence

About the role

The ideal candidate must be able to identify problems before they happen and implement solutions that detect and prevent outages. The candidate must be able to accurately prioritize projects, make sound judgments, work to improve the customer experience and get the right things done. Technical ability to support dashboard creation supporting daily operations, track KPIs, and provide holistic performance measurements to be shared with internal and external stakeholders is desired. The role plays a critical part in ensuring strategic commitments are made and operations are exceeding desired performance levels by using metrics to drive accountability and process improvements.

Responsibilities

• Build reports, dashboards, and analyses to deliver metrics and insights to the business.
• Translate difficult business problem statements into analysis requirements and maintain high bar throughout the execution.
• Define analytical approach; review and vet analytical approach with stakeholders.
• Proactively and independently work with stakeholders to construct use cases and associated standardized outputs.
• Have a working knowledge of the data available or needed by the wider business for more complex or comparative analysis.
• Report key insight trends, using statistical rigor to simplify and inform the larger team of noteworthy story lines that impact the business.
• Learn and understand a broad range of Amazon’s data resources and know how, when, and which

Requirements

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• 1+ years of SQL, ETL or Oracle experience
• 1+ years of processing large, multi-dimensional datasets from multiple sources experience
• 1+ years of performing statistical analysis experience
• 1+ years of developing automated reporting 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

Qualifications

• Basic Qualifications: 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience; 1+ years of SQL, ETL or Oracle experience; 1+ years of processing large, multi-dimensional datasets from multiple sources experience; 1+ years of performing statistical analysis experience; 1+ years of developing automated reporting 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
• Preferred Qualifications: 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