Senior AI-First Database Architect

WEX, Inc.

Chicago (IL)

On-site

USD 140,000 - 210,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 in Chicago to modernize legacy SQL Server systems and design AI-native data architectures, vector stores, and semantic models for AI agents.

Lead deconstruction of large stored procedures, craft migration playbooks, architect data platforms across SQL Server, PostgreSQL, MongoDB, Snowflake and vectors, and mentor engineers in domain-driven design.

Qualifications

  • 8-12 years in database engineering and architecture, with enterprise SQL Server exposure.
  • Deep SQL Server expertise: T-SQL, stored procedures, indexing, and performance tuning.
  • Modernization experience: decompose procedures and migrate logic to services.
  • Multi-platform data architecture across relational and NoSQL and analytics platforms.
  • Event-driven patterns: CDC, outbox, event sourcing, CQRS in production.
  • Data modeling: canonical models, dimensional modeling, schema evolution.
  • Ability to design vector-based data solutions for AI retrieval and reasoning.

Responsibilities

  • Analyze and decompose large SQL Server stored procedures with embedded logic.
  • Design patterns separating business rules from data access for thin data layers.
  • Lead refactoring to align structures with domain-driven design and events.
  • Implement event-driven patterns: CDC, outbox, and event sourcing where apt.
  • Architect vector DB solutions and embedding pipelines for AI consumption.
  • Create migration playbooks and tooling for stored procedure modernization.
  • Collaborate with AI/ML teams to align data architecture with agent needs.

Skills

SQL Server
Stored procedures
Data modeling
AI data infrastructure
Vector databases
Event-driven patterns
C# / Java / Python

Tools

Azure SQL
Cosmos DB
Snowflake
Pinecone
Weaviate
pgvector
Kafka

Job description

WEX, Inc. seeks a Senior Database Architect in Chicago to modernize legacy SQL Server systems and design AI-native data architectures, vector stores, and semantic models for AI agents.

Lead deconstruction of large stored procedures, craft migration playbooks, architect data platforms across SQL Server, PostgreSQL, MongoDB, Snowflake and vectors, and mentor engineers in domain-driven design.

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 Data Architect for Legacy Modernization
AI-First Data Architect for Legacy Modernization

WEX Inc. • United States

On-site
USD 150,000 - 230,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
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
AI-Driven Database Architect for Legacy Modernization
AI-Driven Database Architect for Legacy Modernization

WEX • Chicago (IL)

On-site
USD 140,000 - 210,000
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 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
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 DB Engineer: AI-Enabled Data Platforms
Senior Staff DB Engineer: AI-Enabled Data Platforms

WEX • Maine

On-site
USD 166,000 - 204,000