AI-First Data Architect for Legacy Modernization

WEX Inc.

United States

On-site

USD 150,000 - 230,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

WEX Inc. seeks a Senior Database Architect who combines deep SQL Server expertise with a vision for AI-native data infrastructure. You will modernize legacy stored procedures and migrate logic to domain services to enable scalable AI workflows.

You will design vector databases, embedding pipelines, and semantic models for AI agents, while shaping a cross‑platform data platform across SQL Server, PostgreSQL, MongoDB/Cosmos DB, Snowflake and vector stores.

Qualifications

  • 8–12 years in database engineering and architecture.
  • Deep SQL Server expertise: T-SQL optimization, stored procedures, and performance tuning.
  • Experience decomposing complex stored procedures and migrating logic to services.
  • Multi-platform data architecture across relational, NoSQL, and analytical platforms.
  • Event-driven patterns: CDC, outbox, CQRS, and related practices.

Responsibilities

  • Analyze and decompose large SQL Server stored procedures (1,000+ lines) with embedded business logic.
  • Design patterns to separate business rules from data access and migrate logic to application services.
  • Lead refactoring to align database structures with domain-driven design and events.
  • Implement event-driven patterns to decouple systems from direct DB dependencies.
  • Optimize queries, indexing, and execution plans as part of modernization.
  • Create migration playbooks and tooling for stored procedure modernization.

Skills

SQL Server
T-SQL
Stored procedures
Data modeling
Event-driven
Vector databases
RAG architecture
Semantic modeling
Embedding pipelines
Cross-platform design

Tools

Kafka
Snowflake
MongoDB
Cosmos DB

Job description

WEX Inc. seeks a Senior Database Architect who combines deep SQL Server expertise with a vision for AI-native data infrastructure. You will modernize legacy stored procedures and migrate logic to domain services to enable scalable AI workflows.

You will design vector databases, embedding pipelines, and semantic models for AI agents, while shaping a cross‑platform data platform across SQL Server, PostgreSQL, MongoDB/Cosmos DB, Snowflake and vector stores.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

AI-First Database Architect for Modern Data & AI
AI-First Database Architect for Modern Data & AI

WEX, Inc. • Portland (ME)

On-site
USD 140,000 - 210,000
AI-First Database Architect – Legacy Modernization
AI-First Database Architect – Legacy Modernization

WEX, Inc. • San Francisco (CA)

On-site
USD 180,000 - 260,000
Health, dental, and vision insurance
Retirement savings plan
Paid time off
+3
AI-First Database Architect: Legacy to Vector AI
AI-First Database Architect: Legacy to Vector AI

WEX, Inc. • Dallas (TX)

On-site
USD 150,000 - 230,000
AI-Driven Database Architect for Legacy Modernization
AI-Driven Database Architect for Legacy Modernization

WEX • Chicago (IL)

On-site
USD 140,000 - 210,000
Senior AI-First Database Architect
Senior AI-First Database Architect

WEX, Inc. • Chicago (IL)

On-site
USD 140,000 - 210,000
Senior DB Architect: AI-First Modernization & Vector Data
Senior DB Architect: AI-First Modernization & Vector Data

WEX • Maine

On-site
USD 140,000 - 190,000
Senior Staff Database Engineer: AI-Driven Modernization
Senior Staff Database Engineer: AI-Driven Modernization

WEX • United States

Remote
USD 166,000 - 204,000
Health, dental and vision insurance
401(k) plan
Paid time off
+2
Senior Staff Database Engineer: AI‑Enabled Modernization
Senior Staff Database Engineer: AI‑Enabled Modernization

WEX, Inc. • United States

On-site
USD 166,000 - 204,000
Health, dental and vision insurances
Retirement savings plan
Paid time off
+1
Lead AI-Driven Database Architect - SQL Server
Lead AI-Driven Database Architect - SQL Server

WEX Health, Inc. • Texas

Hybrid
USD 140,000 - 200,000
Senior Staff DB Engineer: AI-Enabled Data Platforms
Senior Staff DB Engineer: AI-Enabled Data Platforms

WEX • Maine

On-site
USD 166,000 - 204,000