Data Engineer II - AMZ26680.2

Amazon Inc.; Dallas (TX); On-site; USD 147,000 - 179,000; Full time

Job summary

Amazon.com Services LLC in Dallas, TX seeks a Data Engineer II to design, develop, implement, test, and operate large-scale data structures for business intelligence analytics. You will model data, build ETL/ELT pipelines, and use SQL and Oracle to support analytical workloads.

You will provide online reporting using OBIEE and collaborate across teams to translate business requirements into scalable solutions.

Qualifications

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

Responsibilities

• 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 and a logical abstraction layer against large, multi-dimensional datasets and multiple sources.
• Gather requirements and translate them into robust, scalable, operable solutions within the data architecture.
• Analyze source data systems and drive best practices in source teams; participate in full development life cycle end-to-end.
• Produce dataset documentation and metadata; evaluate dataset implementations and tools; mentor junior data engineers.

Skills

ETL/ELT processes

OLAP technologies

Data modeling

SQL

Oracle

Education

Master's degree in CS/Engineering/IS/Math or related

Bachelor's degree with 5 years equivalent

Tools

OBIEE

Job description

Description

Employer: Amazon.com Services LLC

Position: Data Engineer II - AMZ26680.2

Location: Dallas, TX

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 $146515 - $178800)

Amazon.com is an Equal Opportunity – Affirmative Action Employer – Minority / Female / Disability / Veteran / Gender Identity / Sexual Orientation

Basic Qualifications

Master's degree or foreign equivalent 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. Employer will accept a Bachelor's degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field and five years of experience in the job offered or a related occupation as equivalent to the Master's degree and one year of experience.

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

Preferred Qualifications

All applicants must meet all the above listed requirements.