Business Intelligence Engineer II, Middle Mile Planning & Optimization

We need to output HTML fragment with sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We need to parse the description. First, description includes intro paragraphs: "Do you want to lead the journey..." etc. That's about the role. So we can put that in

About the role

with

containing that prose. Then "Key job responsibilities" list bullet points. Those go under

Responsibilities

with

• . Then "Basic Qualifications" list bullet points. Those go under

  Qualifications

  (or Requirements? The instruction says use headings like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we have both Requirements and Qualifications. Usually Basic Qualifications go under Qualifications. Preferred Qualifications maybe under Requirements? But we can treat Basic Qualifications as Qualifications, Preferred as Requirements? However they said "Requirements" heading. Could map Basic Qualifications to Requirements, and Preferred Qualifications to Qualifications? But they said "Qualifications" heading also. We need decide. Better: Use "Requirements" for Basic Qualifications (must-have). Use "Qualifications" for Preferred Qualifications (nice-to-have). Or we could combine both under Qualifications and skip Requirements. But they said prefer few substantive sections over many thin ones. We have both Basic and Preferred; we could combine them into one Qualifications section, but then we lose distinction. However we can still include both as sub-lists? The instruction: Use headings for those categories; we can include both if content exists. So we can have Requirements (Basic) and Qualifications (Preferred). That seems appropriate. Then "Skills": maybe we can extract skills from responsibilities? Not explicit. Could list skills like SQL, Python, Tableau, etc. Those appear in qualifications. Might be redundant. Better to not create Skills if no explicit skills section. Benefits: The posting mentions benefits: "Amazon also offers comprehensive benefits including health insurance ... 401(k) matching, paid time off, and parental leave." Also mention sign-on payments and RSUs. So we have benefits content. Pay: The posting includes base salary range for location: multiple locations with ranges. So we have Pay info. Schedule: Not mentioned. No schedule info. So we omit Schedule. Also need to include minor metadata like Job ID etc folded into short p or drop. We'll drop Job ID. We must not repeat job title as heading. We must not include boilerplate like EEO etc. Remove that. We must preserve all substantive information; do not invent or summarize away detail. We need to output only HTML fragment. Let's extract prose for About the role: The initial paragraphs up to "Key job responsibilities". Let's capture: "Do you want to lead the journey of building the next-gen global transportation network using intelligent routing algorithms & systems that power the delivery of packages? Are you up for this challenge? We are looking for a Business Intelligence Engineer that will lead the innovation and exploration that would drive the future of Middle Mile Transportation at Amazon. Amazon's Middle Mile Transportation Technology team is chartered with building complex software solutions that work across our vendors, warehouses and carriers to optimize both time & cost of getting the packages delivered. Our services already handle thousands of requests per second, make business decisions impacting billions of dollars a year, integrate with a network of small and large carriers, owner operators and drivers worldwide, manage business rules for millions of unique products, and improve ordering and delivery experience for millions of online shoppers. Our mission is to build the most efficient and optimal transportation solution on the planet, using our technology and engineering muscle as our biggest advantage. We aim to leverage latest technologies in big data, machine learning, and optimization techniques, and operate high volume, low latency, and high availability services. As part of this team you will work with executive leaders, engineering, science and operations stakeholders to drive process improvement, generate ideas, validate entitlement and then produce a path to production. You’ll work in a fast-paced environment and will be required to lead not only at the strategic level, but also tactically day-to-day by diving deeply into business and technical domains. As a multi-discipline leader, the buck will stop with you - you will work as part of the engineering organization." That's the About the role. Now Responsibilities: bullet points under "Key job responsibilities". Let's list them: - Generate insightful analysis, reporting, and data visualizations to answer critical business questions, proactively identify notable trends, and communicate business performance - Translate data into actionable insights for stakeholders while proactively identifying new areas of opportunity to drive further improvements - Apply expertise in data mining and modeling leveraging multiple data sources to uncover unique insights, identify key performance drivers, and build predictive models - Work backwards from your end-customer to define, design, and execute each work item with an emphasis on improved metrics, productivity, and efficiency - Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation Now Basic Qualifications (Requirements): - Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field - 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 using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling - Experience in Statistical Analysis packages such as R, SAS and Matlab - Experience using Python scripting to process data for modeling (duplicate? Actually appears twice; we can keep once) - Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift - Experience developing, deploying and managing AI products at scale Note there is duplicate "Experience using Python scripting to process data for modeling". We'll keep one. Now Preferred Qualifications (Qualifications): - Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field - 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience - Knowledge of advanced skills in Excel as well as any data visualization tools like Tableau or similar BI tools (familiarity with Tableau preferred) - Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets - Experience working directly with business stakeholders to translate between data and business needs - Experience managing, analyzing and communicating results to senior leadership Now Benefits: The paragraph after "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." We should include that as Benefits. Pay: 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. Then they list: USA, MN, Minneapolis - 99,500.00 - 160,000.00 USD annually USA, TN, Nashville - 94,600.00 - 160,000.00 USD annually USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually We need to include Pay section with that info. We should not include the line "Your Amazon package will include sign-on payments and restricted stock units (RSUs)." maybe part of Pay or Benefits? It's compensation; could be part of Pay. We'll include in Pay paragraph. Now we need to output HTML fragment with headings

  and content. We must not include any markdown fences. Let's construct:

  About the role

  ...

  Responsibilities

  • ...
  ...

  Requirements

  • ...
  ...

  Qualifications

  • ...
  ...

  Benefits

  ...

  Pay

  ...

  We should not include Schedule. Check for any duplicated lines: we need to preserve all substantive information; we should not omit any of the bullet points. Let's list each bullet precisely. About the role paragraph: we need to keep exactly as given, but we can trim extra spaces. Ensure we keep the content. Now Responsibilities bullets exactly as in text: - Generate insightful analysis, reporting, and data visualizations to answer critical business questions, proactively identify notable trends, and communicate business performance - Translate data into actionable insights for stakeholders while proactively identifying new areas of opportunity to drive further improvements - Apply expertise in data mining and modeling leveraging multiple data sources to uncover unique insights, identify key performance drivers, and build predictive models - Work backwards from your end-customer to define, design, and execute each work item with an emphasis on improved metrics, productivity, and efficiency - Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation Now Requirements (Basic Qualifications) bullets: - Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field - 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 using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling - Experience in Statistical Analysis packages such as R, SAS and Matlab - Experience using Python scripting to process data for modeling (duplicate, but we keep one) - Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift - Experience developing, deploying and managing AI products at scale We could combine the two Python lines into one: "Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling" and "Experience using Python scripting to process data for modeling" maybe redundant; but we must preserve all substantive information; removing duplicate might be considered summarizing away detail? The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." If we remove a duplicate line, we are summarizing away detail (though it's redundant). Safer to keep both lines, even if duplicate. We'll keep both as separate
• items. Now Qualifications (Preferred) bullets: - Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field - 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience - Knowledge of advanced skills in Excel as well as any data visualization tools like Tableau or similar BI tools (familiarity with Tableau preferred) - Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets - Experience working directly with business stakeholders to translate between data and business needs - Experience managing, analyzing and communicating results to senior leadership Now Benefits paragraph: We need to include the benefits description: "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