Junior Business Analyst

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

Job summary

JSM Consulting Inc. in New York seeks a Business Analyst to support financial reporting and broader IT-finance responsibilities. This is a non-technical role focused on analytics, budgeting, and vendor management.

The position is hybrid: three days on site and two days remote, with proximity to NYC required for hybrid workflow. You will work with IT, procurement, and budget managers to ensure accurate financials and timely renewals.

Qualifications

• Bachelor's degree in Business Administration, Finance, Public Administration, or equivalent, or 13 years of relevant experience (Tier 1)
• Strong MS Office skills, especially Excel; Power BI a plus
• Ability to perform high-volume work accurately and independently 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 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 services engagements in Beeline and assist with onboarding new resources

Skills

MS Excel

Budgeting

Variance analysis

Financial modeling

Analytical skills

Education

Bachelor's degree or equivalent

Tools

Power BI

Beeline Vendor Management System

PeopleSoft Procurement & Financial Modules

ServiceNow Asset/Contract Management

Hyperion

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

• 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 13 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