Data Engineer II - AMZ27757.1

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

Description

Employer: Amazon Advertising LLC

Position: Data Engineer II - AMZ27757.1

Location: New York, NY

Multiple Positions Available:

Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data structures for business intelligence analytics. Implement data structures using best practices in data modeling, ETL/ELT processes, SQL, Oracle, and OLAP technologies. Provide on-line reporting and analysis using OBIEE business intelligence tools and a logical abstraction layer against large, multi-dimensional datasets and multiple sources. Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions that work well within the overall data architecture. Analyze source data systems and drive best practices in source teams. Participate in the full development life cycle, end-to-end, from design, implementation and testing, to documentation, delivery, support, and maintenance. Produce comprehensive, usable dataset documentation and metadata. Evaluate and make decisions around dataset implementations designed and proposed by peer data engineers. Evaluate and make decisions around the use of new or existing software products and tools. Mentor junior data engineers.

(40 hours / week, 8:00am-5:00pm, Salary Range $160113 - $196600)

Amazon.com is an Equal Opportunity – ...

#0000