Database Architect

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

We are seeking an experienced Database Architect to implement an enterprise-wide Data Catalog / Master Data Management (MDM) solution covering both structured and unstructured data.

The Database Architect will be responsible for establishing and configuring the semantic layer and data lineage required to support AI tools, analytics, machine learning, and generative AI use cases.

The ideal candidate will bridge data engineering, data governance, database architecture, and AI consumption requirements to ensure high-quality, well-documented, secure, and accessible data assets.

The candidate will also establish continuous processes to keep the Data Catalog/MDM solution updated as data and systems change while maintaining data quality, consistency, governance, and lineage.

Required Qualifications

• 7+ years of experience working as an Enterprise Database Architect with experience implementing MDM/Data Catalog solutions.
• 4+ years of experience as a Data Modeler/DBA working with Oracle and SQL Server RDBMS.
• 4+ years of expertise with enterprise Data Catalog platforms, such as:
  • Microsoft Purview
  • Collibra
  • Alation
  • Similar enterprise data catalog solutions
• 3+ years of experience with AI/ML technologies and semantic/context layer design and integration.
• 3+ years of experience with cloud technologies and tools in AWS and Azure.
• Experience with cloud data platforms such as AWS Data Lake.
• 3+ years of experience with Data Governance, data classification, and data security.
• 2+ years of experience with Data Lineage, integration, and transformation tools, such as:
  • Informatica
  • Fivetran
  • Similar tools
• 2+ years of experience designing and implementing APIs for:
  • Metadata harvesting
  • Automation
  • Event-driven integration
• 2+ years of experience with vector databases and/or feature stores is preferred.
• 2+ years of experience with Python scripting is preferred.
• 2+ years of experience working with Texas State Government agencies is preferred.
• 1+ year of experience using GitHub.

Key Responsibilities

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

Preferred Qualifications

• Experience working with Texas State Government agencies.
• Experience implementing enterprise MDM/Data Catalog solutions in large organizations.
• Experience with AI/ML and generative AI data enablement.
• Experience with semantic/context layers and metadata-driven AI discovery.
• Experience with vector databases and feature stores.
• Strong understanding of enterprise data governance and security.
• Strong communication, analytical, and problem-solving skills.

Key Skills

Database Architecture, Enterprise Data Architecture, MDM, Master Data Management, Data Catalog, Microsoft Purview, Collibra, Alation, Oracle, SQL Server, Data Modeling, DBA, AI/ML, Semantic Layer, Context Layer, AWS, Azure, AWS Data Lake, Data Governance, Data Classification, Data Security, Data Lineage, Informatica, Fivetran, API Design, Metadata Harvesting, Event-Driven Integration, Vector Databases, Feature Stores, Python, GitHub