AI-First Database Architect for Modern Data & AI

WEX, Inc.; Portland (ME); On-site; USD 140,000 - 210,000; Full time

Job summary

WEX, Inc. is seeking a Senior Database Architect to lead modernization of legacy SQL Server systems and to craft AI-native data architectures, vector databases, and semantic models for AI agents and workflows.

You will design canonical data models, enable event-driven patterns, and guide cross-domain data platforms across SQL Server, PostgreSQL, MongoDB/Cosmos DB, Snowflake, and vector stores.

Qualifications

• 8–12 years in database engineering and architecture.

Responsibilities

• Analyze and decompose large SQL Server stored procedures with embedded business logic and migration plans.

Skills

Legacy modernization

Stored procedures

Data modeling

Vector databases

Semantic modeling

Event-driven patterns

Domain-driven design

AI data infra

SQL Server

Backend tooling

Tools

GitHub Copilot

Cursor

Claude Code

Job description

WEX, Inc. is seeking a Senior Database Architect to lead modernization of legacy SQL Server systems and to craft AI-native data architectures, vector databases, and semantic models for AI agents and workflows.

You will design canonical data models, enable event-driven patterns, and guide cross-domain data platforms across SQL Server, PostgreSQL, MongoDB/Cosmos DB, Snowflake, and vector stores.