Back to jobs

Senior Database Architect

Pay
Pay not listedSimilar roles state $127K–$189K
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Design vector database solutions and embedding pipelines for RAG implementations

  • Design semantic data models that AI agents can retrieve and reason over

  • Implement event-driven patterns such as CDC, outbox, and event sourcing to decouple systems from the database

  • Optimize query performance, indexing, and execution plans during modernization

From the employer’s posting
Architect vector database solutions for RAG implementations: embedding strategies, chunking approaches, similarity search optimization, and hybrid retrieval patterns
Design semantic data models that capture domain knowledge in structures optimized for AI retrieval and reasoning
Implement event-driven patterns that decouple systems from direct database dependencies: change data capture, outbox patterns, event sourcing where appropriate
Optimize query performance, indexing strategies, and execution plans as part of modernization efforts

What you’ll bring

All qualifications

Core experience

  • 8–12 years in database engineering and architecture, with significant experience in enterprise-scale SQL Server environments
  • Understanding of embedding pipelines: text preprocessing, embedding generation, vector indexing, and incremental updates
  • 2+ years actively using AI coding assistants for database work; deep understanding of how to prompt effectively for SQL and data engineering tasks
  • Understanding of domain-driven design and how data architecture supports bounded contexts
  • Deep SQL Server expertise: T-SQL optimization, stored procedure design and refactoring, query plan analysis, indexing strategies, and performance tuning
  • Familiarity with LLM context requirements: what data AI agents need, token constraints, context window optimization

Preferred experience

  • Experience building RAG systems or AI-powered search/retrieval applications
  • Knowledge graph experience: Neo4j, Amazon Neptune, or similar graph databases
  • Experience mentoring engineers or leading database/data architecture communities of practice
Qualification wording
8–12 years in database engineering and architecture, with significant experience in enterprise-scale SQL Server environments
Understanding of embedding pipelines: text preprocessing, embedding generation, vector indexing, and incremental updates
2+ years actively using AI coding assistants for database work; deep understanding of how to prompt effectively for SQL and data engineering tasks
Understanding of domain-driven design and how data architecture supports bounded contexts
Deep SQL Server expertise: T-SQL optimization, stored procedure design and refactoring, query plan analysis, indexing strategies, and performance tuning
Familiarity with LLM context requirements: what data AI agents need, token constraints, context window optimization
Experience building RAG systems or AI-powered search/retrieval applications
Knowledge graph experience: Neo4j, Amazon Neptune, or similar graph databases
Experience mentoring engineers or leading database/data architecture communities of practice
Apply at WEX

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 3, 202679 days ago
Recorded sightings
159
Last seen by us
Nov 16, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$189K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 79

Up longer than most. Similar jobs usually come down between day 6 and day 56.

Well past WEX’s usual: its jobs come down by about day 31.

From 14,770 similar postings that came down, and 16 of WEX’s. Coming down is not always a hire.

WEX is hiring

12 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring has slowed
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • C#
  • Java
  • Python
  • SQL
  • T-SQL
  • AWS
  • Azure
  • Kafka
  • MongoDB
  • Neo4j
  • NoSQL
  • PostgreSQL
  • Snowflake
  • SQL Server
  • Terraform
Where the posting names them
Technical Depth - Strong programming skills in at least one backend language (C#, Java, Python) for building migration tooling, embedding pipelines, and services - Cloud data services experience: Azure SQL, Cosmos DB, Azure AI Search, Azure Synapse, Snowflake, or AWS equivalents
Legacy Database Modernization - Analyze and decompose large SQL Server stored procedures (1,000+ lines) with embedded business logic, creating migration strategies that extract logic into domain services - Design patterns for separating business rules from data access, enabling stored procedures to become thin data-access layers while business logic moves to application services
- Design canonical data models and schemas that are flexible, extensible, and aligned with business domain concepts - Architect data solutions across multiple platforms: SQL Server, PostgreSQL, MongoDB/Cosmos DB, Snowflake, and vector databases (Pinecone, Weaviate, pgvector, Azure AI Search) - Design event-driven data flows: Kafka-based event streaming, materialized views, CQRS patterns, and real-time data synchronization
Required Experience - 8–12 years in database engineering and architecture, with significant experience in enterprise-scale SQL Server environments - Deep SQL Server expertise: T-SQL optimization, stored procedure design and refactoring, query plan analysis, indexing strategies, and performance tuning
- 8–12 years in database engineering and architecture, with significant experience in enterprise-scale SQL Server environments - Deep SQL Server expertise: T-SQL optimization, stored procedure design and refactoring, query plan analysis, indexing strategies, and performance tuning - Hands-on modernization experience: track record of decomposing complex stored procedures and migrating business logic to application services
- Hands-on modernization experience: track record of decomposing complex stored procedures and migrating business logic to application services - Multi-platform data architecture: experience designing solutions across relational (SQL Server, PostgreSQL), NoSQL (MongoDB, Cosmos DB), and analytical (Snowflake, data lakehouse) platforms - Event-driven data patterns: CDC, Kafka, outbox pattern, event sourcing, CQRS—practical experience implementing these in production
AI-Native Engineering Practices - 2+ years actively using AI coding assistants for database work; deep understanding of how to prompt effectively for SQL and data engineering tasks - Experience building tools, scripts, or automation that leverage AI/LLM capabilities
- Strong programming skills in at least one backend language (C#, Java, Python) for building migration tooling, embedding pipelines, and services - Cloud data services experience: Azure SQL, Cosmos DB, Azure AI Search, Azure Synapse, Snowflake, or AWS equivalents - Infrastructure-as-code for data platforms: Terraform, ARM/Bicep, or CloudFormation
AI & Semantic Data Competencies - Vector database experience: hands-on with at least one vector DB (Pinecone, Weaviate, Milvus, pgvector, Azure AI Search, or similar) - RAG architecture understanding: embedding models, chunking strategies, retrieval optimization, hybrid search, and reranking patterns
- Architect data solutions across multiple platforms: SQL Server, PostgreSQL, MongoDB/Cosmos DB, Snowflake, and vector databases (Pinecone, Weaviate, pgvector, Azure AI Search) - Design event-driven data flows: Kafka-based event streaming, materialized views, CQRS patterns, and real-time data synchronization - Establish data platform infrastructure patterns: data pipelines, ETL/ELT orchestration, data quality frameworks, and observability
- Multi-platform data architecture: experience designing solutions across relational (SQL Server, PostgreSQL), NoSQL (MongoDB, Cosmos DB), and analytical (Snowflake, data lakehouse) platforms - Event-driven data patterns: CDC, Kafka, outbox pattern, event sourcing, CQRS—practical experience implementing these in production - Data modeling expertise: canonical models, dimensional modeling, schema evolution, and designing for extensibility
- Experience building RAG systems or AI-powered search/retrieval applications - Knowledge graph experience: Neo4j, Amazon Neptune, or similar graph databases - Contributions to database tooling, AI/ML data infrastructure, or open-source projects
- Cloud data services experience: Azure SQL, Cosmos DB, Azure AI Search, Azure Synapse, Snowflake, or AWS equivalents - Infrastructure-as-code for data platforms: Terraform, ARM/Bicep, or CloudFormation - Understanding of domain-driven design and how data architecture supports bounded contexts

Your next step

Complete your application on wexinc.wd5.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

We are seeking a Senior Database Architect who combines deep expertise in legacy database systems with forward-looking vision for AI-native data architecture. You'll lead the decomposition of complex stored procedures while simultaneously designing the vector databases, embedding strategies, and semantic models that power our AI agents and workflows.

This is an AI-first role in two senses: you'll leverage AI to accelerate your own work (stored procedure analysis, migration generation, schema documentation), and you'll design the data infrastructure that AI systems depend on. If you're excited about both solving hard legacy database problems and architecting the data layer for AI-native applications, this role is for you.

What You'll Do

Legacy Database Modernization

  • Analyze and decompose large SQL Server stored procedures (1,000+ lines) with embedded business logic, creating migration strategies that extract logic into domain services

  • Design patterns for separating business rules from data access, enabling stored procedures to become thin data-access layers while business logic moves to application services

  • Lead refactoring efforts that align database structures with domain-driven design: bounded contexts, aggregates, and domain events

  • Implement event-driven patterns that decouple systems from direct database dependencies: change data capture, outbox patterns, event sourcing where appropriate

  • Optimize query performance, indexing strategies, and execution plans as part of modernization efforts

  • Create migration playbooks and tooling that engineering teams can apply to their own stored procedure modernization

AI Data Infrastructure & Semantic Modeling

  • Design semantic data models that capture domain knowledge in structures optimized for AI retrieval and reasoning

  • Architect vector database solutions for RAG implementations: embedding strategies, chunking approaches, similarity search optimization, and hybrid retrieval patterns

  • Design and implement embedding pipelines that transform domain content into vector representations suitable for AI agent consumption

  • Establish knowledge graph patterns where appropriate: entity relationships, ontologies, and graph-based retrieval for complex domain reasoning

  • Define data architectures for AI agent context: what data agents need, how it's structured, how freshness and consistency are maintained

  • Design evaluation frameworks for RAG quality: retrieval accuracy, relevance scoring, and feedback loops for continuous improvement

Modern Data Platform Architecture

  • Design canonical data models and schemas that are flexible, extensible, and aligned with business domain concepts

  • Architect data solutions across multiple platforms: SQL Server, PostgreSQL, MongoDB/Cosmos DB, Snowflake, and vector databases (Pinecone, Weaviate, pgvector, Azure AI Search)

  • Design event-driven data flows: Kafka-based event streaming, materialized views, CQRS patterns, and real-time data synchronization

  • Establish data platform infrastructure patterns: data pipelines, ETL/ELT orchestration, data quality frameworks, and observability

  • Define data residency, partitioning, and multi-region strategies for performance and compliance

  • Create reference architectures for common data patterns that domain teams can adopt

AI-First Database Engineering

  • Leverage AI coding assistants (GitHub Copilot, Cursor, Claude Code) to accelerate stored procedure analysis, refactoring, and migration

  • Build AI-powered tools for database engineering: automated stored procedure analysis, schema documentation generators, migration assistants, and query optimization recommenders

  • Create AI-consumable artifacts: structured documentation, annotated schemas, and context files that enable AI agents to understand and work with database systems

  • Author database architecture skills that encode patterns, constraints, and best practices for AI-assisted development

  • Develop prompts, workflows, and tooling that help engineering teams apply AI effectively to database modernization tasks

Cross-Domain Leadership

  • Partner with AI/ML teams to ensure data architecture supports agent and workflow requirements

  • Collaborate with domain teams to understand their data requirements and design solutions aligned with domain ownership

  • Work with application architects to ensure data architecture supports service-oriented and event-driven designs

  • Contribute to Enterprise Architecture Council (EAC) standards for data architecture, modeling conventions, and technology selection

  • Mentor engineers on database design, optimization, semantic modeling, and AI data infrastructure

What You'll Bring

Required Experience

  • 8–12 years in database engineering and architecture, with significant experience in enterprise-scale SQL Server environments

  • Deep SQL Server expertise: T-SQL optimization, stored procedure design and refactoring, query plan analysis, indexing strategies, and performance tuning

  • Hands-on modernization experience: track record of decomposing complex stored procedures and migrating business logic to application services

  • Multi-platform data architecture: experience designing solutions across relational (SQL Server, PostgreSQL), NoSQL (MongoDB, Cosmos DB), and analytical (Snowflake, data lakehouse) platforms

  • Event-driven data patterns: CDC, Kafka, outbox pattern, event sourcing, CQRS—practical experience implementing these in production

  • Data modeling expertise: canonical models, dimensional modeling, schema evolution, and designing for extensibility

AI & Semantic Data Competencies

  • Vector database experience: hands-on with at least one vector DB (Pinecone, Weaviate, Milvus, pgvector, Azure AI Search, or similar)

  • RAG architecture understanding: embedding models, chunking strategies, retrieval optimization, hybrid search, and reranking patterns

  • Semantic modeling: experience designing data structures optimized for AI retrieval—knowledge representation, ontologies, or domain-specific schemas for AI consumption

  • Understanding of embedding pipelines: text preprocessing, embedding generation, vector indexing, and incremental updates

  • Familiarity with LLM context requirements: what data AI agents need, token constraints, context window optimization

AI-Native Engineering Practices

  • 2+ years actively using AI coding assistants for database work; deep understanding of how to prompt effectively for SQL and data engineering tasks

  • Experience building tools, scripts, or automation that leverage AI/LLM capabilities

  • Familiarity with structured artifact creation for AI consumption: documented schemas, annotated procedures, context files

  • Vision for AI-assisted database engineering and ability to build tooling that enables it

Technical Depth

  • Strong programming skills in at least one backend language (C#, Java, Python) for building migration tooling, embedding pipelines, and services

  • Cloud data services experience: Azure SQL, Cosmos DB, Azure AI Search, Azure Synapse, Snowflake, or AWS equivalents

  • Infrastructure-as-code for data platforms: Terraform, ARM/Bicep, or CloudFormation

  • Understanding of domain-driven design and how data architecture supports bounded contexts

  • Familiarity with data governance, lineage, and compliance requirements (HIPAA, PCI-DSS)

Preferred Experience

  • Background in healthcare, benefits, payments, or similarly regulated industries

  • Experience building RAG systems or AI-powered search/retrieval applications

  • Knowledge graph experience: Neo4j, Amazon Neptune, or similar graph databases

  • Contributions to database tooling, AI/ML data infrastructure, or open-source projects

  • Experience mentoring engineers or leading database/data architecture communities of practice

The base pay range represents the anticipated low and high end of the pay range for this position. Actual pay rates will vary and will be based on various factors, such as your qualifications, skills, competencies, and proficiency for the role. Base pay is one component of WEX's total compensation package. Most sales positions are eligible for commission under the terms of an applicable plan. Non-sales roles are typically eligible for a quarterly or annual bonus based on their role and applicable plan. WEX's comprehensive and market competitive benefits are designed to support your personal and professional well-being. Benefits include health, dental and vision insurances, retirement savings plan, paid time off, health savings account, flexible spending accounts, life insurance, disability insurance, tuition reimbursement, and more. For more information, check out the "About Us" section.

About WEX

People
About 6,600 in 2025, up 2% from the year before.Annual report (SEC Form 10-K)
Company
Listed as WEX.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Portland, ME

- Design semantic data models that capture domain knowledge in structures optimized for AI retrieval and reasoning - Architect vector database solutions for RAG implementations: embedding strategies, chunking approaches, similarity search optimization, and hybrid retrieval patterns - Design and implement embedding pipelines that transform domain content into vector representations suitable for AI agent consumption
More source context
- Vector database experience: hands-on with at least one vector DB (Pinecone, Weaviate, Milvus, pgvector, Azure AI Search, or similar) - RAG architecture understanding: embedding models, chunking strategies, retrieval optimization, hybrid search, and reranking patterns - Semantic modeling: experience designing data structures optimized for AI retrieval—knowledge representation, ontologies, or domain-specific schemas for AI consumption
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.