Data Engineer II - AMZ9956938

Socket.dev; New York (NY); On-site; USD 158,436 - 196,600; Full time

Job summary

Amazon.com Services LLC is hiring a Data Engineer II in New York, NY. You will design and implement high-performance data structures for business intelligence analytics, using ETL/ELT processes, SQL, Oracle, and OLAP—providing online reporting via OBIEE.

You will mentor junior engineers and participate in end-to-end development—from design through deployment and maintenance—and ensure robust data solutions across multiple sources.

Qualifications

• Master's degree or equivalent in CS/Engineering/IS/Math with 1 year experience, or Bachelor's with 5 years progressive experience.
• Experience developing and operating large-scale data structures for BI analytics with 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 online reporting and analysis using OBIEE and a multi-source data layer.
• Gather requirements and translate into scalable data solutions within the data architecture.
• Mentor junior data engineers and participate in end-to-end development lifecycle.

Skills

ETL/ELT

OLAP technologies

Data modeling

SQL

Oracle

Education

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

Bachelor's with 5 years experience

Tools

OBIEE

Oracle

Job description

MULTIPLE POSITIONS AVAILABLE

Employer: AMAZON.COM SERVICES LLC
Offered Position: Data Engineer II
Job Location: New York, New York
Job Number: AMZ9956938

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.
• 40 hours / week, 8:00am-5:00pm, Salary Range: $158,436/year to $196,600/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.

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

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.

Basic Qualifications

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

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.