BI Engineer II: Data Pipelines, Dashboards & Analytics

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

Benefits offered by this job

Health insurance

401(k) matching

Paid time off with parental leave

Job summary

Amazon in Bellevue, WA is hiring a Business Intelligence Engineer to analyze data, design scalable data sources, and build repeatable reporting solutions for forecasting products. The role collaborates with data engineers, data scientists, and product teams to drive data-driven improvements.

The position requires strong SQL/ETL skills, experience with Redshift and data visualization tools, and a degree in a related field. A collaborative, cross-functional work environment is emphasized.

Qualifications

• 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL experience.
• 3+ years of SQL, ETL or Oracle experience.
• 3+ years of processing large, multi-dimensional datasets from multiple sources experience.
• 3+ years of performing statistical analysis experience.
• 3+ years of developing automated reporting experience.
• 3+ years of in the job offered or a related occupation experience.
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field.
• 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

• Write high quality optimized SQL to retrieve and analyze data from relational databases (ex. Redshift).
• Collaborate with other BI teams to design and implement ETL data pipelines for billions of records from multiple databases.
• Work closely with Data Engineers and business users to design clean and scalable data sources required for analytics and reporting.
• Work closely with data scientists and product management to drive data-driven improvements to science artifacts.
• Create user–friendly, repeatable reporting solutions to minimize ad hoc customer requests.
• Define and develop business-critical metrics, reports, KPIs, and financials across forecasting products.

Skills

SQL

ETL

Data analysis

Data visualization

Python scripting

Stakeholder collaboration

Big data processing

Education

Bachelor's degree in Computer Science/Engineering/Math/Statistics/Economics

Tools

Tableau

Quicksight

AWS Redshift

Oracle

Python

Job description

Amazon in Bellevue, WA is hiring a Business Intelligence Engineer to analyze data, design scalable data sources, and build repeatable reporting solutions for forecasting products. The role collaborates with data engineers, data scientists, and product teams to drive data-driven improvements.

The position requires strong SQL/ETL skills, experience with Redshift and data visualization tools, and a degree in a related field. A collaborative, cross-functional work environment is emphasized.