Business Analyst with expertise in Loan IQ and data modeling

Location : Iselin NJ (Hybrid)

Preferred : CFA

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:

• Bachelors 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).