Senior Data Engineer: Oracle, Spark & Cloud Analytics

Katalyst CRO; Charlotte (NC); On-site; USD 120,000 - 160,000; Full time

Job summary

Katalyst CRO seeks an experienced Senior Data Engineer to lead the design and optimization of Oracle-based analytical platforms and Spark-powered data pipelines. You will modernize large-scale data architectures, migrate workloads, and deliver actionable analytics across enterprise systems.

Ideal candidates bring hands-on expertise in PySpark/Scala, Python, Oracle OLAP, and SQL, plus experience with data integration tools such as GoldenGate and CDC, and cloud analytics services.

Qualifications

• 8+ years of experience in Data Engineering or related roles.
• Hands-on experience with Apache Spark (PySpark/Scala) and Python.
• Deep understanding of Oracle databases supporting OLAP, data warehousing, and analytical workloads.
• Proven experience tuning and optimizing: Spark applications and execution plans, complex SQL queries, large-scale ETL/ELT processes, high-volume batch processing workloads.
• Strong SQL and data modeling skills.
• Experience with Oracle GoldenGate, CDC, or enterprise-scale data integration technologies.

Responsibilities

• Design, develop, and optimize large-scale data processing solutions using Apache Spark (PySpark/Scala) and Python.
• Build and maintain scalable ETL/ELT pipelines for analytical and reporting workloads.
• Optimize query performance, Spark jobs, and end-to-end data processing pipelines for high-volume batch and near real-time workloads.
• Design and implement data integration, replication, and ingestion solutions using Oracle GoldenGate, Kafka, and CDC frameworks.
• Collaborate with application, data, and analytics teams to develop scalable data models and processing frameworks.
• Drive performance tuning initiatives across Oracle, Spark, and distributed data processing environments.

Skills

Apache Spark

Python

SQL

Data modeling

Tools

Oracle GoldenGate

CDC

Kafka

Job description

Katalyst CRO seeks an experienced Senior Data Engineer to lead the design and optimization of Oracle-based analytical platforms and Spark-powered data pipelines. You will modernize large-scale data architectures, migrate workloads, and deliver actionable analytics across enterprise systems.

Ideal candidates bring hands-on expertise in PySpark/Scala, Python, Oracle OLAP, and SQL, plus experience with data integration tools such as GoldenGate and CDC, and cloud analytics services.