Capital Markets Data Migration Analyst | SQL & Validation

DataArt

United States

Remote

USD 120,000 - 150,000

Full time

7 days ago
Be an early applicant

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

DataArt is seeking a data migration analyst to support a large-scale transition from legacy capital markets systems to a modern data platform. You will interpret business needs, study source/target data, and verify transformed records for reporting and analytics.

You will bridge business stakeholders and technical teams, supporting validation and adoption of new data processes, and collaborate on data governance and quality initiatives to ensure accurate outcomes.

Qualifications

  • 3+ years handling large data volumes.
  • Strong SQL for analysis and validation.
  • Experience in capital markets (custody, clearing, settlement, derivatives, CCPs).
  • Knowledge of data warehousing, dimensional modeling, data schemas and mappings.
  • Ability to translate business requirements into actionable tasks for technical teams.
  • Fluent in English and Spanish (written and spoken).

Responsibilities

  • Gather business requirements and translate them into structured analysis and validation tasks.
  • Explore legacy and target datasets to support migration and transformation work.
  • Define and carry out data validation and reconciliation procedures.
  • Document ETL processes, field mappings, and transformation rules.
  • Write complex SQL to investigate large datasets and identify data gaps or inconsistencies.
  • Work with data engineers on business-rule alignment and support reports, dashboards, and downstream analytics.

Skills

SQL
Capital markets
English & Spanish
Data governance
Requirements mapping

Tools

AWS Glue
dbt
Tableau
Power BI

Job description

DataArt is seeking a data migration analyst to support a large-scale transition from legacy capital markets systems to a modern data platform. You will interpret business needs, study source/target data, and verify transformed records for reporting and analytics.

You will bridge business stakeholders and technical teams, supporting validation and adoption of new data processes, and collaborate on data governance and quality initiatives to ensure accurate outcomes.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

DataArt • United States

Remote
USD 120,000 - 150,000
Business Analyst
Business Analyst

TechDigital Group • Minneapolis (MN)

On-site
USD 60,000 - 100,000
Data Conversion Analyst — Client-Facing Data Migrations
Data Conversion Analyst — Client-Facing Data Migrations

Remote • San Francisco (CA)

Hybrid
USD 70,000 - 110,000
Senior Data Migration & Governance Product Lead
Senior Data Migration & Governance Product Lead

Capital One • New York (NY)

On-site
USD 219,000 - 250,000
Incentives
Data Migration Analyst - SQL & Legacy Data Mapping
Data Migration Analyst - SQL & Legacy Data Mapping

Mi-Case • United States

On-site
USD 70,000 - 110,000
Remote Data Migration Consultant for Investment Management
Remote Data Migration Consultant for Investment Management

Cutter Associates • United States

Remote
USD 95,000 - 130,000
Annual bonus
Profit sharing
401(k) match
+5
Remote Data Analyst - Master Data & ERP Migrations
Remote Data Analyst - Master Data & ERP Migrations

Orange County Naacp • Fort Myers (FL)

Remote
USD 65,000 - 95,000
Remote work
Training resources and career growth
Data & Analytics Lead - Banking & Capital Markets
Data & Analytics Lead - Banking & Capital Markets

CrossCountry Consulting • United States

Remote
USD 130,000 - 180,000
Healthcare (medical, dental, vision)
401(k) with company match
Parental leave
+2
Data Migration Assistant
Data Migration Assistant

EXOS • Indianapolis (IN)

On-site
USD 40,000 - 50,000
Data Management - Data Analyst - Sr
Data Management - Data Analyst - Sr

Spectraforce Technologies, Inc. • McLean (VA)

Hybrid
USD 110,000 - 150,000