Description Amazon Search Relevance Customer Operations team is seeking a highly skilled and motivated Business Intelligence Engineer to join our team and take the lead to own the data foundation for the whole Search Relevance business, continuously improve the data insights quality to empower the global Search Relevance business expansion. In this role, you will be working in one of the world's largest and most complex data warehouse environments. You should be passionate about working with new AWS technology and complex datasets and proactively to drive the optimal data architecture with the fast changing business and technology. You will ensure we are effectively delivering high quality products that are scalable and meet business requirements. Key job responsibilities * Data Warehouse Design, Development, Maintenance and Optimization: Architect, build and manage secure ,flexible and scalable data warehouse solutions. Ensure the iterations adapt to the ever-changing global technology and new business demand. * Performance Optimization: Write complex and efficient SQL queries for data manipulation, transformation, and aggregation. Optimize SQL queries to improve performance and efficiency. * ETL Process Management: Design, implement, and maintain ETL processes. Ensure accurate and efficient data integration from various sources into the data warehouse and the optimal model to fit downstream usage. * Data Quality and Governance: Implement data quality checks and controls to ensure accuracy and integrity of data. Co-work with Risk Control Management Team to ensure the optimal data quality and compliance. * Collaboration and Support: Work closely with Global Team to ensure the data foundation is consistent with global standards and adapted to the latest technology; Co-work with other BA, BIE, and partner to run the data ecosystem and translate data needs to robust data solutions * Continuous Improvement: Drive innovation and continuous improvement in BI tools, technologies, and methodologies to enhance data analytics capabilities and deliver actionable insights. * Provide technical leadership and mentorship to the BI engineering team, fostering a culture of collaboration, learning, and professional development. Basic Qualifications - 3+ years of tax, finance or a related analytical field experience - 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience - 3+ years of business or financial analysis experience - Bachelor's degree or equivalent - Experience defining requirements and using data and metrics to draw business insights - Experience with Excel - Experience with SQL - Experience making business recommendations and influencing stakeholders Preferred Qualifications - - Experience working directly with business stakeholders to translate between data and business needs - - Experience managing, analyzing and communicating results to senior leadership