Senior Data Engineer

🕒 May 21

🗽 New York – Remote

🗽 New York – Remote

💵 $126k - $147k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Blue Orange Digital

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2015

🤖 Artificial Intelligence

🤝 B2B

🏢 Enterprise

💰 $700k Corporate round on 2022-05

Artificial Intelligence • B2B • Enterprise

Blue Orange Digital is a data and AI consulting firm that helps companies turn complex data into real business outcomes. It partners with organizations across industries to design and deploy scalable data infrastructure, advanced analytics, and AI-powered solutions, and operates as a fully remote, globally distributed team focused on building practical, production-ready systems.

📋 Description

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

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