Data Engineer III - AMZ10066423

Amazon; Herndon (VA); On-site; USD 171,000 - 209,000; Full time

Job summary

Amazon in Herndon, VA seeks a data engineer to design and operate large-scale BI data structures. Responsibilities include ETL/ELT, data modeling, SQL, Oracle, and OLAP; OBIEE for online reporting across multiple sources.

You will translate business requirements into scalable solutions, participate in end-to-end development, document datasets, and mentor junior engineers within a large data architecture team.

Qualifications

• Master's degree or foreign equivalent in a related field with 3 years of experience in data engineering or related roles.
• Bachelor's degree with 7 years progressive experience in related roles as equivalent to Master's degree and 3 years of experience.
• 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 data structures for BI analytics.
• Implement data structures using data modeling, ETL/ELT, SQL, Oracle, and OLAP technologies.
• Provide on-line reporting and analysis using OBIEE and a multi-source data architecture.
• Gather requirements and translate into robust, scalable solutions; mentor junior data engineers.
• Participate in full SDLC: design, implementation, testing, documentation, delivery, support.

Education

Master's degree in Computer Science/Engineering/Information Systems/Mathematics or related field

Bachelor's degree in Computer Science/Engineering/Information Systems/Mathematics or related field with 7 years experience

Tools

ETL/ELT processes

OLAP technologies

data modeling

SQL

Oracle

Job description

Position 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 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.

Position Requirements:

Master's degree or foreign equivalent degree in Computer Science, Engineering, Information Systems, Mathematics, or a related field and three years of experience in the job offered, or as an Operations Research Analyst, Database Developer, or a related occupation. Employer will accept a Bachelor's degree or foreign equivalent degree in Computer Science, Engineering, Information Systems, Mathematics, or a related field and seven years of progressive post-baccalaureate experience in the job offered or a related occupation as equivalent to the Master's degree and three years of experience. 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.

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

40 hours / week, 8:00am-5:00pm, Salary Range $170,872/year to $209,100/year.

Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, visit:

https://www.aboutamazon.com/workplace/employee-benefits.#0000

Basic Qualifications

Position Requirements:

Master's degree or foreign equivalent degree in Computer Science, Engineering, Information Systems, Mathematics, or a related field and three years of experience in the job offered, or as an Operations Research Analyst, Database Developer, or a related occupation. Employer will accept a Bachelor's degree or foreign equivalent degree in Computer Science, Engineering, Information Systems, Mathematics, or a related field and seven years of progressive post-baccalaureate experience in the job offered or a related occupation as equivalent to the Master's degree and three years of experience. 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.#0000

Preferred Qualifications

Please see job description and the position requirements above.

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.