Data Architect

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 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.

About CTG

CTG, a Cegeka company, delivers IT and business solutions that enhance clients' digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years' experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.

Together, we shape what's next-working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you'll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com .

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws (https://app.jjkellerlaborlawposters.com/posters/47CA3D44-BAE1-419C-B36D-4487C9A0D66B?mapView=mapEnglishView) .

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.