Oracle PL/SQL Data Architect

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

Oracle PL/SQL Data Architect

Job#: 3055807

Location: Newark, Delaware (On-site)

Role Overview

We are seeking an Application Architect with extensive experience in Oracle PL/SQL and ETL processes. This role involves designing conceptual, logical, and physical data models to support data warehousing needs. The ideal candidate will be adept at working with both upstream source of record systems and downstream data models, ensuring data integrity and optimizing data flow.

Key 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.

Required Qualifications

• Education: Bachelor's degree or equivalent in a quantitative field such as computer science, mathematics, engineering, or finance.
• Experience: 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.

Preferred Qualifications

• Knowledge of ETL tools such as DataStage, Informatica, or Alteryx.
• Familiarity with BI tools like Tableau or MicroStrategy.
• Experience with job scheduling tools, for example, Autosys or Shell scripts.
• Proficiency in Microsoft Excel.

The company, Everforth Apex, is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Benefits Overview

• Medical benefits
• Dental benefits
• Vision benefits
• Life insurance
• Disability insurance
• Other insurance plans that offer an optional layer of financial protection
• ESPP (employee stock purchase program)
• 401K program, allowing contribution typically within 30 days of starting, with a company match after 12 months of tenure
• HSA (Health Savings Account on the HDHP plan)
• SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions
• Corporate discount savings program and other discounts
• On-demand training program
• Certification prep access
• Library of technical and leadership courses/books/seminars once you have 6+ months of tenure
• Certification discounts and other perks to associations that include CompTIA and IIBA
• Dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach
• Full list of benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Everforth Apex team member can provide

Equal Opportunity Employer

Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.

If you require an accommodation under the Americans with Disabilities Act to participate in an interview with a virtual recruiter or to use our website for a search or application, please contact our Benefits Department at [emailprotected] or 804-523-8228. Please note that this contact information is strictly to be used for medical ADA accommodations and that no other inquiries will be answered.

UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems.