Oracle SQL & PL/SQL Developer | ETL & Data Transformation

Ethereum Technologies; San Antonio (TX); On-site; USD 110,000 - 140,000; Full time

Job summary

Ethereum Technologies seeks a hands-on Data Engineer to optimize data flows across Oracle, Alteryx, and flat-file processes in our San Antonio office. You will analyze existing workflows, translate processes into robust database objects, and consolidate logic in Oracle SQL/PL/SQL.

You will validate results, reduce duplication, and enable Power BI reporting. Documentation and data lineage are essential to align business stakeholders with reliable outputs.

Qualifications

• Hands-on Oracle SQL and PL/SQL development experience including stored procedures.
• Review and understand existing Alteryx workflows.
• Experience with relational databases and structured datasets.
• Experience transitioning flat-file processes into database structures.
• Strong analytical and troubleshooting skills.
• Strong technical documentation skills.

Responsibilities

• Analyze existing Alteryx workflows and SQL logic for optimization.
• Develop Oracle SQL/PL/SQL code including stored procedures to consolidate logic.
• Determine which Alteryx transformations to retain vs. move into Oracle.
• Convert flat-file processes into structured database tables and processes.
• Validate converted results via record-count checks and reconciliations.
• Reduce redundant ingestion, processing, and transformations across workflows.
• Support customer segmentation and accounts receivable reporting workstreams.
• Create historically trackable datasets for trending and analysis.
• Maintain relationships between datasets for holistic analysis.
• Support data for Power BI and downstream reporting.
• Thoroughly document mappings, lineage, logic, and retention rules.

Skills

Oracle SQL

PL/SQL

Stored procedures

Alteryx

Relational databases

Data transformation

Analytical skills

Documentation skills

Tools

Power BI

Job description

Ethereum Technologies seeks a hands-on Data Engineer to optimize data flows across Oracle, Alteryx, and flat-file processes in our San Antonio office. You will analyze existing workflows, translate processes into robust database objects, and consolidate logic in Oracle SQL/PL/SQL.

You will validate results, reduce duplication, and enable Power BI reporting. Documentation and data lineage are essential to align business stakeholders with reliable outputs.