Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Blue Orange Digital is seeking a US-based Senior Data Engineer to contribute to and lead within an established enterprise data warehouse environment. This role involves hands-on work with Oracle and OCI, AWS, and shaping the future of the platform with technologies like Apache Iceberg and lakehouse patterns.

Responsibilities

• Build and maintain data flow and transformation patterns across an enterprise Oracle data warehouse environment.
• Partner with client database and platform teams to manage external tables, flat files, and high-volume batch ingestion.
• Identify and implement performance optimizations at the storage, query, and orchestration layers.
• Maintain and extend cloud-to-Oracle integration patterns, the data catalog layer, and shell-script-based orchestration jobs.
• Operate and evolve the existing ETL stack while contributing to the evaluation and adoption of Oracle-native data transform tools.
• Contribute hands-on to the buildout of a hybrid lakehouse using Apache Iceberg, OCI Object Storage, Parquet, and external table patterns.
• Prepare for an upcoming shift in source ingestion toward cloud object storage and a data lake delivery pattern.
• Perform light Linux server administration and performance tuning on existing ETL infrastructure.
• Act as a collaborative thought partner with senior client stakeholders, proposing alternatives and surfacing patterns.
• Support potential future workstreams including master data management and golden record initiatives.

Requirements

• 5+ years of hands-on data engineering experience in Oracle-centric enterprise data warehouse environments.
• Current, hands-on experience with Oracle Cloud Infrastructure (OCI), specifically OCI Object Storage, OCI Data Transforms, Oracle Data Catalog, and OCI ETL patterns.
• Strong Oracle expertise, including advanced SQL, complex joins, performance tuning, and navigating a mature data warehouse with significant legacy business logic.
• Dimensional modeling proficiency, including star schemas, facts and dimensions, and slowly changing dimensions.
• Working knowledge of lakehouse concepts, including the role of object storage in a hybrid data warehouse and lakehouse architecture.
• Solid core ETL and ELT skills, including orchestration, error handling, dependency management, and high-volume batch ingestion.
• Working knowledge of Linux, including shell scripting, SSH-based administration, and basic server maintenance.
• Working knowledge of Java sufficient to read, debug, and lightly modify Java-based ETL components.
• Excellent written and verbal communication skills.
• Able to operate as a peer-level collaborator with senior client subject matter experts.
• US-based with Eastern Time business-hours overlap.

Skills

• Oracle
• Oracle Cloud Infrastructure (OCI)
• OCI Object Storage
• OCI Data Transforms
• Oracle Data Catalog
• OCI ETL patterns
• Advanced SQL
• Complex joins
• Performance tuning
• Dimensional modeling
• Star schemas
• Facts and dimensions
• Slowly changing dimensions
• Lakehouse concepts
• ETL
• ELT
• Orchestration
• Error handling
• Dependency management
• High-volume batch ingestion
• Linux
• Shell scripting
• SSH-based administration
• Server maintenance
• Java
• Apache Iceberg
• Hybrid data warehouse
• Cloud-to-Oracle integration
• Data catalog
• Shell-script-based orchestration
• Oracle-native data transform tools
• OCI Object Storage
• Parquet
• External table patterns
• Cloud object storage
• Data lake delivery pattern
• Master data management
• Golden record initiatives
• AWS S3 to Oracle ingestion patterns
• Cloud-to-warehouse data lake integration
• High-volume transactional reporting
• Data warehouse modernization
• Lakehouse migration

Location

• US-based

Work Type

• Contractor
• Potential full-time employment

Experience Level

• Senior
• 5+ years of hands-on data engineering experience

Salary/Compensations

• $126,000 – $147,000 USD/year
• $10,500 – $12,250 USD/month

About the Company

• Blue Orange Digital is a boutique data & AI consultancy that delivers enterprise-grade results.
• We design and build modern data platforms, analytics, and ML/AI Agent solutions for mid‑market and enterprise clients across Private Equity, Financial Services, Healthcare, and Retail.
• Our teams work with technologies like Databricks, Snowflake, dbt, and the broader Microsoft ecosystem to turn messy, real-world data into trustworthy, actionable insight.
• We’re a builder‑led, client‑first culture that prizes ownership, clear communication, and shipping high‑impact work.

Equal Opportunity

• Blue Orange Digital is an equal-opportunity employer.