Business Intelligence Engineer

Job Title: Business Intelligence EngineerLocation:Bellevue, WA (Onsite)Employment Type: Full-time (W2)OverviewWe 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.ResponsibilitiesDesign, develop, and maintain ETL pipelines using AWS Glue to integrate data from multiple systems into Amazon RedshiftBuild, 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 deliveryEnsure data quality, governance, and scalability across the analytics ecosystem.Required SkillsAWS 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 automationStrong analytical thinking and problem-solving abilities; ability to work with minimal requirements.