Database Architect 2

Client: TEA



Job ID: 70127058



Employment Type: Full-Time / Contract



Work Location: 100% Remote (Telework - Any Location)

Important Submission Requirement: For the safety and security of our clients and their systems, any candidate resume submitted MUST include a photo ID of the candidate placed at the very beginning of the resume. Any resume submitted without a photo ID will be immediately eliminated from consideration. (Note: Any and all travel, per diem, parking, and/or living expenses shall be at the worker's expense).

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.

Key Responsibilities:

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

Required Experience:

• 7 Years: Working as an Enterprise Database Architect 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.

Preferred Experience:

• 2 Years: Vector databases, feature stores experience.
• 2 Years: Experience in scripting using Python.
• 2 Years: Experience working with Texas state government agencies.
• 1 Year: Experience using GitHub.