Business Intelligence Engineer, Specialists Insights - Workforce Analytics

$89,600 - $185,000/Yr

Amazon - Seattle, WA

Full-time - Mid Level

Seattle, WA

Sporting Goods, Hobby, Musical Instrument, Book, and Miscellaneous Retailers

About the position

The Business Intelligence Engineer role at Amazon Web Services (AWS) focuses on leveraging data analytics to drive business decisions and improve operational efficiency. The position involves collaborating with various teams to develop insights from large datasets, particularly in the context of headcount and recruiting metrics. The ideal candidate will possess strong analytical skills, business acumen, and the ability to communicate effectively with stakeholders to define key business questions and deliver actionable insights.

Responsibilities

• Design, develop, and implement self-service headcount reporting tools.
• Ensure delivery of accurate and timely benchmarked headcount information to support decision-making and planning.
• Act as a consultative partner to the Resource Planning team, providing data-driven insights to support Specialist headcount strategy.
• Identify and address headcount data challenges, predicting future issues and building proactive solutions.
• Conduct consistent data validation audits and maintain headcount data, addressing gaps as they arise.
• Work directly with large datasets and the technical tools needed to analyze them.
• Write high-quality SQL queries to retrieve and analyze data from database tables and build data models using Python.

Requirements

• Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, or equivalent quantitative field.
• 3+ years of experience analyzing and interpreting data with Redshift, Oracle, NoSQL, etc.
• Experience with data visualization tools such as Tableau or Quicksight.
• Proficiency in SQL for data extraction and Python for data processing and modeling.
• Experience with data modeling, warehousing, and building ETL pipelines.
• 5+ years of experience in Business Operations, Strategic Planning, Finance, Management Consulting, or related fields.

Nice-to-haves

• Experience in data mining and ETL processes in a business environment with large-scale datasets.
• Experience developing and presenting new metrics for better business performance understanding.
• Familiarity with AWS solutions such as EC2, DynamoDB, S3, Redshift, Bedrock, and Lambda.
• Strong communication and interpersonal skills to translate business requirements into actionable insights.
• Experience with HR/headcount management systems or processes.

Benefits

• Comprehensive medical, financial, and other benefits.
• Equity and sign-on payments as part of total compensation package.
• Flexible working culture to support work-life balance.