Indent : SF_OP_203739-1-1 Role : Business Analyst with expertise in Loan IQ and data modeling Location : Iselin, NJ (Hybrid) Rate : $80/hr – $82/hr
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).
Numbers & Facts
Location
Alexandria, VA
Salary
$80–$82 Per Hour
Skills
Acceptance Testingunmatched
Agile Programming Methodologiesunmatched
Amazon Web Services (AWS)unmatched
Basel III (Third Basel Accord)unmatched
Business Analysisunmatched
Business Transformationunmatched
Capital Marketsunmatched
Change Requests/Ordersunmatched
Chartered Financial Analyst (CFA)unmatched
Cloud Computingunmatched
Communication Skillsunmatched
Data Analysisunmatched
Data Managementunmatched
Data Modelingunmatched
Data Profilingunmatched
Data Qualityunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Derivativesunmatched
Documentationunmatched
Dodd Frank Actunmatched
Financeunmatched
Financial Systemsunmatched
Gap Analysisunmatched
Information Technology & Information Systemsunmatched
Investment Servicesunmatched
Loansunmatched
Metadataunmatched
Microsoft Windows Azureunmatched
NCR Teradataunmatched
Policy Implementationunmatched
Quality Assuranceunmatched
Regulatory Reportsunmatched
Regulatory Requirementsunmatched
Requirements Managementunmatched
Riskunmatched
SQL (Structured Query Language)unmatched
Scrum Project Management and Software Developmentunmatched
Snowflake Schemaunmatched
Test Caseunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.