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.