Business Intelligence Engineer, R2L Analytics

The Rapid & Rural Logistics (R2L) team is seeking a Business Intelligence (BI) Engineer to join the Analytics Team. The R2L team, which includes Sub Same Day (SSD), covers a portfolio of high-growth businesses with unique fulfillment and operational capabilities. R2L exists solely to meet the goal of quick, accurate delivery, which is constantly being challenged and changed as we adapt to our customer demands and make improvements. To meet this goal, R2L must remain flexible at all times, adapting to all changes and growth that come our way. As a Business Intelligence (BI) Engineer, your focus will be on providing metrics, operational insights, and other analytical support to stakeholders for the Sub-Same Day (SSD) OpX/OI business. The BI team partners closely with operations teams to influence the strategic direction of the business, drive operational excellence, and make sound investment and expansion decisions, with the primary goal of continuously improving the customer experience while driving long-term profitability for our portfolio of businesses. We experiment constantly, fail fast, and never stop learning.The ideal candidate will draw upon advanced analytical and problem-solving skills, along with a passion for building solutions for automated operational management. The successful leader of this team will collaborate effectively with internal end-users, cross-functional stakeholders, and technical teams to enable data-driven decision-making. They must be a self-starter, show strong bias for action, be comfortable with ambiguity, and be able to think big and be creative to support a rapidly growing business. They will provide technical and business expertise in integrating data from various source systems and presenting it through an array of self-service applications. We look for candidates who are excellent communicators, inspiring leaders, self-motivated, flexible, hardworking, and who like to have fun. If you are excited about data, are results-oriented, and want to join a growing analytics team, this role is for you.Key job responsibilitiesThe successful candidate is a seasoned data professional with a strong bias for action, data modeling, proficiency with data visualization tools, ETL, SQL, and scripting skills. In this role, you will help identify complex business problems, recognize opportunities, and implement solutions to improve operations and finance-facing systems, processes, and tools. The successful candidate will provide technical expertise in extracting, integrating, and analyzing critical data, clearly communicate any potential discrepancies and/or reporting downtime, including specific root causes and steps to resolution, and design and develop key performance metrics and indicators. The successful candidate will be a self-starter, quick learner, comfortable with ambiguity, results-oriented with strong attention to detail, insist on high standards, and adapt to a rapidly evolving environment. 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, metrics, and dashboards to communicate these insights in real-time to 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.A day in the lifeA typical day in this role provides opportunities for building innovative solutions with large-scale data tools, identifying high-priority work and projects that maximize results for key stakeholders, and solving complex problems that impact company-wide strategic decisions.• 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 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 sharingAbout the teamThe Rapid and Rural Logistics team covers a portfolio of high-growth businesses with unique fulfillment and operational capabilities such as Sub Same Day (SSD). Our team needs to move fast and scale quickly with the growing businesses we support. We expect you to be able to identify one- vs two-way doors and make decisions on your own, requesting help when necessary. Strong bias for action is important. Technical skills must be balanced against people skills and business acumen so you can work with stakeholders to understand their needs and deliver the optimal BI solution.Basic qualifications- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience- 1+ years of SQL, ETL or Oracle experience- 1+ years of processing large, multi-dimensional datasets from multiple sources experience- 1+ years of performing statistical analysis experience- 1+ years of developing automated reporting experience- Experience with data visualization using Tableau, Quicksight, or similar tools- Experience with data modeling, warehousing and building ETL pipelines- Experience in Statistical Analysis packages such as R, SAS and Matlab- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modelingPreferred qualification - Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasetsAmazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.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 you’re applying in isn’t listed, please contact your Recruiting Partner.The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at .USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually