Data Analyst

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.