Business Intelligence Engineer II

IntePros; Seattle (WA); On-site; USD 130,000 - 196,000; Full time

Job summary

A leading company is seeking a Business Intelligence Engineer III to transform raw data into actionable insights, focusing on customer engagement through data automation and reporting. The role involves developing dashboards and solving complex business problems by analyzing customer behaviors and trends, requiring a strong background in SQL and data visualization tools.

Qualifications

• 3+ years analyzing large datasets using Redshift, Oracle, NoSQL, etc.
• Experience building business dashboards and ETL processes.
• Ability to perform basic statistical analysis.

Responsibilities

• Develop scalable dashboards and analytics for customer engagement.
• Build data visualizations using Excel and Quicksight.
• Audit and optimize SQL queries and ETL jobs.

Skills

SQL

Data Visualization

Data Modeling/ETL

Education

Bachelor's degree in BI, computer science, statistics, math, engineering, or related field

Tools

Excel

Quicksight

Tableau

AWS

Job description

Business Intelligence Engineer III

Business Intelligence Engineer III

Job Description The Everyday Essentials Shopping team is seeking a Business Intelligence Engineer III to transform raw data into actionable insights that shape how customers engage with products and build their shopping baskets. This role focuses on automating data solutions and reporting, surfacing customer engagement metrics, and enabling scalable decision-making across retail experiences.

Key Responsibilities

• Develop and maintain scalable dashboards, metrics, and analytics to understand customer engagement and relevance of shopping experiences.
• Build data visualizations in Excel and Quicksight to translate complex data into clear, actionable insights.
• Define and gather business requirements to design schemas, build pipelines, validate data, and support reporting needs.
• Translate business problems into analytical plans, conduct exploratory analysis, and form testable hypotheses.
• Conduct deep-dive analyses on customer behavior trends, feature usage, and unusual data patterns.
• Become a subject matter expert on relevant data sources and metrics; recommend enhancements and standardization.
• Develop self-service tools and documentation for business and technical stakeholders.
• Audit and optimize existing SQL queries and ETL jobs.
• Troubleshoot operational or data quality issues across pipelines.
  
  

Top Required Skills

• SQL Expertise (3+ years) – Complex query writing, optimization, and data manipulation across large datasets.
• Data Visualization (3+ years) – Dashboard creation using Excel, Tableau, or Quicksight.
• Data Modeling/ETL Development (3+ years) – Schema design and pipeline development for reporting and production use.
  
  

Skills & Experience Required

• Bachelor's degree in BI, computer science, statistics, math, engineering, or related field.
• 3+ years analyzing large datasets using Redshift, Oracle, NoSQL, etc.
• Experience building recurring reports, business dashboards, and ETL processes.
• Ability to perform basic statistical analysis and communicate data insights clearly.
• Strong collaboration skills working with PMs, engineers, and data stakeholders.
  
  

Preferred Qualifications

• Graduate degree in a quantitative or business field.
• Experience in e-Commerce or retail, especially analyzing customer behavior.
• Scripting experience (Python, R, SAS, Matlab).
• Familiarity with AWS tools such as S3, EC2, Redshift.
• Exposure to machine learning or predictive modeling.
  
  

Story Behind the Need – Business Group & Key Projects

• Business Group: Retail (Consumables)
• Team Culture: Cross-functional team focused on customer experience; encourages learning and exploration, including Generative AI/LLMs.
• Key Projects: Build automated data solutions and support customer experience experimentation.
• Reason for Request: Additional support for new projects in Everyday Essentials.
  
  

Typical Day in the Role

• Standard schedule M–F (9:00 AM – 5:00 PM)
• Daily tasks include writing SQL, building dashboards, collaborating with PMs and engineers, and deep-dive analyses.
• Use of Excel, Quicksight, SQL; close collaboration with data and product teams.
  
  

Top 3 Must-Have Hard Skills

• SQL – 3 years
• Data visualization (Excel/Quicksight/Tableau) – 3 years
• Data modeling/ETL pipeline building – 3 years

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Business Development and Sales

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at IntePros by 2x

Get notified about new Business Intelligence Engineer jobs in Seattle, WA.

Seattle, WA $130,000.00-$196,000.00 8 hours ago

Business Intelligence Engineer II, Amazon Key

Seattle, WA $89,600.00-$185,000.00 2 days ago

Business Intelligence Engineer, Amazon Business

Business Intelligence Engineer II, Amazon Key

Seattle, WA $89,600.00-$185,000.00 2 days ago

Seattle, WA $80,000.00-$115,000.00 1 week ago

Redmond, WA $140,900.00-$253,600.00 2 weeks ago

Business intelligence Engineer, Amazon Last Mile

Bellevue, WA $89,600.00-$185,000.00 1 week ago

Greater Seattle Area $105,000.00-$120,000.00 14 hours ago

Bellevue, WA $113,000.00-$180,500.00 1 day ago

Business Intelligence Engineer, Amazon Ads

Seattle, WA $120,000.00-$130,000.00 22 hours ago

Seattle, WA $70,000.00-$150,000.00 1 week ago

Redmond, WA $114,000.00-$171,000.00 2 weeks ago

Business Intelligence Engineer, Supply Chain Experience

Seattle, WA $145,400.00-$195,000.00 6 days ago

Business Intelligence Engineer, P2 Science, Data, and Insights

Seattle, WA $89,600.00-$185,000.00 2 weeks ago

Business Intelligence Engineer II, Amazon Search

Business Intelligence Developer (BI Developer)

Seattle, WA $100,000.00-$130,000.00 4 days ago

Business Intelligence Analyst, Global Affairs

Seattle, WA $117,000.00-$167,000.00 1 day ago

Senior Business Intelligence (BI) Engineer

Bellevue, WA $135,000.00-$175,000.00 1 week ago

Business Intelligence Engineer, WW Prime - Core Services

Seattle, WA $89,600.00-$185,000.00 22 hours ago

Seattle, WA $75,000.00-$101,000.00 2 weeks ago

Business Intelligence Analyst, Global Affairs

Kirkland, WA $117,000.00-$167,000.00 1 day ago

Business Intelligence Engineer II, Amazon

Business Intelligence Engineer, North America Transportation Services

Bellevue, WA $89,600.00-$185,000.00 10 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.