Business; Data Analyst

Overview

Primary

Job Title:

Business Analyst

Alternate / Related Job Titles: Senior Business Analyst;
Business Systems Analyst;
Data Business Analyst;
Loan Reconciliation Analyst

Location & Onsite Flexibility: Morristown, NJ — Hybrid (3 days per week onsite)

Contract Details

Position Type:
Contract

Contract Duration: 18 Months

Start:
As Soon As Possible

Pay Rate: 50–60/hr

Extension Possible:
Yes

Conversion Possible:
Yes

The Business Analyst will support a Loan Reconciliation modernization initiative
, transforming an existing monthly loan processing platform into a daily application
. The primary objective is to produce a daily loan balance extract by consuming and reconciling data from 12 upstream source systems
, validating balances within internal platforms, and delivering accurate, timely data to downstream reporting and analytics consumers. This role partners closely with enterprise data teams to ensure data availability, quality, and end-to-end traceability
, while collaborating across business, technology, and data stakeholders to support daily ingestion, validation, reconciliation, and outbound data distribution.

• Support modernization of loan reconciliation from monthly to daily processing
• Partner with enterprise data teams to ensure data quality and traceability
• Reconcile loan balances across multiple upstream source systems
• Validate source-to-target data mappings and reconciliation logic
• Support daily data ingestion, validation, and outbound data delivery
• Collaborate with business, technology, and analytics teams to resolve issues
• Produce and analyze data extracts to support reporting and downstream consumers

Required Skills:

• 4+ years of Business Analyst, Business Systems Analyst, or Data Analyst experience
• Loan platform and reconciliation experience (LoanIQ, CFIL, Stucky/Solifi)
• Strong understanding of loan balances, reconciliations, and data validation
• Advanced Excel skills
  , including Pivot Tables, VBA/Macros, and Power Query
• Ability to read and write basic SQL or Python queries

Preferred

Skills:

• Banking or financial services industry experience
• Strong communication skills and ability to collaborate cross-functionally

Additional

Skills:

• Experience working with enterprise data teams
• Familiarity with reporting and analytics data consumers

Medical, Vision, and Dental Insurance Plans

401k Retirement Fund

A long-standing financial institution with over 125 years of experience
, providing comprehensive banking products and services for individuals and businesses. The organization empowers customers to achieve financial goals through stability, reliability, and trusted service.

Job Number: 26-00116