Senior Data Architect, Enterprise Data & Oracle

Computer Task Group; Dallas (TX); On-site; USD 96,000 - 165,000; Full time

Job summary

CTG is seeking a senior Data Architect to design and maintain scalable enterprise data architectures for a Dallas-based engagement. You will lead data modeling with Erwin Data Modeler, optimize Oracle databases, and define governance, metadata, and data lineage practices across ETL, middleware, APIs, and OLAP environments.

You will translate business requirements into technical architecture, document diagrams and data dictionaries, and communicate trade-offs to executives.

Qualifications

• 10+ years of experience in data architecture, data modeling, or database engineering with senior or lead responsibilities.
• Designing and optimizing enterprise data environments handling large volumes (GB to multi-TB).
• Experience establishing enterprise data standards and translating business strategy into scalable technical solutions.
• Experience in regulated industries is preferred.
• Experience mentoring data modeling teams is a plus.
• Familiarity with multiple tools such as PostgreSQL, MongoDB, Hadoop, Denodo, ER/Studio, PowerDesigner, Collibra or Alation.

Responsibilities

• Design and maintain scalable enterprise data architectures and models.
• Lead data modeling using Erwin Data Modeler and enterprise model management.
• Architect and optimize Oracle database solutions including schema design and performance tuning.
• Establish enterprise data standards, governance, metadata management and data lineage.
• Define data movement strategies across ETL, middleware, APIs, and OLAP environments.
• Translate business requirements into technical architecture and communicate trade-offs to executives.
• Develop architecture documentation, ER diagrams, and data dictionaries.

Skills

Erwin Data Modeler

Oracle Database

Relational & dimensional modeling

Data governance & metadata management

Data integration/ETL

Executive stakeholder communication

SQL/PL-SQL

Data architecture leadership

OLAP & data tracking

Education

Bachelor's degree in Computer Science/Information Systems/Data Engineering or related field

OCI, DAMA, or CDMP certifications preferred

Tools

PostgreSQL

MongoDB

Hadoop

Denodo

ER/Studio

PowerDesigner

Collibra

Alation

Job description

CTG is seeking a senior Data Architect to design and maintain scalable enterprise data architectures for a Dallas-based engagement. You will lead data modeling with Erwin Data Modeler, optimize Oracle databases, and define governance, metadata, and data lineage practices across ETL, middleware, APIs, and OLAP environments.

You will translate business requirements into technical architecture, document diagrams and data dictionaries, and communicate trade-offs to executives.