Senior Oracle PL/SQL Data Architect & ETL Designer

Apex Systems; Newark (DE); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

401K program

Job summary

Everforth Apex Systems seeks a senior Oracle PL/SQL Data Architect to design data models and optimize ETL workflows for analytics. The role focuses on conceptual, logical, and physical data modeling, PL/SQL development, and data quality across warehouse processes.

You will work in a fast-paced, agile environment on complex datasets, collaborating with cross-functional teams to deliver scalable solutions and provide clear data insights.

Qualifications

• Bachelor's degree or equivalent in a quantitative field such as computer science, mathematics, engineering, or finance.
• A minimum of 10 years of experience in the creation of Oracle PL/SQL and ETL work.
• Expert-level PL/SQL skills.
• Experience with database fine-tuning.
• Strong data analysis skills with the ability to study large amounts of data independently.
• Proficiency in MS SQL Server and MySQL.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Design and create conceptual, logical, and physical data models for analytic data requirements.
• Develop and maintain Oracle PL/SQL code and ETL processes.
• Improve and streamline processes for data flow and data quality to enhance accuracy, viability, and value.
• Perform database fine-tuning and optimization.
• Conduct in-depth data analysis on large datasets to identify patterns and present findings.
• Enhance existing processes and define new, more efficient ones.
• Collaborate as a team member in a fast-paced, agile development environment.
• Work under minimal supervision with general guidance from management.

Skills

Oracle PL/SQL

ETL

Data modeling

MS SQL Server

MySQL

Data analysis

Agile

Communication

Education

Bachelor's degree in a quantitative field

Tools

DataStage

Informatica

Alteryx

Tableau

MicroStrategy

Autosys

Shell scripting

Microsoft Excel

Job description

Everforth Apex Systems seeks a senior Oracle PL/SQL Data Architect to design data models and optimize ETL workflows for analytics. The role focuses on conceptual, logical, and physical data modeling, PL/SQL development, and data quality across warehouse processes.

You will work in a fast-paced, agile environment on complex datasets, collaborating with cross-functional teams to deliver scalable solutions and provide clear data insights.