Data Analyst

DataArt

United States

Remote

USD 120,000 - 150,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

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

**Role overview**

Support a large-scale migration from legacy capital markets systems to a modern data platform. You'll clarify business needs, analyze source and target data, and help verify that transformed records are accurate, complete, and ready for reporting and downstream analytics. The role bridges business stakeholders and technical teams, including support for functional validation and adoption of new processes.

**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.
**Requirements**
  • At least 3 years working with large data volumes and varied data formats.
  • Strong SQL skills for analysis and validation.
  • Experience in capital markets, such as custody, clearing, settlement, derivatives, or central counterparty services.
  • Knowledge of data warehousing, dimensional modeling, data schemas, and mappings.
  • Ability to turn business requirements into actionable work for technical teams.
  • Fluent written and spoken Spanish and English.
**Nice to have**
  • Experience with data migration or system transformation programs.
  • Familiarity with AWS Glue, dbt or similar transformation tools, and Tableau or Power BI.
  • Understanding of data governance and data quality frameworks.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Capital Markets Data Migration Analyst | SQL & Validation
Capital Markets Data Migration Analyst | SQL & Validation

DataArt • United States

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

UNAVAILABLE • McLean (VA)

On-site
USD 70,000 - 110,000
Data Platform Transformation Architect
Data Platform Transformation Architect

Anvik Technologies • Denver (CO)

On-site
USD 130,000 - 180,000
Data Analyst
Data Analyst

Chesapeake Oncology-Hematology Associates • Carefree (AZ)

On-site
USD 60,000 - 90,000
Data Governance Analyst - USA
Data Governance Analyst - USA

tezo • Seattle (WA)

Remote
USD 110,000 - 170,000
Data Analyst
Data Analyst

Vortalsoft Inc • New Jersey

On-site
USD 70,000 - 90,000
Data Analyst
Data Analyst

Selby Jennings • Chicago (IL)

On-site
USD 85,000 - 115,000
Data Analyst Banking
Data Analyst Banking

margo-group • United States

Remote
USD 120,000 - 180,000
Data Analyst
Data Analyst

TechDigital Group • Dallas (TX)

On-site
USD 60,000 - 100,000
Data Analytics & BI Analyst
Data Analytics & BI Analyst

Signature IT World Inc • Hanover Township (NJ)

On-site
USD 80,000 - 120,000