Note: The job is a remote job and is open to candidates in USA. Blue Orange Digital is a boutique data & AI consultancy that delivers enterprise-grade results. They are seeking a Senior Data Engineer who will contribute to an established enterprise data warehouse environment and collaborate with data leadership to enhance the platform's capabilities.
Responsibilities
- Build and maintain data flow and transformation patterns across an enterprise Oracle data warehouse environment
- Partner with the 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, including across a long-standing production warehouse with accumulated business logic
- 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 rather than waiting for prescriptive direction
- Support potential future workstreams including master data management and golden record initiatives once data foundations are matured
Skills
- 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. Candidates needing ramp-up on OCI fundamentals will not be considered
- Strong Oracle expertise, including advanced SQL, complex joins, performance tuning, and the ability to navigate 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. Able to operate as a peer-level collaborator with senior client subject matter experts
- US-based with Eastern Time business-hours overlap
- Hands-on Apache Iceberg experience, including table format, metadata layer, and migration patterns
- Production Pentaho experience
- Experience with AWS S3 to Oracle ingestion patterns and cloud-to-warehouse data lake integration
- Exposure to high-volume transactional reporting domains
- Master Data Management or golden record program experience
- Background in data warehouse modernization or lakehouse migration projects
Benefits
- Fully Remote
- Background checks may be required for certain positions/projects.
Company Overview