亚马逊Sr. Business Intelligence Engineer , ESM Central Operation
任职要求
基本任职资格 - 8+ years of analyzing and interpreting data with SQL, Excel and other data tools - Experience with data visualization using Quicksight, or similar tools - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling - Experience in data automation and able to build report/dashboard through automation tools - Experience working directly with business stakeholders to translate between data and business needs 优…
工作职责
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 complex datasets and be someone who loves to turn data into insights to answer strategic business questions. You should have deep expertise in analytic view of business questions, building up & refining metrics framework to measure business operation and translating data into meaningful insights. In this role, you will have ownership of end-to-end analytics development to complex questions and you’ll play an integral role in strategic decision making. You should have excellent business and communication skills to be able to work with business owners to understand business challenges & opportunities, and to drive data-driven decision into process & tool improvement together with business team. Above all, you should be passionate about how insights can be used to improve both the Customer and Seller experience of selling across borders.
• Translating business questions and concerns into specific analytical questions that can be answered with available data using BI tools; produce the required data when it is not available. • Apply Statistical and Machine Learning methods to specific business problems and data. • Ensure data quality throughout all stages of acquisition and processing, including such areas as data sourcing/collection, ground truth generation, normalization, transformation, cross-lingual alignment/mapping, etc. • Communicate proposals and results in a clear manner backed by data and coupled with actionable conclusions to drive business decisions. • Collaborate with colleagues from multidisciplinary science, engineering and business backgrounds. • Develop efficient data querying and modeling infrastructure. • Manage your own process. Prioritize and execute on high impact projects, triage external requests, and ensure to deliver projects in time. • Utilizing code (SQL, Python, R, etc.) for analyzing data and building statistical models.
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 (Extract, Transform, Load) 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, balances, and controls to ensure the accuracy and integrity of data within the data warehouse. 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 business analyst, business intelligence engineer, and other stakeholders to run the data foundation ecosystem and translate data needs to robust data solutions Continuous Improvement: Stay informed of industry trends and advancements in AWS based technologies. Recommend and implement improvements to processes and technologies to enhance data warehouse functionality and efficiency.
· Translating business questions and concerns into specific analytical questions that can be answered with available data using BI tools; produce the required data when it is not available. · Apply Statistical and Machine Learning methods to specific business problems and data. · Create global standard metrics across regions and perform benchmark analysis. · Ensure data quality throughout all stages of acquisition and processing, including such areas as data sourcing/collection, ground truth generation, normalization, transformation, cross-lingual alignment/mapping, etc. · Communicate proposals and results in a clear manner backed by data and coupled with actionable conclusions to drive business decisions. · Collaborate with colleagues from multidisciplinary science, engineering and business backgrounds. · Develop efficient data querying and modeling infrastructure. · Manage your own process. Prioritize and execute on high impact projects, triage external requests, and ensure to deliver projects in time. · Utilizing code (SQL, Python, R, etc.) for analyzing data and building statistical models.
- Develop BI solutions based on the business requirement through the understanding of business and this role’s technical skills (SQL & Python) - Create and drive strategic initiatives that enable data-driven decision making across the organization. - Drive operational excellence in data engineering practices and establish best practices for the organization. - Create scalable, long-term mechanisms for data quality and governance. - Partners with cross-functional teams to identify and resolve seller experience friction points. - Having sense of data governance, permission control, and risk controls.