Business Intelligence Engineer II, Rapid and Rural Logistics, R2L

Amazon; Nashville (TN); On-site; USD 80,000 - 110,000; Full time

Job summary

Join a forward-thinking team as a Business Intelligence Engineer, where you'll leverage your analytical skills to drive automation and operational insights. This role is pivotal in enhancing delivery processes within a fast-paced environment. You'll collaborate with diverse teams, utilizing data visualization tools and scripting to create innovative solutions that streamline operations. If you're passionate about technology and eager to make a significant impact in a dynamic setting, this opportunity is perfect for you. Embrace the challenge of transforming complex data into actionable insights and be part of a team that values creativity and efficiency.

Qualifications

• 3+ years of data analysis experience with SQL and data visualization tools.
• Proficiency in ETL processes and scripting for data management.

Responsibilities

• Automate operational processes to enhance efficiency and accuracy.
• Collaborate with stakeholders to identify automation opportunities.

Skills

Data Analysis

Problem Solving

Communication

Automation

Creativity

Education

Bachelor's Degree in a related field

Tools

SQL

Tableau

QuickSight

ETL Tools

Python

AWS (EC2, DynamoDB, S3, Redshift)

Job description

Business Intelligence Engineer II, Rapid and Rural Logistics, R2L

Job ID: 2920954 | Amazon.com Services LLC

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 partners closely with Delivery and the operations teams to automate Program Manager manual processes.

The ideal candidate will draw upon advanced analytical and problem-solving skills, and a passion for building solutions 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 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. You will create solutions to automate Program Manager day-to-day tasks or processes using a combination of dashboards, 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 responsibilities
The 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:

1. Understand business problem requirements
2. Identify opportunities for automation
3. Implement solutions to enhance operations facing systems, processes, and tools

A day in the life

1. Take detailed requirements from stakeholders to deeply understand their current manual processes and pain points
2. Think creatively to identify opportunities to solve problems using technology-driven solutions
3. Design and implement the optimal automation solutions to address stakeholder needs
4. Respond to ad-hoc requests and provide support as needed
5. Thoroughly document all processes, solutions, and learnings to ensure knowledge capture and sharing

About the team
The 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

PREFERRED QUALIFICATIONS

- Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift