Business Intelligence Engineer II, Amazon Global Air

Job description

Are you a builder who can decompose a business question into the drivers that matter and shape them into the decisions that run a global air network? Amazon Global Air's Global Insights & Analytics (GIA) team is hiring a Business Intelligence Engineer II to own analytics end to end: from an open-ended problem, to the data model and pipeline behind it, to the solution and narrative that drive the decision. This is a role for someone who wants to master the analytical craft. You'll build on strong data foundations, pair them with predictive thinking (forecasting, variance attribution, and impact quantification), and design agentic, AI-native systems that enable the business to self-serve at speed. You'll join a team of experienced engineers and partner directly with supply chain business stakeholders, operations leaders, product and program managers, and network leaders across Amazon Global Air. Key job responsibilities - Own analytics end to end: translate ambiguous business questions into well-defined metrics, data products, and analyses, and drive them through to adopted insight - Design, build, and maintain scalable data models, ETL pipelines, and datasets that are trusted, well-documented, and reusable - Write complex SQL to mine, validate, and analyze data across large, multi-dimensional datasets; conduct root-cause deep-dives and drive data-quality improvements - Build and own product solutions that support day-to-day operational decision-making - Develop and present clear written narratives and recommendations to senior leaders, connecting analysis to business impact and explaining plan-over-plan differences - Use GenAI and agentic tooling as a primary part of the workflow, accelerating pipeline development, metric validation, documentation, and deep-dives - Design self-service analytics and enablement so customers can answer routine questions themselves, rather than through a one-off engagement - Apply predictive and analytical techniques (forecasting, trend analysis, anomaly detection) where they improve the quality of a decision, and ensure outputs are accurate, explainable, and actionable - Provide thought leadership on data mining, metric definitions, and analytics best practices across the team A day in the life Most days mix focused analytical work with stakeholder time. You might start by decomposing a business question with an operations leader. Mid-morning you pair with a Data Engineer to validate a data model, then build an attribution view that isolates why a network metric moved. After lunch you prototype an agentic workflow that automates a recurring deep-dive your team used to do manually, test it against last week's actuals, and document how the business can trigger it themselves. Later you might draft the narrative for a WBR, quantifying the impact of a capacity decision and recommending next steps. About the team Global Insights & Analytics (GIA) is a centralized analytics team for Amazon Global Air, delivering the metrics, data products, and insights that leaders use to run and optimize the network. We're investing heavily in self-service and AI-native analytics to expand our reach and impact, and we care about building analytics that are trustworthy, well-modeled, and durable. You'll join a team of experienced BIEs who value deep technical craft and real business partnership. Basic Qualifications: - 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience - 1+ years of SQL, ETL or Oracle experience - 1+ years of processing large, multi-dimensional datasets from multiple sources experience - 1+ years of performing statistical analysis experience - 1+ years of developing automated reporting experience - 3+ years of in the job offered or a related occupation experience - Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field - 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 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, WA, Bellevue - 99,500.00 - 160,000.00 USD annually