Enterprise Data Catalog & MDM Architect for AI

Asterism IT Solutions; Austin (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

Asterism IT Solutions in Austin, TX is seeking an experienced Database Architect to design and implement an enterprise-wide Data Catalog and Master Data Management solution for both structured and unstructured data.

You will build semantic/context layers and data lineage to support AI tools, analytics, machine learning, and generative AI use cases, bridging data engineering, governance, architecture, and AI consumption requirements.

Qualifications

• 7+ years as Enterprise Database Architect with MDM/Data Catalog experience.
• 4+ years as Data Modeler/DBA working with Oracle and SQL Server.
• 3+ years with AI/ML technologies and semantic layer design.
• 3+ years with cloud technologies in AWS and Azure.
• 2+ years with Data Lineage, integration, and transformation tools.
• 2+ years designing APIs for metadata harvesting and automation.
• 2+ years with vector databases/feature stores preferred.
• 2+ years Python scripting preferred.
• 2+ years experience with Texas State Government agencies preferred.
• 1+ year experience using GitHub.

Responsibilities

• Design and implement an enterprise Data Catalog and MDM solution for structured and unstructured data.
• Define and configure enterprise metadata management and catalog architecture.
• Develop semantic/context layers to support analytics, AI/ML, and generative AI use cases.
• Establish and maintain data lineage across enterprise data sources and platforms.
• Create processes for metadata harvesting and automated catalog updates.
• Ensure data assets are documented, classified, governed, and secured.
• Define data governance standards to maintain data quality and consistency.
• Integrate data catalog/MDM platforms with enterprise data sources and cloud platforms.
• Design APIs and event-driven integrations for metadata harvesting and automation.
• Collaborate with data engineering, governance, security, analytics, and AI teams.
• Support AI tools in discovering and consuming trusted data via semantic/context layers.
• Maintain metadata/catalog information as enterprise systems evolve.
• Design and support data models across Oracle and SQL Server environments.
• Work with AWS and Azure cloud technologies and data platforms.
• Evaluate vector databases and feature stores where applicable.
• Develop Python scripts and automation for metadata processes.
• Maintain architecture standards, documentation, and governance artifacts.
• Use GitHub for source control and collaboration.
• Collaborate with stakeholders to deliver scalable, secure enterprise data solutions.

Skills

MDM/Data Catalog

Oracle

SQL Server

Data Governance

Data Lineage

AI/ML

Semantic Layer

APIs

Python

GitHub

Tools

Microsoft Purview

Collibra

Alation

Informatica

Fivetran

AWS Data Lake

AWS

Azure

Job description

Asterism IT Solutions in Austin, TX is seeking an experienced Database Architect to design and implement an enterprise-wide Data Catalog and Master Data Management solution for both structured and unstructured data.

You will build semantic/context layers and data lineage to support AI tools, analytics, machine learning, and generative AI use cases, bridging data engineering, governance, architecture, and AI consumption requirements.