Oracle SQL Developer - Remote Mon & Fri

Apex Systems; San Antonio (TX); Hybrid; USD 84,000 - 103,000; Full time

Job summary

Everforth Apex is seeking two SQL Developers in San Antonio, TX, to modernize customer data and reporting processes. The role focuses on moving Alteryx and flat-file logic into an Oracle database environment, with emphasis on data transformation, validation, and data lineage.

Responsibilities include developing Oracle SQL/PL/SQL, reviewing Alteryx workflows, creating structured datasets, and supporting Power BI reporting.

Qualifications

• Hands-on Oracle SQL and PL/SQL development experience, including stored procedures and complex queries.
• Alteryx workflow understanding and review experience.

Responsibilities

• Analyze existing Alteryx workflows, SQL logic and flat-file reporting processes.
• Develop Oracle SQL and PL/SQL code, including stored procedures to consolidate logic.
• Determine which Alteryx transformations to retain and which to move into Oracle/database procedures.
• Convert flat-file processes into structured database tables and processes.
• Validate converted results against outputs using record-count checks and reconciliation.
• Support Power BI and other downstream reporting and data lineage documentation.

Skills

Oracle SQL

PL/SQL

Alteryx

Power BI

Data analysis

Troubleshooting

Tools

Oracle Database

ETL tools

Job description

Everforth Apex is seeking two SQL Developers in San Antonio, TX, to modernize customer data and reporting processes. The role focuses on moving Alteryx and flat-file logic into an Oracle database environment, with emphasis on data transformation, validation, and data lineage.

Responsibilities include developing Oracle SQL/PL/SQL, reviewing Alteryx workflows, creating structured datasets, and supporting Power BI reporting.