Business Intelligence Engineer

Job Title: Business Intelligence Engineer

Location: Bellevue, WA (Onsite)

Employment Type: Full-time (W2)

Overview

We are seeking a highly skilled Business Intelligence Engineer to join our Warehouse Automation Analytics team. This role focuses on designing, developing, and maintaining data pipelines, dashboards, and AI-powered reporting solutions that drive operational excellence across fulfilment centres. The ideal candidate is a problem solver who can independently identify data-driven opportunities, build scalable data models, and leverage GenAI tools such as Amazon Q for intelligent summarisation and insights.

Responsibilities

• Design, develop, and maintain ETL pipelines using AWS Glue to integrate data from multiple systems into Amazon Redshift.
• Build, optimize, and automate interactive dashboards and reports in Amazon QuickSight to support leadership and business stakeholders.
• Develop and maintain data connectors and APIs for seamless integration across internal systems.
• Leverage Amazon Q (GenAI) for report summarization, insights generation, and conversational analytics within QuickSight.
• Work closely with data engineers, full-stack developers, product owners, and business analysts to translate requirements into actionable metrics.
• Define, measure, and monitor key performance indicators (KPIs) related to warehouse readiness, utilization, downtime, and cost variance.
• Identify process gaps and propose AI-driven improvements to enhance productivity and reporting accuracy.
• Participate in end-to-end solution development — from data ingestion and modelling to visualization and insights delivery.
• Ensure data quality, governance, and scalability across the analytics ecosystem.

Required Skills

• AWS ecosystem: Redshift, Glue, QuickSight, S3, Lambda.
• Strong experience in SQL, ETL development, and data modelling.
• Proficiency in Python or PySpark for data transformations.
• Hands-on experience with BI tools (QuickSight, Power BI, Tableau, etc.).
• Familiarity with AI/ML integration and LLM-based tools (Amazon Q, ChatGPT, Gemini).
• Understanding of data warehouse architecture and report automation.
• Strong analytical thinking and problem-solving abilities; ability to work with minimal requirements.