Please Accept our Privacy Policy
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!