Application Programmer III

Introduction

We are seeking a Senior Oracle Database Developer with strong experience in global banking data to design, develop, and optimize end-to-end analytical data objects on the Oracle database platform. This role is responsible for building analytics-ready structures starting from staging/ingestion layers through cleansed, conformed models, culminating in high-performing analytical views and reporting objects on the database side.

Required Skills & Qualifications

• 8 years of hands-on experience as an Oracle Database Developer / Data Developer.
• Expert-level Oracle SQL and PL/SQL (complex joins, window functions, CTEs, performance tuning).
• Strong experience building analytics/reporting layers (views, materialized views, aggregates, reporting schemas).
• Proven ability to work with large-scale enterprise data (preferably financial services/global banking).
• Strong understanding of data modeling and database design concepts (dimensional modeling, relational modeling, data vault concepts are a plus).
• Experience improving data quality and implementing repeatable validation frameworks.
• Ability to interpret complex schemas quickly and propose restructure/redesign approaches.
• Strong troubleshooting skills across data pipelines and database objects; ability to perform root-cause analysis.
• Excellent communication skills: can explain technical designs to technical and non-technical stakeholders.
• Prior work experience at client or in client's Industry.
• Applicants must be able to work directly for Artech on W2.

Preferred Skills & Qualifications

• Experience in Treasury, Payments, Risk, Finance, Markets, Client, or Regulatory banking domains.
• Oracle advanced features: partitioning, parallel query, materialized view refresh strategies, advanced indexing.
• Familiarity with enterprise governance concepts: data lineage, metadata management, reference data, master data.
• Experience supporting downstream consumers such as BI/Web dashboards (Power BI/Tableau/custom UI) and AI/ML pipelines (feature generation, curated datasets, prompt-ready structured outputs).
• Exposure to ETL/ELT concepts.
• Experience working in Agile delivery with Jira/Confluence.

Day-to-Day Responsibilities

• Design, build, and optimize Oracle-based analytical data objects from staging/ingestion through cleansed and conformed layers to final reporting-ready structures.
• Create high-performing views, materialized views, aggregates, and reporting schemas that support dashboards, enterprise reporting, and downstream AI/ML-enabled use cases.
• Improve data quality, consistency, lineage, and performance across the Oracle platform.

Company Benefits & Culture

• Comprehensive benefits package.
• Supportive and inclusive work environment.
• Opportunities for professional growth and development.

For immediate consideration please click APPLY to begin the screening process with Alex.