Position Overview
We are seeking an IT Business Analyst with strong experience in financial systems, SAP Finance, SQL, and data reconciliation to support financial data integration and reporting across SAP, Oracle databases, and OneStream.
This role will work closely with Finance stakeholders, IT teams, and technical resources to gather requirements, investigate financial data discrepancies, validate integrations, and ensure accurate financial reporting.
The ideal candidate will have a solid understanding of finance and accounting processes, hands-on SAP Finance experience, and strong SQL skills.
Experience with OneStream is preferred but not required. Candidates with strong SAP Finance, SQL, and reconciliation experience who are willing to learn OneStream will also be considered.
Key Responsibilities
Business Analysis & Requirements Gathering
-
Partner with Finance stakeholders to understand general ledger, trial balance, financial consolidation, reporting, and drillback requirements.
-
Gather, analyze, and document business and functional requirements.
-
Develop functional specifications, data field mappings, test scenarios, and supporting documentation.
-
Translate financial business needs into clear technical requirements.
Financial Data Integration & Reconciliation
-
Support financial data integration across SAP, Oracle databases, and OneStream.
-
Write, execute, and troubleshoot SQL queries to extract, analyze, and reconcile financial data.
-
Compare source and target financial data to identify discrepancies and validate accuracy.
-
Investigate reconciliation differences and coordinate resolutions with technical teams.
-
Ensure consistency and accuracy of financial information across integrated systems.
Testing & Financial Reporting
-
Support system integration testing (SIT) and user acceptance testing (UAT).
-
Develop test scenarios, validate results, and document defects.
-
Assist with financial close activities, including data validation and reconciliation.
-
Work with Finance and technical teams to resolve reporting and integration issues.
-
Support reliable and accurate financial reporting processes.
Required Qualifications
Finance & Accounting Knowledge
-
Working knowledge of financial accounting processes, including:
-
General Ledger (GL)
-
Trial balances
-
Journal entries
-
Fiscal periods
-
Currency transactions and conversions
-
-
Understanding of financial data reconciliation and reporting processes.
SAP Finance Experience
-
Hands-on experience with SAP ECC or SAP S/4HANA Finance.
-
Ability to investigate financial balances, accounting documents, and transaction discrepancies.
-
Understanding of SAP Finance data structures and financial reporting processes.
SQL & Data Analysis
-
Strong hands-on SQL experience, including:
-
Joins and filters
-
Aggregations
-
Data extraction and validation
-
Financial data reconciliation
-
Query troubleshooting
-
-
Ability to identify and investigate discrepancies between source and target systems.
Excel Skills
- Advanced Microsoft Excel skills, including:
-
PivotTables
-
VLOOKUP/XLOOKUP
-
Reconciliation formulas
-
Data comparisons and analysis
Business Analysis & Testing
-
Experience gathering and documenting business requirements.
-
Ability to prepare functional specifications, field mappings, and test cases.
-
Experience supporting integration testing and UAT.
-
Strong analytical, troubleshooting, and problem-solving skills.
Communication & Collaboration
-
Strong written and verbal English communication skills.
-
Comfortable working directly with Finance stakeholders and technical teams.
-
Excellent attention to detail and ability to work independently in a remote environment.
Preferred Qualifications
-
Experience with OneStream or another financial consolidation and reporting platform.
-
Experience with PeopleSoft Financials, SAP Special Purpose Ledger (SPL), or SAP Central Finance.
-
Knowledge of Oracle SQL and query performance analysis.
-
Familiarity with Qlik Replicate or change data capture (CDC) technologies.
-
Experience supporting financial controls, audit evidence, or reconciliation automation.
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.




