Business Intelligence Engineer, Amazon Pharmacy Operations Technology

At Amazon Pharmacy, we are dedicated to transforming the field of pharmacy and building the world's most customer-focused pharmacy experience. We offer a secure, convenient and competitively-priced pharmaceutical service. Our Pharmacy Operations Analytics team is crucial for making business decisions based on data. Are you eager to pioneer large-scale data solution engineering, pushing Amazon Pharmacy's analytics to new heights? If you have strong analytical abilities, value metric-driven decision-making and seek to overcome challenges with solutions designed to fulfil growing analytical necessities, then we want you as part of our analytics team. We’re developing real-time, fast analytical platforms using big data tools and AWS technologies. This ensures that customers receive critical medicines swiftly, helping them to achieve their health objectives. The ideal candidate thrives on managing vast amounts of data and is eager to solve highly technical problems. They are passionate about data and analytics. A specialist in data modelling, Extract, Transform, Load (ETL) design and business intelligence tools, they collaborate with the business to identify strategic opportunities where data infrastructure improvements can manufacture significant business impact. They are self-starters who are comfortable with ambiguity, adept at thinking big, whilst maintaining careful attention to detail, and enjoy working in a bustling team environment. Job responsibilities include: - Collaborating with Pharmacy business, tech, and data science leadership to create and maintain a world-class data infrastructure that caters to Amazon Pharmacy's growth and mission to be the world's premier pharmacy. - Architecting robust and flexible data solutions for real-time and batch processing. - Creating self-service business intelligence infrastructure for Amazon Pharmacy analytics users. - Collaborating with SDEs/other data engineers to design and construct data solutions that are stable and efficient. - Actively engaging in the code review process, design discussions, team planning, ticket assessment, and metric analyses to help your team evolve. About the team: We accelerate business insights and data-driven innovation by providing reliable, intuitive, timely and cost-effective analytics and data engineering solutions. We have four primary objectives: 1. Provide data warehousing solutions for undifferentiated heavy lifting required for Amazon Pharmacy teams to manage data. 2. Utilize our position as a key data provider to identify and exploit opportunities for privacy, security enhancements, cost reduction, and greater organizational efficiency. 3. Constantly anticipate and identify common patterns in analytics and clear a path for Amazon Pharmacy teams to quickly and easily solve business objectives and derive insights from data, using native AWS solutions whenever possible. 4. Leverage our critical role within the Pharmacy Operations analytics team to highlight key performance indicators for product and process improvements across various pharmacy departments. We are open to hiring candidates based in: Seattle, WA, USA Basic qualifications: - 3 or more years of experience in analyzing and interpreting data with Redshift, Oracle, NoSQL, etc. - Experience with data visualization using Tableau, Quicksight, or similar tools. - Experience with data modeling, warehousing, and building ETL pipelines. - Experienced in writing complex SQL queries. - Proficient in SQL for data extraction from a database or data warehouse and scripting (Python) for data processing in modelling. - Able to effectively communicate complex ideas both in writing and verbally. 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. - Ability to manage a substantial and varied operational workload while managing stakeholder expectations. Amazon is an equal opportunity employer and offers a diverse and inclusive workspace. We do not discriminate based on race, nationality, gender, gender identity, sexual orientation, veteran status, disability, age, or any other legally protected status. For individuals with disabilities requiring accommodation, please visit https://www.amazon.jobs/en/disability/us. Our payment reflects labor costs across various US geographical markets. The base pay for this position ranges from $79,600/year in our lowest geographic market to $185,000/year in our highest geographic market. Pay varies based on market location and may fluctuate depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Depending on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a holistic compensation package, in addition to a comprehensive range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. Please apply via our internal or external career site.