Database Infrastructure & Data Architecture Consultant – Remote

GENERAL FUNCTION / SUMMARY

We are seeking an experienced Database InfrastructureData Architecture Consultant to design and implement company-level data architecture for a financial sales and services company covering insurance, tax, investment, and lending services.

The consultant will be responsible for developing a scalable, secure, and flexible database infrastructure that supports operational systems, analytics, and long-term data management.

The role requires expertise across multiple database technologies, including SQL and NoSQL systems, and experience designing multi-layer data architectures such as operational databases, data warehouses, and data lakes. The consultant should have hands-on experience with major database platforms and cloud environments, including systems such as MongoDB, Azure, and Google Cloud, and should be able to recommend the appropriate architecture for both cloud-based and on-premise environments.

This role requires deep expertise across major database technologies, cloud platforms, data security, and enterprise data governance, and the ability to provide strategic guidance to executive leadership on the company's long-term data strategy.

• Bilingual in English and Chinese preferred

KEY RESPONSIBILITIES

Enterprise Data Architecture Design

• Design and document a scalable company-wide database architecture that supports operational systems, reporting, analytics, and future business growth.
• Develop a multi-layer data architecture, which may include transactional databases, data warehouses, data lakes, and analytical data marts.
• Define data models, schema structures, and system relationships across different data environments.
• Support future business applications by designing data structures that go beyond basic document storage and retrieval, enabling efficient multi-level and multi-category data modeling to support analytics, AI, and intelligent business insights.
• Develop and manage a unified enterprise Document / Knowledge Repository to centrally organize business documents, policies, and data-related materials, with capabilities such as efficient search, access control, version management, and cross-system integration to improve information accessibility and collaboration.
• Provide architecture diagrams, documentation, and implementation guidelines.

Database Platform EvaluationSelection

• Evaluate and recommend appropriate database technologies across both SQL and NoSQL platforms.
• Design database structures that leverage multiple well-established database platforms depending on use cases.
• Ensure the architecture supports flexibility, scalability, and long-term technology evolution.

Multi-PlatformHybrid Infrastructure Strategy

• Design database infrastructure that can operate across cloud environments and on-premise systems.
• Provide architecture recommendations for major cloud platforms such as Microsoft Azure, Google Cloud Platform (GCP), and other cloud database services.
• Design hybrid architectures that allow secure and efficient data operations across cloud and local systems.

Data Integration Framework

• Design the overall data integration framework connecting internal platforms, external systems, and partner integrations.
• Define strategies for data ingestion, data pipelines, synchronization, and data flow management across multiple systems.
• Ensure data consistency, reliability, and accessibility across the organization.

Database SecurityData Protection

• Design and implement database security architecture, including access control policies and role-based permissions.
• Develop architectural controls to minimize risks of data leakage, unauthorized access, and data breaches.
• Implement encryption, audit logging, monitoring, and security best practices for sensitive data.
• Ensure compliance with industry data protection standards and regulatory requirements.

Performance, ReliabilityData Governance

• Design systems to ensure high availability, scalability, backup, and disaster recovery capabilities.
• Define best practices for database performance optimization, indexing strategies, and workload management.
• Ensure the architecture supports future growth, advanced analytics, and AI-driven applications.
• Establish data governance standards, including data quality, ownership, monitoring, and lifecycle management.

Technical LeadershipAdvisory

• Provide strategic guidance on long-term database infrastructure and data architecture development.
• Collaborate with engineering, product, and business teams to ensure the data architecture supports business operations and analytics needs.
• Provide technical recommendations for future system expansion and technology adoption.

JOB TYPE

Consulting / Contract

CONTRACT LENGTH

Phase 1: Database Infrastructure Design – 3 months

Phase 2: Database Deployment – 3 to 6 months

WHO WE ARE

With over 30 years of experience, TransGlobal has grown into the largest Asian-focused, all-in-one financial services platform in the U.S. We offer a comprehensive suite of services-including life and health insurance, annuities, real estate, private lending, tax and estate planning, and investment management-through a network of 30+ branches across 14 states and over 5,000 professional independent agents. Our mission is to deliver trustworthy, customer-centric financial solutions, all in your language and aligned with your goals.

WHY JOIN US

• Industry Leader: Join the nation's largest Asian-focused financial services firm with a well-established brand and expansive network.
• MultilingualMulticultural: Work in a dynamic, diverse environment that understands and serves multicultural communities.
• Career Growth: Access to cross-functional training, licensing support, and professional development opportunities.
• Collaborative Culture: Be part of a supportive team that values innovation, initiative, and shared success.
• Impactful Work: Help individuals and families achieve financial security and generational wealth.