Data Engineer II: Build Scalable BI & Analytics Pipelines

Amazon; New York (NY); On-site; USD 160,000 - 197,000; Full time

Job summary

Amazon Advertising LLC in New York, NY is seeking a Data Engineer II to design, build, and operate large-scale data structures for business intelligence analytics. You will implement data structures using data modeling, ETL/ELT processes, SQL, Oracle, and OLAP technologies, and provide online reporting through OBIEE against diverse data sources.

The role involves gathering business requirements, translating them into scalable data architectures, and mentoring junior data engineers as part of the

Qualifications

• Proficient in SQL, data modeling, and ETL/ELT processes.
• Experience with BI tooling and reporting.
• Strong understanding of data architecture and data sources.

Responsibilities

• Design, develop, test, document, and operate large-scale data structures for BI analytics.
• Implement data structures using SQL, Oracle, and OLAP technologies.
• Provide on-line reporting and analysis using OBIEE and multi-source datasets.
• Gather requirements and translate them into scalable data solutions.
• Mentor junior data engineers and participate in full software development life cycle.

Skills

SQL

Data modeling

ETL/ELT

Business intelligence

Tools

Oracle

OBIEE

OLAP

Job description

Amazon Advertising LLC in New York, NY is seeking a Data Engineer II to design, build, and operate large-scale data structures for business intelligence analytics. You will implement data structures using data modeling, ETL/ELT processes, SQL, Oracle, and OLAP technologies, and provide online reporting through OBIEE against diverse data sources.

The role involves gathering business requirements, translating them into scalable data architectures, and mentoring junior data engineers as part of the