Role : Business Analyst (with Derivatives, Finance, Loans & Capital Markets Domain Exp)

Location : Remote (Canada only)

Duration: 6+ months

 

 

Job Summary:

We are looking for a seasoned  Business Analyst

 to support a strategic  Data Warehouse initiative

 within our Bank division. The ideal candidate will have deep domain expertise in  Derivatives, Finance, Cash, Loans, and Commitments

, along with a strong understanding of  Regulatory Reporting

 requirements. This role involves working closely with business stakeholders, data architects, and engineering teams to define and deliver robust data solutions that support compliance, reporting, and analytics.

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.