Principal Consultant | Energy Oil & Gas - Upstream | E&P Data Management

Pay Rate Range: $ 50.35 - 51.83/hr on W2

Description:

Job Title:

Principal Consultant | Databricks
Work Location & Reporting Address:
Houston, TX 77006 – Hybrid Onsite (10 days onsite in a month)
Do you consider candidate/s who are willing to relocate? Yes
Contract duration: 6 months
Target

Start Date:

01 May 2026
Does this position require Visa independent candidates only? Yes

Interview Process (Is face to face required?)
*** and Client interview are both video interviews.

Job Details:

Minimum years of experience required: 8+ years
Certification needed:
Not mandatory

Must Have Skills:

• Databricks

• Cloud and Data Platform Architechture

• Stakeholder management

Nice to Have Skills:

• Data Warehousing

• DevOPs

Detailed Job Description:

Job Summary:
We are seeking a skilled Data Engineer / Data Analyst with strong hands-on experience in Databricks, SQL, and Oracle E-Business Suite (EBS). The role involves designing and maintaining data pipelines, performing advanced data analysis, and enabling enterprise analytics by integrating ERP data with modern cloud platforms.

Key Responsibilities:

• Design and develop scalable data pipelines using Databricks (Apache Spark) and Delta Lake.

• Write and optimize complex SQL queries for data processing and analysis.

• Work hands-on with Oracle EBS R12 data models across Finance, PTP, and OTC modules.

• Perform data extraction, transformation, validation, and reconciliation.

• Support reporting and analytics requirements for business stakeholders.

• Collaborate with cross-functional teams and follow data governance best practices.

Required Skills:

• Strong hands-on experience with Databricks and Apache Spark.

• Advanced SQL expertise.

• Solid experience with Oracle EBS R12 database schema.

• Strong understanding of ERP business processes.

• Excellent analytical and communication skills.

Preferred Skills:

• Experience with cloud platforms (AWS, Azure, or GCP).

• Exposure to BI tools such as Power BI or Tableau.

• Knowledge of Python or PySpark.

• Understanding of data governance and security standards.

Soft Skills:

• Strong problem-solving abilities.

• Ability to work independently and in cross-functional teams.

• Good stakeholder communication and documentation skills.