Data Architect

Computer Task Group, Inc • Dallas, TX

2d

About The Position

CTG is seeking a Data Architect for a client engagement in Dallas, Texas, with a stated duration of four months. The role designs and maintains scalable enterprise data architectures and models for large, complex data environments. It leads conceptual, logical, and physical modeling using Erwin Data Modeler and architects and optimizes Oracle database solutions.

The Data Architect establishes enterprise data standards and governance, metadata management, and data lineage practices. The role defines data movement and processing strategies across middleware, ETL, APIs, and OLAP environments; translates business requirements into technical architecture; communicates design decisions and trade-offs to executive stakeholders; and creates architecture documentation, entity relationship diagrams, and data dictionaries for technical and business audiences.

Requirements

• Expert-level proficiency with Erwin Data Modeler in enterprise environments.
• Advanced Oracle Database expertise, including SQL/PL-SQL, schema design, partitioning, indexing, and performance optimization.
• Strong understanding of relational and dimensional modeling, including normalization, denormalization, cardinality, keys, referential integrity, and star/snowflake schemas.
• Knowledge of data integration, ETL, middleware, APIs, OLAP, and data tracking best practices.
• Expertise in enterprise data governance, metadata management, and data lineage.
• Strong communication, documentation, analytical, and executive stakeholder management skills.
• 10+ years of experience in data architecture, data modeling, or database engineering, including senior or lead-level responsibilities as a Data Architect, Solution Architect, or Data Modeler.
• Proven success designing and optimizing production enterprise data environments handling large volumes, from gigabytes to multiple terabytes.
• Experience establishing enterprise data standards and translating business strategy into scalable technical solutions.
• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent practical experience.
• Excellent verbal and written English communication skills and ability to interact professionally with a diverse group.

Nice To Haves

• Experience in regulated industries such as utilities, financial services, insurance, or healthcare.
• Experience leading or mentoring data modeling teams.
• Familiarity with PostgreSQL, MongoDB, Hadoop, Denodo, ER/Studio, PowerDesigner, Collibra, or Alation.
• Exposure to hybrid on-premises/cloud strategies and Target Operating Model (TOM) design.
• Relevant certifications such as OCI, DAMA, or CDMP.

Responsibilities

• Design and maintain scalable enterprise data architectures and models for large, complex data environments.
• Lead conceptual, logical, and physical data modeling with Erwin Data Modeler, including enterprise model management, subject areas, versioning, and compare/merge activities.
• Architect and optimize Oracle database solutions, including schema design, partitioning, indexing, SQL/PL-SQL, and performance tuning.
• Establish enterprise data standards, governance frameworks, metadata management, and data lineage practices.
• Define data movement and processing strategies across middleware, ETL, APIs, and OLAP environments.
• Translate business requirements into technical architecture and communicate design decisions and trade-offs to executive stakeholders.
• Develop architecture documentation, entity relationship diagrams, and data dictionaries for technical and business audiences.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior