Data Engineer / Data Analyst (Databricks & Oracle ERP)

LTD Global
Houston, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Houston, United States of America

Tech stack

API
Amazon Web Services (AWS)
Data analysis
Azure
Cloud Computing
Information Engineering
ETL
Data Structures
Database Storage Structures
Digital Assets
Hive
Operational Data Store
Oracle Applications
Performance Tuning
Cloud Services
Standard Sql
Reverse Engineering
Technical Data Management Systems
Data Processing
Freeform SQL
Google Cloud Platform
Sql Optimization
Data Lake
PySpark
Data Lineage
Data Analytics
Oracle Ebusiness
Oracle Erp
Oracle Cloud Infrastructure
Data Pipelines
Databricks

Job description

We are seeking a high-caliber Senior Data Engineer / Data Analyst with a unique blend of modern cloud data engineering expertise and deep roots in Oracle ERP systems. In this role, you will architect, build, and optimize data pipelines that extract high-value financial, supply chain, and operational data from Oracle EBS or Fusion, transforming it within Databricks to drive enterprise-wide analytics.

If you are a hybrid engineer-analyst who can both write complex PySpark jobs and talk intelligently with business stakeholders about Oracle ledger tables, we want to hear from you., * Data Pipeline Engineering: Design, build, and maintain robust, scalable batch and real-time ETL/ELT pipelines to ingest data from Oracle ERP (EBS or Cloud Fusion) into a Databricks Lakehouse environment.

  • Data Analysis & Modeling: Analyze complex Oracle ERP schemas (FND, GL, AP, AR, PO, INV, etc.) to map, clean, and model data for downstream business intelligence and reporting.
  • Performance Optimization: Tune complex SQL queries, optimize Databricks clusters, and manage Delta Lake tables to ensure maximum speed and cost efficiency.
  • Cross-Functional Collaboration: Partner with finance, supply chain, and business analysts to translate complex business requirements into technical data models.
  • Governance & Documentation: Maintain rigorous data documentation, data lineage, and security compliance protocols across cloud and on-premise data estates.

Requirements

  • Experience: 5+ years of dedicated data engineering or data analytics experience, with a heavy emphasis on enterprise ERP data.
  • Oracle ERP Ecosystem: Hands-on, deep technical knowledge of Oracle EBS (R12) or Oracle Cloud Fusion underlying database tables, schemas, and API extraction methods.
  • Databricks Mastery: Proven experience building pipelines within Databricks using PySpark, Scala, or Spark SQL. Deep understanding of Delta Lake architecture.
  • Advanced SQL: Exceptional SQL skills for querying, data manipulation, and performance tuning against massive relational datasets.
  • Cloud Infrastructure: Familiarity with cloud data platforms (AWS, Azure, or Google Cloud Platform) supporting the Databricks environment., * Analytical Mindset: Ability to reverse-engineer messy legacy data structures and transform them into clean, reusable data assets.
  • Communication: Excellent verbal and written communication skills; comfortable presenting technical data concepts to non-technical business partners.

Apply for this position