Description

You will gather and document requirements for data warehousing solutions, mapping data from trading, finance, and risk systems into the enterprise warehouse.

This role is hybrid.

Responsibilities

• Define data models, transformation rules, and business logic for derivatives, loans, cash, and commitment products.
• Support the design and implementation of regulatory reporting data pipelines for frameworks like Dodd-Frank, EMIR, and Basel III.
• Conduct data profiling, gap analysis, and validation to ensure data quality and completeness.
• Create detailed functional specifications, data dictionaries, and lineage documentation.
• Work with QA and UAT teams to define test cases and validate data warehouse outputs.

Required Skills

• 5+ years of experience as a Business Analyst in Investment Banking or Capital Markets.
• Strong understanding of financial products, especially derivatives, loans, and cash instruments.
• Proven experience in data warehousing projects, including data modeling and ETL processes.
• Proficiency in SQL and data analysis tools.
• Experience working with enterprise data platforms such as Snowflake, Databricks, or Teradata.
• Familiarity with regulatory reporting frameworks (EMIR, Dodd-Frank, Basel III, SFTR).
• Bachelor’s degree in Finance, Information Systems, or a related field.

Preferred Skills

• Experience with Agile/Scrum methodologies.
• Knowledge of data governance, metadata management, and data lineage tools.
• Exposure to cloud-based data platforms (AWS, Azure).

Key Skills

Education

Bachelor's degree