Application Programmer II Job Plano area,Texas USA,IT/Tech

Location:

Plano, TX

Salary Range:

Competitive salary based on experience and qualifications

Introduction

The role is responsible for building a semantic bridge between process management business language and process management application Oracle data structures. This involves converting business terms, definitions, synonyms, source metadata, and documentation into structured mappings that assist GenAI in interpreting user questions and generating accurate database queries.

Required

Skills & Qualifications

4 years of experience in data engineering, metadata engineering, semantic layer development, data analysis, or business data mapping.
Hands-on experience working with Oracle database metadata.
Experience connecting business terminology to physical database structures.
Experience working with business documentation, PDFs, data dictionaries, and technical metadata.
Exposure to natural-language-to-SQL, semantic modeling, or AI context engineering is strongly preferred.

Preferred

Skills & Qualifications (Nice-to-have skills but are not required)

Experience with enterprise process management systems (POP, ARIS, SDAR)
Exposure to GenAI platforms and LLM-based enterprise solutions
Knowledge of regulatory and compliance-driven data environments
Experience with data catalog tools, vector search, graph database, or RAG tooling
Prior work experience at client or in client's industry
Applicants must be able to work directly for Artech on W2

Day-to-Day Responsibilities (key tasks and expectations for the role)

Review strategic process inventory (SPI) PDFs, business documents, data dictionaries, and metadata extracts to identify business terms and domain concepts.
Define clear business definitions for terms used by SPI users and maintain terminology consistency across the semantic layer and knowledge base repository.
Use Toad and Oracle metadata extracts to understand available schemas, tables, columns, keys, and relationships.
Create mappings from business terms to Oracle tables, columns, views, and materialized views.
Collaborate with the AI Context Engineer and AI Platform Engineer to publish validated mappings into the Knowledge Base Repository and test whether published mappings are correctly consumed by the GenAI platform.
Test sample natural-language questions against expected table and column mappings and support iterative improvements based on testing, SME feedback, and GenAI query results.

Company Benefits & Culture

Competitive benefits package including health, dental, and vision insurance
Opportunities for professional development and career advancement
Inclusive and collaborative work environment

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