Description

Key Responsibilities:

• Collaborate with business users and technology teams to gather and document requirements for data warehousing solutions.
• Analyze and map data from source systems (trading, finance, risk) into the enterprise data warehouse.
• 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 (e.g., Dodd-Frank, EMIR, 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.
• Act as a liaison between business, compliance, and IT to ensure alignment on data requirements and delivery timelines.
• Support ongoing enhancements and change requests related to regulatory and business reporting.

Required Skills & Qualifications:

• Bachelor’s degree in Finance, Information Systems, or a related field.
• 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.
• Familiarity with regulatory reporting frameworks (e.g., EMIR, Dodd-Frank, Basel III, SFTR).
• Proficiency in SQL and data analysis tools.
• Experience working with enterprise data platforms (e.g., Snowflake, databricks, Teradata).
• Excellent communication, documentation, and stakeholder management skills.

Preferred Qualifications:

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

Key Skills

Education

Bachelor's degree