Database Architect

We are seeking a Database Architect who is willing to work on a remote set up with our client in Austin TX. The Database Architect will implement an enterprise-wide Data Catalog/MDM solution covering both structured and unstructured data and setup and configure the semantic layer and lineage needed for AI tools discovery/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 should be established to keep the catalog/mdm solution updated when changes are made and ensure data quality and consistency is maintained.

This position will perform the following duties working across various teams.

Enterprise Data Modeling Semantics & AI Enablement

* Develops conceptual logical physical models across domains.

* Maps transformations & integrations and drive clarity across systems.

* Reverse-engineers legacy data structures to modernize streamline and rationalize system designs.

* Uses ER/Studio & model automation to ensure standards and performance.

* Governs design-to-implementation alignment with engineering.

* Expands taxonomy and ontology usage across domains.

* Applies semantic tagging to improve discovery trust and reuse.

* Aligns semantic attributes with lineage & classification rules.

Data Governance Metadata & Catalog Management

* Maintains and enriches data dictionaries while automating metadata ingestion and scanning processes.

* Applies lineage and classification standards (Purview/Unity Catalog).

* Connects catalog to BI and ETL/ELT pipelines.

* Expands glossary coverage with stewards.

* Implements catalog APIs for programmatic queries/updates.

* Trains users on catalog practices and continuously monitors metadata quality KPIs.

Data Strategy & Readiness

* Translates business needs into structured data designs and metadata deliverables

* Prioritizes modeling/governance work with product owners.

* Provides status & risk updates; manage dependencies.

* Supports business-led analytics and stewardship routines.

Team Enablement & Knowledge Transfer

* Facilitates design/model reviews while maintaining standards and templates.

* Supports cross-enterprise stewardship and governance routines.

* Creates training materials and onboarding guides for business users.

Minimum Requirements:

Yrs Experience

7 Working as an Enterprise Database Architect with experience with MDM/Data Catalog implementation

4 Experience as a Data Modeler/DBA with Oracle and SQL Server RDBMS

4 Expertise in various enterprise data catalog platforms like Microsoft Purview Collibra Alation etc.

3 Experience in AI/ML technologies and semantic/context layer design and integration.

3 Experience with cloud technologies and tools in AWS and Azure including data platforms like AWS Data Lake

3 Data Governance classification and security

2 Data Lineage Integration and Transformation tools like Informatica Fivetran etc.

2 Experience in API design in metadata harvesting automation and event driven integration

2 Vector databases feature stores experience preferred

2 Experience in scripting using Python preferred.

2 Experience working with Texas state government agencies preferred.

1 Experience using GitHub