Data Engineer II- AMZ26497.1

About the role

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.

Responsibilities

• Develop and operate large-scale data structures for business intelligence analytics using ETL/ELT processes, OLAP technologies, data modeling, SQL, and Oracle.
• 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 into robust, scalable, operable solutions.
• Analyze source data systems and drive best practices in source teams.
• Participate in the full development life cycle, from design, implementation and testing, to documentation, delivery, support, and maintenance.
• 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.

Requirements

• Master's degree or foreign equivalent degree in Computer Science, Engineering, Information Systems, Mathematics, or a related field and one year of experience in the job offered, or as a Operations Research Analyst, Database Developer, or a related occupation.
• Bachelor's degree or foreign equivalent degree in Computer Science, Engineering, Information Systems, Mathematics, or a related field and 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 in developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes, OLAP technologies, data modeling, SQL, and Oracle.

Qualifications

• Must have one year of experience in the following skill(s): (1) developing and operating large-scale data structures for business intelligence analytics using each of the following: (i.) ETL/ELT processes; (ii.) OLAP technologies; (iii.) data modeling; (iv.) SQL; and (v.) Oracle.

Skills

• Experience with ETL/ELT processes.
• Experience with OLAP technologies.
• Experience with data modeling.
• Experience with SQL.
• Experience with Oracle.

Benefits

The pay range for this position in Seattle, WA is $144308 - $178800 (yr); however, base pay offered may vary depending on job-related knowledge, skills, and experience. A sign-on bonus and restricted stock units may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered. This information is provided by Seattle, WA Equal Pay Act.

Pay

$144308 - $178800 (yr)

Schedule

(40 hours / week, 8:00am-5:00pm)