Sr. Bi Engineer (bi + Data Engineering), Agl Ba&bi

Amazon Amazon · Big Tech · 13, China +1 · Business Intelligence

This role focuses on Business Intelligence (BI) and Data Engineering for a supply chain product. The engineer will partner with stakeholders to understand insights needs, model complex problems, and use statistical and visualization techniques to derive insights. Responsibilities include developing metrics and dashboards, performing deep-dives, root cause analysis, and working with engineering teams on data capture and storage. The role requires strong SQL, Python, and AWS skills, with experience in data manipulation, statistical analysis, and BI tools like Tableau.

What you'd actually do

  1. As a Business Intelligence Engineer with our team, you will help identify opportunities and implement solutions to improve the efficiency of supply chain network for the ultra-fast delivery programs.
  2. You will be responsible for modeling complex/abstract problems and discovering insights through the use of statistical and visualization techniques.
  3. Further, you will develop metrics and dashboards to communicate these insights to the Ops/Sales/Product teams.
  4. Use analytical and statistical rigor to solve complex problems and drive business decisions.
  5. Manipulate/mine data from database tables (ex. Redshift, MySQL) using SQL.
  6. Manipulate/mine data from log files by writing scripts (ex. PERL, Python, UNIX)
  7. Develop analytical tools: deep-dive tools, UIs, metrics, and dashboards (Tableau/Quicksight)
  8. Perform deep-dives and root cause analysis to answer business questions
  9. Effectively communicate (English written and verbal) solutions and methodologies to senior leadership
  10. Work with engineering teams to enable the appropriate capture and storage of data.

Skills

Required

  • SQL
  • Python
  • AWS technologies
  • scripting for automation
  • advanced SQL skills
  • theory and practice of information retrieval
  • data science
  • machine learning
  • data mining
  • design of experiments
  • statistical analysis of results
  • extract, transform and clean large (multi-TB) data sets

Nice to have

  • Ruby
  • Perl
  • Oracle
  • Redshift
  • BI analytics/ reporting/visualization tools (preferably Tableau)
  • supply chain management concepts - forecasting, planning, optimization, and logistics
  • working directly with business stakeholders to translate between data and business needs
  • managing, analyzing and communicating results to senior leadership

What the JD emphasized

  • critical position
  • complex analysis
  • diving deep into key metrics
  • understanding of multiple programming languages
  • 8+ years of experience in using quantitative analysis
  • 10+ years of professional or military experience
  • 5+ years of SQL experience
  • Experience programming to extract, transform and clean large (multi-TB) data sets
  • Experience with theory and practice of design of experiments and statistical analysis of results
  • 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