Business Analyst

HCM Staffing and Consulting; United States; Remote; USD 83,000 - 124,000; Full time

Job summary

HCM Staffing and Consulting is seeking a Senior Business Analyst for a 12-week remote engagement in the United States. Phase 1 focuses on fact-finding, interviewing client leads, and capturing current processes to anchor Phase 2 requirements.

Expertise in payments and data mapping across Salesforce, NetSuite, and the payments platform is required. The role collaborates with Finance, FP&A, Billing and Accounting to understand discrepancies and drive reconciliations, with strong Excel, SQL and BI

Qualifications

• 7+ years as a business analyst with at least 3 years in payments/fintech.
• Experience with month-end close, revenue reporting and reconciliations.
• Strong Excel and SQL skills to reconcile data sets.
• Power BI or another BI tool experience.
• Ability to map processes across Salesforce, NetSuite and payments platforms.

Responsibilities

• Prepare for, run and document one-on-one interviews with client leads.
• Document lifecycle of each business use case and capture steps, systems and hand-offs.
• Map entities, fields and processes across Salesforce, NetSuite and the payments platform.
• Fill in the system-of-record matrix with ownership and data flow details.
• Define KPIs, data sources, owners, and conflicts; draft Phase 2 requirements and UAT scripts.

Skills

Payments domain knowledge

Business analysis

Excel

SQL

Power BI

Tools

Salesforce

NetSuite

ERP systems

Job description

Duration: 12 weeks, with expected extension into Phase 2
Start: Immediately
Location:Remote, United States. Working hours overlap with U.S. Eastern time.

The role

Phase 1 is mostly fact-finding, and the business analysts do most of it. They sit with the clients leads, work out how each process runs today and where the data goes wrong, and write it down well enough that the next phase can be built from it. The Phase 1 deliverables are, in effect, the requirements for Phase 2.

Much of what the client knows lives in peoples heads rather than in documentation. Both analysts need to be comfortable drawing that knowledge out in interviews and then checking it against the data.

What analyst does

Prepare for, run and write up one-on-one interviews with the clients functional leads.
Document the life cycle of each business use case, such as boarding a new merchant, adding a merchant ID or setting up a new partnership. Capture the steps, systems, hand-offs, exceptions and manual work.
Map entities, fields and process flows across Salesforce, NetSuite and the payments platform.
Fill in the system-of-record matrix: for each critical field, where it is created, where it is edited, where it is consumed, who owns it today and who should own it.
Define KPIs for the metric catalog, with the business definition, the source, the owner and any conflicts between teams.
Record historical data requirements for each business area: how far back data must be corrected, how long it must be kept, and which elements must be real-time.
Point out where the client can cut time or cost from a process.
Draft requirements, exception rules and UAT scripts for Phase 2.

Finance and Payments

This analyst works with Finance and FP&A (daily volume, roll-forward reporting) and with Billing and Accounting (book-to-bill). The work centers on why Finance, Sales and Operations report different numbers, and what it takes to make them agree.

Problems this analyst will dig into:

Financial truth comes from third-party processors in monthly files that arrive about 23 days after month end. Each processor sends different fields.
Daily gateway data and monthly processor data use different timing, settlement and batching rules. Finance reconciles them by hand today.
When a merchant moves between processors, its merchant ID changes, so the merchant shows up as both lost and new. That corrupts cohort, attrition and revenue reporting.
Thousands of merchants exist only in processor data and not in any internal system.

Required

7 or more years as a business analyst, with at least 3 years in payments, merchant acquiring, an ISO or payment facilitator, or fintech finance.
Working knowledge of interchange, residuals, settlement, chargebacks, merchant IDs and merchant hierarchies.
Experience with month-end close, revenue reporting and the reconciliations behind them.
NetSuite or a comparable ERP, from the reporting side.
Strong Excel, and enough SQL to reconcile two data sets yourself. Preferred for this track
Surcharging or processor migration projects.
Power BI or another BI tool.
Healthcare or practice-management software.

What good looks like at week 12

Every use case in the analysts functions documented and confirmed by the client lead who owns it.
The analysts rows of the system-of-record matrix and KPI catalog complete, with conflicts called out by name.
A list of process fixes, with the time or cost each would save.
Requirements and UAT scripts the Phase 2 team can start from.