Data Engineer II

Based in Seattle, this Data Engineer II role focuses on designing and delivering scalable data structures that power business intelligence analytics. You will work across the full data lifecycle—from data modeling and ETL/ELT processes to SQL and Oracle OLAP tooling, OBIEE reporting, and thorough dataset documentation—while aligning with the broader data architecture and mentoring junior engineers.

Location

Seattle, WA (onsite)

Salary

Annual salary: USD 144,308 - 178,800

Requirements

• Master's degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field with one year of experience in the job offered or a related occupation.
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field with five years of progressive post-baccalaureate experience in the job offered or a related occupation as equivalent to the Master's degree and one year of experience.
• One year of experience developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes.
• One year of experience developing and operating large-scale data structures for business intelligence analytics using OLAP technologies.
• One year of experience developing and operating large-scale data structures for business intelligence analytics using data modeling.
• One year of experience developing and operating large-scale data structures for business intelligence analytics using SQL.
• One year of experience developing and operating large-scale data structures for business intelligence analytics using Oracle.

Responsibilities

• Design large-scale, high-volume, high-performance data structures for business intelligence analytics.
• Develop large-scale, high-volume, high-performance data structures for business intelligence analytics.
• Implement large-scale, high-volume, high-performance data structures for business intelligence analytics.
• Test large-scale, high-volume, high-performance data structures for business intelligence analytics.
• Document large-scale, high-volume, high-performance data structures for business intelligence analytics.
• 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.
• Create a logical abstraction layer against large, multi-dimensional datasets and multiple sources.
• Gather business and functional requirements and translate them into robust, scalable, operable solutions that fit within the data architecture.
• Analyze source data systems and drive best practices in source teams.
• Participate in the full development life cycle—from design and implementation to testing, delivery, support, and maintenance.
• Produce comprehensive, usable dataset documentation and metadata.
• Evaluate dataset implementations designed and proposed by peer data engineers.
• Evaluate the use of new or existing software products and tools.
• Mentor junior data engineers.

Technologies

• OBIEE
• SQL
• Oracle
• OLAP technologies
• ETL/ELT processes
• Data modeling

Benefits

• Sign-on bonus
• Restricted stock units
• Medical benefits
• Financial benefits

Preferred Qualifications

All applicants must meet all the above listed requirements. Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.