Knowledge Data Engineer

*W-2 Only and unable to provide sponsorship*

24-Month Contract Role with a Fortune 500 Bank

Hybrid schedule in uptown Charlotte, NC (3 days on-site and 2 days remote each week)

Description

Support the build out of the process management semantic layer. The role focuses on logically connecting business terminology to Oracle database structures, using PDFs, Oracle metadata via Toad, and Python to define business definitions, synonyms, and term-to-data mappings. Over time, the role may extend to documenting basic rules and relationships.

Primary Role Purpose:

The Knowledge / Data Engineer is responsible for building the semantic bridge between process management business language and Oracle data structures. This role converts business terms, definitions, synonyms, source metadata, and documentation into structured mappings that help GenAI interpret user questions and generate accurate database queries.

Key Responsibilities

Business Term and Definition Engineering

• Review process management PDFs, business documents, data dictionaries, and metadata extracts to identify business terms and domain concepts.

• Define clear business definitions for terms used by process management users.

• Identify synonyms, abbreviations, alternate names, and commonly used phrases for each business term.

• Distinguish between similar or overloaded terms that may map to different database structures depending on business context.

• Maintain terminology consistency across the semantic layer and knowledge base repository.

Oracle Metadata Analysis

• Use Toad and Oracle metadata extracts to understand available schemas, tables, columns, keys, and relationships.

• Analyze physical data structures and determine which tables and columns support each business term.

• Identify candidate joins, filters, dimensions, measures, and identifiers needed to answer common process management related questions.

• Work with the Data Architect to validate table relationships, materialized views, and performance-optimized access paths.

Term-to-Data Mapping

• Create mappings from business terms to Oracle tables, columns, views, and materialized views.

• Define mapping metadata such as:

o Business term.

o Business definition.

o Synonyms.

o Source schema.

o Source table or view.

o Source column.

o Data type.

o Join path.

o Filters or conditions.

o Valid values.

o Example user phrases.

o Confidence level.

o Source documentation reference.

• Ensure mappings are precise enough to support natural-language-to-SQL generation.

• Identify gaps where business terms lack clear physical data mappings.

Skills

Data, Data architecture, Data modeling

Top Skills Details

Data,Data architecture,Data modeling

Additional Skills & Qualifications

Knowledge / Data Engineer

This is a Contract position based out of Charlotte, NC.

The pay range for this position is $65.00 - $72.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

This is a hybrid position in Charlotte,NC.

This position is anticipated to close on Jul 1, 2026.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.