Business Intelligence Engineer, RBS ARTS

Description

About Team

The RBS team is an integral part of Amazon online product lifecycle and buying operations. The team is designed to ensure Amazon remains competitive in the online retail space with the best price, wide selection and good product information. The team's primary role is to create and enhance retail selection on the worldwide Amazon online catalog. The tasks handled by this group have a direct impact on customer buying decisions and online user experience.

Overview Of The Role

An candidate will be a self-starter who is passionate about discovering and solving complicated problems, learning complex systems, working with numbers, and organizing and communicating data and reports. You will be detail-oriented and organized, capable of handling multiple projects at once, and capable of dealing with ambiguity and rapidly changing priorities. You will have expertise in process optimizations and systems thinking and will be required to engage directly with multiple internal teams to drive business projects/automation for the RBS team. Candidates must be successful both as individual contributors and in a team environment, and must be customer-centric. Our environment is fast-paced and requires someone who is flexible, detail-oriented, and comfortable working in a deadline-driven work environment. Responsibilities Include Works across team(s) and Ops organization at country, regional and/or cross regional level to drive improvements and enables to implement solutions for customer, cost savings in process workflow, systems configuration and performance metrics.

Basic Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field
• Proficiency in automation using Python
• Excellent oral and written communication skills
• Experience with SQL, ETL processes, or data transformation

Preferred Qualifications

• Experience with scripting and automation tools
• Familiarity with Infrastructure as Code (IaC) tools such as AWS CDK
• Knowledge of AWS services such as SQS, SNS, CloudWatch and DynamoDB
• Understanding of DevOps practices, including CI/CD pipelines and monitoring solutions
• Understanding of cloud services, serverless architecture, and systems integration

Key job responsibilities

As a Business Intelligence Engineer in the team, you will collaborate closely with business partners, architect, design, implement, and BI projects & Automations.

Responsibilities

• Design, development and ongoing operations of scalable, performant data warehouse (Redshift) tables, data pipelines, reports and dashboards.
• Development of moderately to highly complex data processing jobs using appropriate technologies (e.g. SQL, Python, Spark, AWS Lambda, etc.)
• Development of dashboards and reports.
• Collaborating with stakeholders to understand business domains, requirements, and expectations. Additionally, working with owners of data source systems to understand capabilities and limitations.
• Deliver minimally to moderately complex data analysis; collaborating as needed with Data Science as complexity increases.
• Actively manage the timeline and deliverables of projects, anticipate risks and resolve issues.
• Adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.

Internal Job Description

Retail Business Service, ARTS is a growing team that supports the Retail Efficiency and Paid Services business and tech teams. There is ample growth opportunity in this role for someone who exhibits Ownership and Insist on the Highest Standards, and has strong engineering and operational best practices experience.

Basic Qualifications

• 5+ years of relevant professional experience in business intelligence, analytics, statistics, data engineering, data science or related field.
• Experience with Data modeling, SQL, ETL, Data Warehousing and Data Lakes.
• Strong experience with engineering and operations best practices (version control, data quality/testing, monitoring, etc.)
• Expert-level SQL.
• Proficiency with one or more general purpose programming languages (e.g. Python, Java, Scala, etc.)
• Knowledge of AWS products such as Redshift, Quicksight, and Lambda.
• Excellent verbal/written communication & data presentation skills, including ability to succinctly summarize key findings and effectively communicate with both business and technical teams.

Preferred Qualifications

• Experience with data-specific programming languages/packages such as R or Python Pandas.
• Experience with AWS solutions such as EC2, DynamoDB, S3, and EMR.
• Knowledge of machine learning techniques and concepts.

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 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 modeling

Preferred Qualifications

• 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 datasets