Customer Support Data Intelligence team is looking for a Business Intelligence Engineer to help build next-generation metrics and drive business analytics that have measurable impact. The successful candidate will have a strong understanding of different businesses and customer profiles — the underlying analytics, and the ability to translate business requirements into analysis, collect and analyze data, and make recommendations back to the business. BIEs also continuously learn new systems, tools, and industry best practices to help design new studies and build new tools that help our team automate and accelerate analytics.
As a BIE, you will develop strategic reports, design UI, and drive projects to support the WWCS team as well as the entire WW Operations team's decision-making. This role is inherently cross-functional — you will work closely with the finance team, engineering, and leadership across WWCS.
A successful candidate will be a self-starter, comfortable with ambiguity, able to think big and be creative (while still paying careful attention to detail). You should be skilled in database design, be comfortable dealing with large and complex data sets, and have experience building self-service dashboards and using visualization tools, especially Tableau. You should have strong analytical and communication skills.
You will work with a team of analytics professionals who are passionate about using machine learning to build automated systems and solve problems that matter to our customers. Your work will directly impact our customers and operations.
Members of this team will be challenged to innovate using the latest big data techniques. We are looking for people who are motivated by thinking big, moving fast, and exploring business insights. If you love implementing solutions to complex problems while working hard, having fun, and making history, this may be the opportunity for you. Own the design, development, and maintenance of ongoing metrics, reports, analyses, and dashboards on the key drivers of our business.
Key job responsibilities
- Scope, design, and build database structure and schema, which enables all ABCS team members to self-serve.
- Create data pipelines using ETL connections/SQL queries to bring new attributes into the ABCS master database.
- Retrieve and analyze data using a broad set of Amazon's data technologies and resources, knowing how, when, and which to use.
- Pull data on an ad-hoc basis using SQL queries.
- Design, build, and maintain automated reporting, dashboards (especially QuickSight), and analyses to enable our team to self-service data needs, focusing on answering hard and ambiguous problems.
- Conduct deep dives to identify root causes of pain points and opportunities for improvement.
- Become a subject matter expert in ABCS data and support all ABCS team members in deep dives.
- Work closely with CSBI teams to ensure ABCS uses globally aligned standard metrics and definitions.
- Collaborate with finance and business teams to gather data and metrics 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 writing complex SQL queries
- 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
Amazon 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 https://amazon.jobs/content/en/how-we-hire/accommodations 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 https://amazon.jobs/en/benefits.
USA, TN, Nashville - 94,600.00 - 160,000.00 USD annually USA, WA, Seattle - 99,500.00 - 160,000.00 USD annually