Position

Data Architect

Main skills

Sybase, Azure SQL, ETL/ELT, Data Integration Architecture, SQL

Short overview

Lead the data modernization and migration execution for a large-scale wealth platform transitioning from Sybase to Azure SQL, driving decoupling, data services architecture, and pipeline redesign while enabling phased client migration

Project duration

6+ months

Location

Weehawken, NJ

Work mode

3 days from the office

Travel

Recruitment process

General -> Technical Interview -> Client Interview

Required start date

ASAP

Level

Mid-Senior level

Work authorization statu

H1B and TN visa candidates can be considered. Any applicant needs to be on your W2.

We''re seeking a hands-on Data Services Architect/Lead to drive a large-scale data modernization initiative for a wealth management platform. You''ll lead the transition from Sybase to Azure SQL—spanning architecture, execution, and team enablement—while enabling phased client migration and building a modern data services foundation.

This role bridges strategy and delivery. You won''t just design; you''ll roll up your sleeves and guide teams through implementation.

---

What You''ll Do

Migration Strategy & Execution

· Define and validate an incremental, client-by-client migration approach

· Architect coexistence between legacy Sybase and Azure SQL environments

· Identify hybrid operation risks and develop mitigation strategies

Stored Procedure Modernization

· Lead analysis and transformation of ~3,500 stored procedures

· Drive phased approach: lift-and-shift initially, then business logic extraction into Spring Boot microservices/APIs

· Establish clear standards for what logic stays in the database vs. moves to services

Data Services Layer Design

· Design and implement a data service abstraction layer that decouples applications from the database

· Replace direct stored procedure calls with scalable, maintainable service patterns

· Ensure the layer meets performance and scalability requirements

Data Architecture & Multi-Tenancy

· Lead transition from single-tenant to tenant-aware architecture

· Define data isolation models across clients

· Create a roadmap for long-term data partitioning strategy

ETL & Data Pipeline Modernization

· Redesign ETL workflows using Azure Data Factory (ADF) and Databricks

· Define patterns for data ingestion, transformation, and movement

· Re-architect upstream and downstream system integrations

Batch Processing Transformation

· Consolidate and redesign batch processes (merging multiple outputs into single consolidated outputs)

· Ensure continued compatibility with mainframe downstream systems

Performance & Optimization

· Identify and address query and workload performance risks

· Optimize SQL queries, indexing strategies, and data access patterns

Hands-On Technical Leadership

· Guide and mentor implementation teams (India/Poland)

· Provide code-level guidance, debugging, and troubleshooting support

· Drive delivery outcomes—not just design reviews

---

What We''re Looking For

· Proven experience leading data platform migrations at scale

· Deep expertise in SQL Server/Azure SQL and stored procedure modernization

· Hands-on experience with Azure Data Factory, Databricks, and modern ETL patterns

· Strong understanding of microservices architecture and API design (Spring Boot preferred)

· Experience with multi-tenant data architecture and partitioning strategies

· Ability to lead distributed teams while staying technically engaged

· Track record of balancing architectural vision with pragmatic delivery

W2 - 15+ Data Architect (Azure & Migration)

Key skills

About this role