Business Intelligence Engineer Amazon

Amazon Selection and Catalog Systems (ASCS) builds the systems that host and run the worlds largest eCommerce products catalog. We power the online buying experience for customers worldwide so they can find discover and buy anything they want. Our massively scaled out distributed systems process hundreds of millions of updates on the billions of products across physical digital and services offerings.

You will be part of Catalog Support Programs (CSP) team under Catalog Support Operations (CSO) in ASCS Org. CSP provides program management technical support and strategic initiatives to enhance the customer experience owning the implementation of business logic and configurations for ASCS. We are establishing a new centralized Business Intelligence team to build selfservice analytical products for ASCS that provide relevant insights and data deep dives across the business. By leveraging advanced analytics and AI/ML we will transform catalog data into predictive insights helping prevent customer issues before they arise. Realtime intelligence will support proactive decisionmaking enabling faster datadriven decisions across the organization and driving longterm growth and an enhanced customer experience.
We are looking for an innovative highlymotivated and experienced Business Intelligence Engineer who can think holistically about problems to understand how systems work together. You will work closely with engineering teams product managers program managers and organizational leaders to deliver endtoend data solutions aimed at continuously enhancing overall ASCS business performance and delivery quality.
As a Senior BIE you will lead the data and reporting requirements for ASCS programs and projects. Your role will involve close engagement with senior leaders to generate insights and conduct deep dives into key metrics that directly influence organizational strategic decisions and priorities. You will demonstrate a high proficiency in complex SQL scripting often combining various data sets from diverse sources. You will own the design development and maintenance of ongoing metrics reports dashboards etc. to drive key business decisions. You will simplify and automate reporting audits and other datadriven activities. You will develop and drive best practices in data integrity consistency validations and documentation. You will serve as a technical and analytical leader for the team providing guidance and expertise to others on complex business and data challenges. Consistently deliver highquality timely results that demonstrate your deep subject matter expertise.
This role requires an individual with excellent analytical abilities deep knowledge of business intelligence solutions as well as business acumen and the ability to work with various tech and product teams across ASCS. The ideal candidate should have excellent business and communication skills to work with business owners to define roadmaps develop milestones define key business questions and build data sets that answer those questions. You should have handson SQL and scripting language experience and excel in designing implementing and operating stable scalable lowcost solutions to flow data from production systems into the data warehouse and into enduser facing applications.
You will be instrumental in the creation of a reliable and scalable infrastructure for ongoing reporting and analytics. You will structure ambiguous problems and design analytics across various disciplines resulting in actionable recommendations ranging from strategic planning product strategy/launches and engineering improvements.
You will work closely with internal stakeholders to define key performance indicators (KPIs) implement them into dashboards and reports and present insights in a concise and effective manner. This role will involve collaborating with business and tech leaders within ASCS and crossfunctional teams to solve problems create operational efficiencies and deliver against high organizational standards.
You should be able to apply a breadth of tools data sources and analytical techniques to answer a wide range of highimpact business questions and proactively uncover new insights that drive decisionmaking by senior leadership. As a key member of the CSP team you will continually raise the bar on both quality and performance. You will bring innovation a strategic perspective a passionate voice and an ability to prioritize and execute on a fastmoving set of priorities competitive pressures and operational initiatives.

Key job responsibilities
* Lead the design implementation and delivery of BI solutions for ASCS
* Manage and execute endtoend projects including stakeholder management data gathering/manipulation modeling problemsolving and communication of insights
* Design build and maintain automated reporting dashboards and ongoing analysis to enable datadriven decisions
* Report key insight trends using statistical rigor to inform the larger team of businessimpacting developments
* Retrieve and analyze data using a broad set of Amazons data technologies and resources
* Earn the trust of customers and stakeholders by understanding their needs and solving problems with technology
* Work closely with business stakeholders and senior leadership to review roadmaps and contribute to strategy
* Apply multidomain expertise to own the endtoend roadmap and analytical approach for complex problems
* Translate business requirements into analysis plans review with stakeholders and maintain high standards
* Proactively work with stakeholders to define use cases and standardized analytical outputs
* Scale data processes and reports through efficient query development and automation
* Demonstrate deep knowledge of available data sources to enable comparative and complex analyses
* Actively manage project timelines communicate with stakeholders and represent the team on initiatives
* Build and manage highimpact business review metrics reports and dashboards
* Provide BI solutions for loosely defined problems deliver largescale analytical projects and highlight new opportunities
* Optimize code quality and BI processes to drive continuous improvement
* Extract transform and load data from multiple sources using SQL scripting and ETL tools

A day in the life
A day in the life of a BIEIII will include:

* Working closely with crossfunctional teams including Product/Program Managers Software Development Managers Applied/Research/Data Scientists and Software Developers.
* Lead the BIE team and own the of BIE projects.
* Building dashboards performing root cause analysis and sharing actionable insights with stakeholders to enable datainformed decision making
* Leading reporting and analytics initiatives to drive datainformed decision making
* Designing developing and maintaining ETL processes and data visualization dashboards using Amazon QuickSight
* Transforming complex business requirements into actionable analytics solutions
* Solving ambiguous analyses with less welldefined inputs and outputs driving to the heart of the problem and identifying root causes
* Handling large data sets in analysis through the use of additional tools
* Deriving recommendations from analysis that significantly impact a department create new processes or change existing processes
* Understanding the basics of test and control comparison and providing insights through basic statistical measures such as hypothesis testing
* Identifying and implementing optimal communication mechanisms based on the data set and the stakeholders involved
* Communicating complex analytical insights and business implications effectively

About the team
This central BIE team within ASCS will be responsible for building a structured analytical data layer bringing in BI discipline by defining metrics in a standardized way and establishing a single definition of metrics across the catalog ecosystem. They will also identify clear sources of truth for critical data. The team will build and maintain the data pipelines for critical projects tailored to the needs of ASCS teams leveraging catalog data to provide a unified view of product information. This will support realtime decisionmaking and empower teams to make datadriven decisions quickly driving innovation. This team will leverage advanced analytics that can shift us to a proactive datadriven approach enabling informed decisions that drive growth and enhance the customer experience. This team will adopt best practices standardize metrics and continuously iterate on queries and data sets as they evolve. Automated quality controls and realtime monitoring will ensure consistent data quality across the organization.

10 years of professional or military experience
6 years of SQL experience
Experience programming to extract transform and clean large (multiTB) data sets
Experience with theory and practice of design of experiments and statistical analysis of results
Experience with AWS technologies
Experience in scripting for automation (e.g. Python) and advanced SQL skills.
Experience with theory and practice of information retrieval data science machine learning and data mining
Experience in the data/BI space
Knowledge of data warehousing and data modeling
Demonstrate proficiency in SQL data analysis and data visualization tools like Amazon QuickSight/Tableau to drive datadriven decision making
Experience with statistical analytics and programming languages (e.g. Python Java Ruby R) and big data technologies/languages (e.g. Spark Hive Hadoop PyTorch PySpark) to build and maintain data pipelines and ETL processes
Experience applying basic statistical methods (e.g. regression ttest Chisquared) as well as exploratory deterministic and probabilistic analysis techniques to solve complex business problems.
Track record of generating key business insights and collaborating with stakeholders.
Experience working directly with business stakeholders to translate between data and business needs
Superior verbal and written communication and presentation skills experience working across functional teams and senior stakeholders.
Track record of building automated scalable analytical solutions
Bachelors or Masters in Computer Science Mathematics Statistics Operations Research Data Science Economics Business Administration or a similar related discipline

Experience working directly with business stakeholders to translate between data and business needs
Experience managing analyzing and communicating results to senior leadership
Masters degree in statistics data science or an equivalent quantitative field
Experience building measures and metrics and developing reporting solutions
Experience using Cloud Storage and Computing technologies such as AWS Redshift S3 Hadoop etc.
Experience building and maintaining data pipelines and ETL processes
Experience with statistical analysis corelation analysis as well as exploratory deterministic and probabilistic analysis techniques

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.