Data Architect

SMARTFOX; Plano (TX); On-site; USD 140,000 - 210,000; Full time

Job summary

SMARTFOX is seeking a Senior Data Architect to shape enterprise data architecture, modeling, and metadata governance in a fast-paced environment. You will design data models, catalogs, and semantic structures to enable GenAI and analytics across the organization.

You will lead metadata onboarding, establish standards, and collaborate with data SMEs while leveraging Oracle databases, Toad tooling, and Git-based CI/CD for automation.

Qualifications

• 8+ years of enterprise data architecture experience.
• Strong Oracle relational databases and enterprise data models.
• Advanced Oracle SQL and PL/SQL proficiency.
• Experience with metadata onboarding, data catalogs, and semantic modeling.
• Familiar with Git, CI/CD, and metadata extraction tools.
• Working knowledge of Python for metadata automation is preferred.

Responsibilities

• Design and maintain enterprise data architecture and Oracle data models.
• Identify and document database schemas, tables, views, columns, keys, relationships, and constraints for analytics.
• Manage metadata onboarding, data catalogs, business glossaries, and semantic modeling.
• Extract, validate, and organize Oracle metadata using SQL scripts, Toad, or dictionary queries.
• Establish metadata standards and collaborate with data SMEs to validate data accuracy.
• Support database scripts and metadata assets using Git, CI/CD practices, and automation tools.

Skills

Data architecture

Data modeling

Metadata management

Oracle SQL

PL/SQL

Git

CI/CD

Python

Semantic modeling

Metadata onboarding

Tools

Toad

Git

CI/CD tools

Job description

Location

Plano, TX (Local Candidates Only)

Key Skills

• Data Architecture and Data Modeling
• Metadata Management and Onboarding
• Oracle SQL and PL/SQL
• Materialized Views and Database Design
• Oracle Metadata Extraction Tools (Toad or equivalent)|

Job Responsibilities

• Design and maintain enterprise data architecture and Oracle data models.
• Identify and document database schemas, tables, views, columns, keys, relationships, and constraints required for GenAI.
• Manage metadata onboarding, data catalogs, business glossaries, and semantic modeling.
• Extract, validate, and organize Oracle metadata using SQL scripts, Toad, or database dictionary queries.
• Establish metadata standards and collaborate with business and data SMEs to validate data accuracy and relevance.
• Support database scripts and metadata assets using Git, CI/CD practices, and automation tools.

Required Qualifications

• 8+ years of experience in enterprise data architecture, database architecture, or data platform architecture.
• Strong experience with Oracle relational databases and enterprise data models.
• Advanced Oracle SQL and a strong understanding of PL/SQL.
• Experience with metadata onboarding, data catalogs, and semantic modeling.
• Experience designing data access patterns for analytics, reporting, or AI-enabled query systems.
• Familiarity with Git, CI/CD, and Oracle metadata extraction tools.
• Working knowledge of Python for metadata extraction and automation is preferred.
• Familiarity with YAML/JSON metadata formats is a plus.