Oracle Data Engineer - Hybrid (Remote/SA)

Apex Systems; San Antonio (TX); On-site; USD 96,000 - 103,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

ESPP

401K plan

HSA

Job summary

Everforth Apex is seeking an experienced Oracle Data/Database Engineer in San Antonio, TX for a 12-month contract. The role focuses on building scalable Oracle database structures to support customer segmentation, accounts receivable/billing, and reporting within Energy Company’s data ecosystem.

You will migrate processes from flat-files and Alteryx into robust relational databases and document data lineage.

Qualifications

• Strong Oracle database development experience.
• Strong SQL and PL/SQL programming.
• Relational data modeling and design experience.
• Experience developing ingestion, staging and transformation processes.
• Ability to work with interconnected datasets and relational structures.
• Documentation of database structures, logic and lineage.
• Ability to implement access controls for PII data.

Responsibilities

• Extend Oracle data model and staging architecture for customer data across segmentation and AR/billing.
• Implement repeatable ingestion and change-detection in staging layers.
• Build structures to connect customer information across datasets.
• Migrate data processing from flat-files/Alteryx to database structures.
• Maintain documentation around data structures, lineage, and logic.
• Collaborate with SQL developers supporting customer segmentation and AR workstreams.
• Identify opportunities to improve data structures and enforce CPS-approved access controls.

Skills

Oracle database

SQL

PL/SQL

Data modeling

Data ingestion

Documentation

Data lineage

Access controls

Tools

Alteryx

Power BI

Oracle APEX

Medallion-style architecture

Microsoft Fabric

Job description

Everforth Apex is seeking an experienced Oracle Data/Database Engineer in San Antonio, TX for a 12-month contract. The role focuses on building scalable Oracle database structures to support customer segmentation, accounts receivable/billing, and reporting within Energy Company’s data ecosystem.

You will migrate processes from flat-files and Alteryx into robust relational databases and document data lineage.