Database Architect

eStaffLLC•Austin, TX

1d•Remote

About The Position

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.

Requirements

7 Years Working as an Enterprise Database Architect with experience with MDM/Data Catalog implementation
4 Years Experience as a Data Modeler/DBA with Oracle and SQL Server RDBMS
4 Years Expertise in various enterprise data catalog platforms like Microsoft Purview, Collibra, Alation, etc.
3 Years Experience in AI/ML technologies and semantic/context layer design and integration.
3 Years Experience with cloud technologies and tools in AWS and Azure, including data platforms like AWS Data Lake
3 Years Data Governance, classification and security
2 Years Data Lineage, Integration and Transformation tools like Informatica, Fivetran, etc.
2 Years Experience in API design in metadata harvesting, automation, and event driven integration
2 Years Vector databases, feature stores experience preferred
2 Years Experience in scripting using Python preferred.
2 Years Experience working with Texas state government agencies preferred.
1 Year Experience using GitHub

Nice To Haves

Vector databases, feature stores experience
Scripting using Python
Working with Texas state government agencies

Responsibilities

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.
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.
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.
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.