Job Description
Job Description
Overview
CTG is seeking to fill a Data Architect position for our client.
Location: Dallas, TX
Duration: 4 months
Duties:
-
Design and maintain scalable enterprise data architectures and models supporting large, complex data environments.
-
Lead conceptual, logical, and physical data modeling using 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.
Skills:
-
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.
Experience:
-
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 enterprise data environments handling large volumes (GB to multi-TB) in production.
-
Experience establishing enterprise data standards and translating business strategy into scalable technical solutions.
-
Experience in regulated industries such as utilities, financial services, insurance, or healthcare is preferred.
-
Experience leading or mentoring data modeling teams is a plus.
-
Familiarity with PostgreSQL, MongoDB, Hadoop, Denodo, ER/Studio, PowerDesigner, Collibra, or Alation is desirable.
-
Exposure to hybrid on-premises/cloud strategies and Target Operating Model (TOM) design is a plus.
Education:
-
Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent practical experience.
-
Relevant certifications such as OCI, DAMA, or CDMP are preferred.
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.
CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.
To Apply:
To be considered, please apply directly to this requisition using the link provided. Kindly forward this to any other interested parties. Thank you!