Business Analyst with Loan IQ and data modeling @ Iselin, NJ (Hybrid)

Role : 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:

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