Business Intelligence Engineer II, Rapid and Rural Logistics
The Rapid & Rural Logistics (R2L) team is seeking a Business Intelligence (BI) Engineer to join the Automation Team. The R2L team that includes rush service and super rural delivery covers a portfolio of high-growth businesses with unique fulfillment and operational capabilities such as Sub Same Day (SSD), Rural Super Rural (RSR), and Amazon Today. R2L exists solely to meet the goal of quick, accurate delivery and this is constantly being challenged and changed, adapting to our customer demands and improved. To meet this goal, R2L must remain flexible at all times, adapting with all of the changes and growth that comes our way. As a Business Intelligence (BI) Engineer, your focus will be on process automation, operational insight, and other analytical support to stakeholders for the Sub-Same Day (SSD),Rural Super Rural (RSR) and Amazon Today(AT) Delivery business. The Automation team partner closely with Delivery and the operations teams to automate Program Manager manual process.The ideal candidate will draw upon advanced analytical, problem solving skills, and a passion for building solution towards automated operational management. The successful leader of this team will collaborate effectively with internal end-users, cross-functional stakeholders and technical teams to drive for automation of our operational processes for future innovation. They must be a self-starter, comfortable with ambiguity, and able to think big and be creative to support a rapidly growing business. Your will create solution to automate Program Manager day to day task or process using combination of dashboard, macros, scripts, and SQL. We look for candidates who are excellent communicators, inspiring leaders, self-motivated, flexible, hardworking, and who like to have fun. Key job responsibilitiesThe successful candidate is a seasoned data professional with a strong bias for action, Proficiency with data visualization tools like QuickSight and Tableau, data modeling, ETL (Extract, Transform, Load), SQL, and scripting skills.Own the design, and development of projects to drive key business decisions. A typical day in this role provides an opportunity to build innovative data solutions with large-scale systems, identify high-priority work and projects that maximize results for key stakeholders, and solve complex problems that impact company-wide strategic decisions. Further, you will help automate processes by developing deep-dive tools, and dashboards to communicate these insights to the business teams. Successful members of this team collaborate effectively with business customers and cross-functional data management teams to solve problems and implement new solutions.In this role, you will: • Understand business problem requirements • Identify opportunities for automation • Implement solutions to enhance operations facing systems, processes, and toolsA day in the life• Take detailed requirements from stakeholders to deeply understand their current manual processes and pain points• Think creatively to identify opportunities to solve problems using technology-driven solutions• Design and implement the optimal automation solutions to address stakeholder needs• Respond to ad-hoc requests and provide support as needed• Thoroughly document all processes, solutions, and learnings to ensure knowledge capture and sharing• DocumentationAbout the teamThe Rapid and Rural Logistics team manages high-growth specialty fulfillment operations, focused on fast, accurate delivery of unique products. The team needs agile, self-directed individuals with a strong bias for action. The ideal candidate will balance technical expertise in ETL, visualization, and scripting with strong stakeholder skills. You'll work closely with teams to deeply understand their needs, then design and deliver automated solutions driving key decisions and operational improvements. Speed, flexibility, and autonomous decisions are crucial. Bonus qualifications include Python proficiency for data tasks, and AWS experience for implementing robust, scalable solutions - complementing the core role requirements.BASIC QUALIFICATIONS- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience- Experience with data visualization using Tableau, Quicksight, or similar tools- Experience with data modeling, warehousing and building ETL pipelines- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling ...