Data Engineer II: BI Analytics and ETL Specialist

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

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.