SQL Developer

Ethereum Technologies LLC; 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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

• Analyze existing Alteryx workflows, SQL logic and flat-file reporting processes.
• Develop Oracle SQL and PL/SQL code, including stored procedures that consolidate duplicated logic and implement suitable Alteryx and flat-file transformations within Oracle.
• Determine which Alteryx transformations are appropriate to retain and which can be sustainably moved into Oracle/database procedures.
• Convert appropriate flat-file-based processes into structured database tables and processes.
• Validate converted results against existing outputs through record-count checks, reconciliation of totals, and verification of calculations, filters, rounding rules, and historical treatment.
• Reduce redundant ingestion, processing and transformations across existing workflows.
• Support the customer segmentation and/or accounts receivable reporting workstreams.
• Help create historically trackable datasets supporting trending and future analysis.
• Maintain relationships between datasets so customer information can be analyzed holistically.
• Support data consumed by Power BI and other downstream reporting.
• Thoroughly document:
  • Source-to-target mappings and data lineage.
  • Procedural and transformation logic.
  • Calculations, filters, and rounding rules.
  • Historical tracking and retention logic.
  • Data relationships and source locations.
  • Business definitions and interpretation of reporting outputs.
• Help create transparent processes that business stakeholders can understand and trust.

Required Skills:

• Demonstrated hands-on Oracle SQL and PL/SQL development experience, including stored procedures, complex queries, and data transformation logic.
• Alteryx experience, including the ability to understand and review existing workflows.
• Experience working with relational databases and structured datasets.
• Experience transitioning data/processes from flat-file-based workflows into database structures.
• Strong analytical and troubleshooting skills.
• Strong technical documentation skills.

Relevant / Preferred Experience:

• Power BI experience.
• Data transformation / ETL experience.Accounts receivable, billing or financial reporting data experience.
• Experience working with historical/trending datasets.
• Experience reviewing complex existing workflows and identifying duplication or opportunities for simplification.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.