Enterprise Data Architect (MDM /Data Catalog/AI)

Remote role based in Texas – only candidates currently residing in Texas will be considered.

About the Role

The Enterprise Data Architect will implement an enterprise-wide Data Catalog/MDM solution covering both structured and unstructured data, and set up and configure the semantic layer and lineage needed for AI tools discovery and enablement. The ideal candidate will bridge data engineering, governance, and AI consumption needs to ensure high-quality, well-documented data assets are available for analytics, machine learning, and generative AI use cases. A continuous process will be established to keep the catalog/MDM solution updated when changes are made and ensure data quality and consistency is maintained. This position will work across various teams.

Responsibilities

• Develop conceptual, logical, and physical models across domains, mapping transformations and integrations to drive clarity across systems.
• Reverse-engineer legacy data structures to modernize, streamline, and rationalize system designs using ER/Studio and model automation to ensure standards and performance.
• Govern design-to-implementation alignment with engineering.
• Expand taxonomy and ontology usage across domains, applying semantic tagging to improve discovery, trust, and reuse.
• Align semantic attributes with lineage and classification rules.
• Maintain and enrich data dictionaries while automating metadata ingestion and scanning processes.
• Apply lineage and classification standards (Purview/Unity Catalog).
• Connect catalog to BI and ETL/ELT pipelines.
• Expand glossary coverage with data stewards.
• Implement catalog APIs for programmatic queries and updates.
• Train users on catalog practices and continuously monitor metadata quality KPIs.
• Translate business needs into structured data designs and metadata deliverables, prioritizing modeling and governance work with product owners.
• Provide status and risk updates; manage dependencies.
• Support business-led analytics and stewardship routines.
• Facilitate design and model reviews while maintaining standards and templates.
• Support cross-enterprise stewardship and governance routines.
• Create training materials and onboarding guides for business users.

Requirements

• 7 years of experience working as an Enterprise Database Architect with MDM/Data Catalog implementation.
• 4 years of experience as a Data Modeler/DBA with Oracle and SQL Server RDBMS.
• 4 years of expertise in various enterprise data catalog platforms like Microsoft Purview, Collibra, or Alation.
• 3 years of experience in AI/ML technologies and semantic/context layer design and integration.
• 3 years of experience with cloud technologies and tools in AWS and Azure, including data platforms like AWS Data Lake.
• 3 years of experience in data governance, classification, and security.
• 2 years of experience with data lineage, integration, and transformation tools like Informatica or Fivetran.
• 2 years of experience in API design for metadata harvesting, automation, and event-driven integration.

Preferred Qualifications

• 2 years of experience with vector databases and feature stores.
• 2 years of experience in scripting using Python.
• 2 years of experience working with Texas state government agencies.
• 1 year of experience using GitHub.