BI Engineer, AWS Insights and Analytics

Description The AWS Business Insights and Analytics (BIA) team is committed to delivering analytics and reporting solutions tailored for AWS executive leadership on a regular basis. As a BI Engineer, you will play a crucial role in driving the core metrics expansion across the organization. This involves collaborating closely with various stakeholders to define, implement, and automate the key performance indicators that power our business decisions. In this position, you will also be responsible for performing in-depth trend analysis to support accurate forecasting and planning. Using your strong analytical skills, you will explore innovative mechanisms to transform raw data into first-class business insights that inform strategic decision-making. We deal with billions of line items and manage artifacts using cutting-edge big data technologies. Additionally, you will also be expected to conduct peer code reviews to help raise the bar of Amazon's coding standards and best practices. You should possess a deep hands-on expertise in SQL and Python, along with advanced knowledge of statistical models and their application to business intelligence and data analysis. Proven experience in managing high-visibility reporting systems will be preferred for success in this role. Key job responsibilities Lead the expansion and enhancement of core business metrics in close partnership with cross-functional stakeholders Conduct comprehensive trend analysis to uncover meaningful insights that support forecasting and planning Develop innovative data visualization and automated reporting solutions to increase efficiency and scalability Partner with data engineers to ensure metrics solutions are developed in accordance with best practices for data integrity Perform peer code reviews to ensure code quality and alignment with Amazon's coding standards 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 - Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field 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 - Knowledge of advanced skills in Excel as well as any data visualization tools like Tableau or similar BI tools (familiarity with Tableau preferred) - Experience with forecasting and statistical analysis Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us. Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.