Data Analyst

Description

Summary: Seeking a Data Analyst to support a large-scale data migration program in capital markets, focusing on bridging business and technology through data analysis, validation, and reconciliation. Highlights: 1. Support critical data migration in capital markets 2. Bridge business and technology with data insights 3. Ensure data integrity for complex financial datasets Project overview: The program is a multi phase data migration initiative aimed at replacing legacy capital markets systems with a modern platform ecosystem. It includes the migration of critical datasets across custody, clearing and settlement, derivatives processing, and CCP operations. The project spans 18 months and follows an incremental approach with strong emphasis on data integrity, reconciliation, and traceability. * Position overview: We are looking for a Data Analyst to support a large scale data migration program within a capital markets environment. * This role focuses on understanding business requirements, analyzing data across legacy and target systems, and ensuring the correctness and completeness of migrated data. You will play a key role in bridging business and technology, supporting functional validation, and enabling downstream analytics and reporting. * * The position requires strong analytical skills, deep understanding of data structures, and the ability to work with complex financial datasets. Technology stack: SQL, AWS Glue, dbt, Oracle, AWS, Git * Responsibilities: Work closely with business stakeholders to understand requirements and translate them into data analysis and validation tasks * Analyze legacy and target datasets to support data migration and transformation processes * Define and execute data validation and reconciliation procedures * Validate migrated data ensuring accuracy, completeness, and consistency * Document ETL processes, data mappings, and transformation logic * Write complex SQL queries to explore, validate, and analyze large datasets * Support the creation of dashboards and reports for business users * Collaborate with data engineers to ensure alignment between business rules and technical implementation * Support downstream analytics and data visualization initiatives * Identify data issues, inconsistencies, and gaps, and propose solutions * Requirements: Experience working in capital markets environments (custody, clearing, settlement, derivatives, or CCP) * Ability to translate business requirements into structured tasks for technical teams * 3\+ years of experience working with large data volumes and diverse data formats * Strong experience with SQL for data analysis and validation * Experience in data warehousing, dimensional modeling, reporting, and business intelligence * Experience in data schema design, data modeling, and data mappings * Strong analytical and problem solving skills * Nice to have: Experience in data migration or system transformation programs * Experience with QuickSight * Familiarity with AWS data services such as Glue * Experience with dbt or similar transformation tools * Experience with BI tools such as Tableau or Power BI * Understanding of data governance and data quality frameworks