Application Programmer III

Artech LLC

Charlotte, NC

JOB DETAILS
SKILLS
Agile Programming Methodologies, Analysis Skills, Artificial Intelligence (AI), Atlassian JIRA, Banking Regulations, Banking Services, Business Intelligence, Communication Skills, Customer Support/Service, Data Management, Data Modeling, Data Quality, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, Dimensional Modeling, Finance, Financial Services, Identify Issues, Metadata, Multiplatform/Cross-Platform, Oracle, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Power BI, Quality Management, Reporting Dashboards, Risk, Root Cause Analysis, Software Engineering, Tableau, Technical/Engineering Design, Training Data Sets, Treasury, Use Cases, User Interface/Experience (UI/UX)
LOCATION
Charlotte, NC
POSTED
1 day ago

 

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.

About the Company

A

Artech LLC