Business Intelligence Engineer

- 5+ years of SQL experience
- Experience programming to extract, transform and clean large (multi-TB) data sets
- Experience with AWS technologies
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.
- Experience with theory and practice of information retrieval, data science, machine learning and data mining
- Proficiency in ETL processes and data modeling
- Experience working directly with business stakeholders to translate between data and business needs
- Experience managing, analyzing and communicating results to senior leadership

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.
External job description

This role is on the Chronicle team within Selling Partner Services. We own the Turismo product suite, which is powered by Ripple, a dynamic query engine. Turismo is a well loved product, with 15k+ users globally. Ripple is a PrestoDB based query engine that is built to scale, and processes 2M+ queries per week. We are a full stack team, with Product managers, UX designers, TPMs, SDEs, DEs and Data Scientists.

Impact
Ever wondered how Amazon offers the Earth's biggest selection and still manages to offer lower prices every day to our customers? Our retail business teams work with a massive array of vendors and business financial performance metrics to expand selection and drive costs lower. Given the rapid growth of our business, this requires our category leaders, financial analysts, site merchandisers and vendor managers to quickly analyze vendors, categories and brands, diving deep into data showing business efficiency down to the unit sale level. The technology that enables this has huge visibility and impact and is critical to Amazon's continued profitability and growth.

Innovation
We're working on the future. If you are seeking an environment where you can drive innovation. If you want to apply state-of-the-art software technologies to solve real world problems. If you want the satisfaction of providing visible benefit to end-users in an iterative fast paced environment, this is your opportunity. The responsibilities of this role will be key in paving the future of Amazon Retail and transforming how we do business.

Opportunity
You will be part of a team of creative, top-notch engineers who work hard, have fun, and make history.



Key job responsibilities
Strategic & Technical Leadership:

Establish architectural patterns for enterprise analytics solutions

Design technical standards and best practices for analytics delivery

Create frameworks for metrics definition and governance

Lead implementation of strategic analytics initiatives

Drive innovation in analytics capabilities

Solution Development:

Analyze reports and dashboards to determine appropriate migration strategies

Leverage latest technologies to convert legacy report layouts and KPI calculations into modern AWS QuickSight solutions

Design and implement technical solutions with appropriate analytics strategy and data set design

Drive best practices in operational excellence, data modeling, and analysis

Ensure BI solutions correctly and efficiently support the business

Collaboration & Mentorship:

Work closely with business stakeholders to understand their needs and build sophisticated analytics solutions

Mentor team members on architecture and design

Define patterns for self-service analytics platforms

Communicate effectively with management audiences through narratives and business reviews