Amazon Selection and Catalog Systems (ASCS) builds the systems that host and run the comprehensive e-commerce product catalog. We power the online shopping experience for customers worldwide, enabling them to find, discover, and purchase anything they desire. Our scaled, distributed systems process hundreds of millions of updates across billions of products, including physical, digital, and service 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 self-service 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. Real-time intelligence will support proactive decision-making, enabling faster, data-driven decisions across the organization and driving long-term growth and an enhanced customer experience. We are looking for an innovative, highly-motivated, 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 end-to-end 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 data-driven 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 high-quality, 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 hands-on SQL and scripting language experience, and excel in 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 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 cross-functional 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 high-impact business questions and proactively uncover new insights that drive decision-making 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 fast-moving 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 end-to-end projects, including stakeholder management, data gathering/manipulation, modeling, problem-solving, and communication of insights * Design, build, and maintain automated reporting, dashboards, and ongoing analysis to enable data-driven decisions * Report key insight trends using statistical rigor to inform the larger team of business-impacting developments * Retrieve and analyze data using a broad set of Amazon's 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 multi-domain expertise to own the end-to-end roadmap and analytical approach for complex problems * Translate business requirements into analysis plans, review with stakeholders, and maintain high execution 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 high-impact business review metrics, reports, and dashboards * Provide BI solutions for loosely defined problems, deliver large-scale 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 BIE-III will include: * Working closely with cross-functional teams including Product/Program Managers, Software Development Managers, Applied/Research/Data Scientists, and Software Developers. * Lead the BIE team and own the execution of BIE projects. * Building dashboards, performing root cause analysis, and sharing actionable insights with stakeholders to enable data-informed decision making * Leading reporting and analytics initiatives to drive data-informed 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 well-defined 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 discipli