Junior Business / Financial Analyst

JSM Consulting Inc.; New York (NY); Hybrid; USD 80,000 - 110,000; Full time

Job summary

JSM Consulting Inc. is seeking a Business Analyst to support financial reporting and IT budgeting. The role emphasizes analysis, forecasting, and stakeholder communication rather than technical development.

In a hybrid setup, you will be near NYC locations with three on-site days and two remote days. Strong Excel and dashboard skills, plus familiarity with Beeline, PeopleSoft, Hyperion, and ERP concepts, will help you succeed in this fast-paced environment.

Qualifications

• Bachelor's degree or 1–3 years of relevant experience.
• Strong MS skills, especially Excel; Power BI a plus.
• Ability to perform high-volume work accurately in a fast-paced environment.
• Budgeting, variance analysis and reconciliation experience.
• Ability to manage rolling financial models.

Responsibilities

• Track IT contracts and collaborate with IT and Procurement staff to ensure renewals are processed without service interruption.
• Forecast and track actual expenses using Excel updates for daily model changes.
• Handle monthly accounting transactions including accruals, prepaids, and reclass entries.
• Perform basic financial analysis including reconciliations, variance commentary, cost-benefits, and budget optimization.
• Work with Budget Managers to understand and explain variances.
• Track and support consulting/professional services engagements in Beeline and assist with onboarding new resources.

Skills

Excel expertise

Power BI

Financial analysis

Budgeting & variance analysis

Rolling financial models

SQL or Python

Dashboard development

Independent fast-paced work

Education

Bachelor's degree in Business Administration, Finance, Public Administration, or equivalent

Tools

Beeline Vendor Management System

PeopleSoft ERP

Hyperion

ServiceNow

SQL

Python

Job description

Job Description:

This is not a technical role - This is a Business Analyst, not a Technical Business Analyst.

This is a hybrid role with 3 days on site (or more as needed) and 2 days remote

Available locations are 2 Broadway NY; JCC in Jamaica NY, Graybar Building

Candidate is required to be within commuting distance of NYC to maintain hybrid work environment

Overview

The organization is seeking a Consultant to support and manage financial reporting and broader responsibilities across the full IT landscape.

Key Responsibilities

Support the MTA IT Department , IT Divisions and MTA Agencies with the following:

• Track IT contracts and collaborate with IT and Procurement staff to ensure renewals are processed without service interruption
• Forecast and track actual expenses relying on excel expertise for daily model updates
• Handle monthly accounting transactions including accruals, prepaids, reclass entries
• Perform basic financial analysis including reconciliations, variance commentary, cost-benefits and budget optimization
• Work with Budget Managers to understand and explain variances
• Track and support consulting/professional svc engagements in Beeline Vendor Management System and assist with onboarding new resources

Required Qualifications

• Bachelor's degree in Business Administration, Finance, Public Administration, or equivalent, or 1-3 years of relevant experience (Tier 1)
• Strong MS skills particularly Excel Expertise (Power BI a plus)
• Ability to perform high-volume work accurately and independently in fast-paced environment
• Budgeting-Variance Analysis and reconciliation experience
• Ability to manage rolling financial models

Additional/Helpful Qualifications

• PeopleSoft Procurement & Financial Modules
• ServiceNow Asset/Contract Management
• Beeline Vendor Management System
• Basic knowledge of IT hardware, software, equipment and Maintenance agreements
• SQL or Python for data extraction
• Experience building and maintaining interactive dashboards
• Knowledge of Accounting and understanding of CapEx/OpEx treatment
• Hyperion and PeopleSoft ERP
• Experience with Cost allocation
• Prior experience working with or supporting organizations within the MTA a plus