Data Architect Prognity Technologies Dallas, TX Job Details Full-time | Contract From $70 an hour 1 day ago Qualifications Commercial use (data warehousing systems) Schema design Data Architecture Design (Architecture design skills) Mentoring Scalability Metadata Middleware systems PL/SQL Project stakeholder communication Master data management Entity-relationship diagrams Dimensional modeling Full Job Description Seeking a Data Architect (Hybrid | In-Person Interview | Dallas, TX)with 10+ years of experience to lead enterprise data architecture, standards, and governance across Oracle on-premise platforms using Erwin. The role combines strategic ownership with hands-on architecture for complex, multi-TB data environments. Key Responsibilities Define enterprise data strategy, target-state architecture, and modeling standards. Own the Erwin Model Mart, including versioning, subject areas, and complex model merges. Design and review conceptual, logical, physical, and dimensional models. Guide Oracle performance, scalability, indexing, partitioning, and capacity planning. Support data governance, MDM roadmaps, metadata, lineage, and regulatory compliance. Mentor technical teams and present architecture decisions to leadership. Required Skills Deep expertise in Oracle SQL/PL-SQL and Erwin Data Modeler . Proven experience with large-scale databases, OLTP/3NF, and star/snowflake modeling. Strong knowledge of ETL, APIs, middleware, OLAP, and data movement. Experience establishing enterprise governance and data standards. Excellent stakeholder communication and technical leadership; Denodo exposure is valuable. Interested? Send your resume to

Pay:

From $70.00 per hour

Work Location:

Hybrid remote in Dallas, TX 75244