BI Engineer II — Data Wizard for Advertising Insights

Socket.dev; Seattle (WA); On-site; USD 100,000 - 160,000; Full time

Job summary

Amazon in Seattle, WA is seeking a Business Intelligence Engineer II to design and own analytical solutions that turn large, complex datasets into actionable insights. You will build data models, ETL pipelines, dashboards, metrics, and reporting tools while collaborating with engineering, science, product, and business teams.

You will translate loosely defined problems into analytical deliverables using SQL, data modeling, and visualization skills, and mentor peers on BI architecture and data

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• 1+ years of SQL, ETL or Oracle experience
• 1+ years of processing large, multi-dimensional datasets from multiple sources experience
• 1+ years of performing statistical analysis experience
• 1+ years of developing automated reporting experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

Responsibilities

• Design, build, and maintain BI solutions including data models, ETL workflows, dashboards, and reports that serve your team and its stakeholders, ensuring solutions are testable, performant, and well-documented.
• Collaborate with business partners and technical teams to refine ambiguous problems into specific deliverables, recommend alternatives, and anticipate future analytical needs based on a deep understanding of the business context.
• Apply SQL expertise and data engineering best practices to extract, transform, and load data at scale, while optimizing query performance and minimizing resource usage across the team's data infrastructure.
• Create compelling data visualizations and self-service reporting tools that enable stakeholders to interpret results independently and make informed decisions quickly.
• Mentor peers on the team's BI architecture and data lineage, contribute to design and scoping discussions, and apply basic statistical methods to support analytical rigor in solving business problems.

Skills

SQL

ETL

Python

Data modeling

Data visualization

Big data

Redshift

Oracle

NoSQL

Tools

Tableau

Quicksight

Python

Job description

Amazon in Seattle, WA is seeking a Business Intelligence Engineer II to design and own analytical solutions that turn large, complex datasets into actionable insights. You will build data models, ETL pipelines, dashboards, metrics, and reporting tools while collaborating with engineering, science, product, and business teams.

You will translate loosely defined problems into analytical deliverables using SQL, data modeling, and visualization skills, and mentor peers on BI architecture and data