Oracle ADW Engineer: OCI Data Pipelines & Analytics

NexGen Technologies, Inc.

United States

Remote

USD 125,000 - 135,000

Full time

7 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

NexGen Technologies, Inc. is seeking an Oracle Autonomous Data Warehouse (ADW) Engineer to establish, configure, and maintain the ADW environment and to implement data ingestion pipelines using OCI Data Integration services for federal contracts.

The role emphasizes strong SQL, data modeling with STAR schemas, and cloud-based Oracle data technologies. Requirements include 3–5 years in Oracle DB/ETL roles, OCI administration, and collaboration with analytics and infrastructure teams to support

Qualifications

3–5 years of experience as an Oracle Database Administrator or ETL Engineer.
3–5 years of hands-on experience with Oracle Autonomous Data Warehouse (ADW).
Experience building and managing pipelines in OCI Data Integration Cloud Service.
Experience designing and maintaining STAR schemas and dimensional data models.
Strong background with Oracle Cloud Infrastructure (OCI) administration and resource configuration.
Advanced SQL skills, including query optimization, analytical functions, and performance tuning.

Responsibilities

Provision, configure, and administer Oracle ADW instances within OCI.
Implement and manage data ingestion pipelines using OCI Data Integration.
Develop ETL/ELT workflows to load, transform, and stage data for analytics.
Design, build, and maintain STAR schemas optimized for reporting and performance.
Monitor performance, storage usage, and query efficiency in the ADW environment.
Collaborate with analytics, data engineering, and infrastructure teams to support reporting needs.
Ensure security, access control, and proper OCI resource configuration.
Document data models, ETL pipelines, and data mapping for maintainability.