2 days ago
Base Salary
$166k - $204k/yr
Responsibilities
- Design, develop, optimize, and modernize large-scale Microsoft SQL Server databases and data platforms.
- Analyze and refactor T-SQL, stored procedures, functions, execution plans, indexes, and database logic to improve performance and scalability.
- Lead database migrations, schema improvements, replication, synchronization, CDC, outbox patterns, and event publishing while maintaining data integrity.
- Develop data pipelines and integration patterns across SQL Server, PostgreSQL, Snowflake, and cloud data services for OLTP and OLAP environments.
- Build AI-enabled database tooling and infrastructure involving embeddings, vector databases, semantic search, retrieval systems, and agentic workflows.
- Diagnose and resolve high-impact production issues using logs, database metrics, resource utilization, execution plans, and observability data.
- Independently lead complex initiatives from problem definition through production implementation and provide technical guidance through reviews, design discussions, standards, and mentoring.
- Partner with application engineering, SRE, operations, architecture, and AI/ML teams on business-critical data systems.
Requirements
- 15+ years of experience in database engineering, data platform engineering, software engineering, or a related technical discipline.
- Deep hands-on experience with Microsoft SQL Server and T-SQL, including stored procedures, query optimization, execution-plan analysis, indexing, and performance tuning.
- Demonstrated experience modernizing or refactoring legacy database systems and supporting large-scale, high-volume, business-critical environments.
- Strong programming skills in Python, C#, or a similar language for automation, tooling, and data processing.
- Experience with data pipelines, ETL/ELT, data integration, batch processing, and/or event-driven architectures.
- Strong understanding of database internals, transactions, concurrency, locking, isolation levels, and performance optimization.
- Experience independently driving complex technical initiatives across engineering teams.
- Experience using AI coding assistants such as Cursor, GitHub Copilot, Claude Code, Augment, or similar tools.
- Familiarity with embeddings, vector databases, semantic search, RAG concepts, and AI-enabled data tooling.
- Exposure to PostgreSQL, Snowflake, Azure SQL, Cosmos DB, AWS data services, or similar platforms.
- Experience with infrastructure-as-code such as Terraform or ARM/Bicep, CI/CD, source control, database migrations, schema versioning, and deployment automation.
- Experience with Kafka is a plus, and familiarity with NoSQL and document databases is a plus.
- Preferred experience includes payments, financial services, healthcare, benefits, regulated environments, highly available customer-facing systems, Oracle PL/SQL, RAG, semantic search, vector databases, AI-agent data infrastructure, and AI-based internal engineering tools.
Benefits
- Health, dental, and vision insurance.
- Retirement savings plan, paid time off, health savings account, flexible spending accounts, life insurance, and disability insurance.
- Tuition reimbursement and additional comprehensive benefits.
- Non-sales roles are typically eligible for a quarterly or annual bonus; compensation figures are excluded from this benefits summary.
Tech Stack
Categories
Data Engineering
About WEX
WEX is a public financial technology company that provides corporate payment solutions to fleets, healthcare/benefits administrators, and travel businesses. Its products include fuel and mobility cards, virtual card payments, and platforms for HSAs/FSAs/HRAs, with revenue from payment processing and software/service fees. Founded in 1983 and headquartered in Portland, Maine, WEX trades on the NYSE under WEX and was formerly known as Wright Express.
