Quick overview
Job description
Business Analyst – Finance
Job Type: Contract (6-12 Months)- Possible extension
Location: Philadelphia, PA / Vienna, VA - Hybrid / Open to remote job
Job description:
Program: Consolidation of five legacy data and BI platforms onto Azure Databricks and Power BI
Job summary:
- We are seeking a senior business analyst to represent finance and wealth management requirements on a program that moves a legacy reporting and data warehouse estate to Azure Databricks and Power BI.
- You will work with finance, operations and data owners to confirm business rules, decide which reports are retired or migrated, and prove that the new platform produces the same numbers through financial close.
Key responsibilities:
- Confirm business rules and definitions with finance and operations subject-matter experts where legacy logic is unclear.
- Document report and data requirements, and support retire-or-migrate decisions for each legacy report.
- Produce source-to-target mappings and data definitions with data modelers and engineers.
- Define comparison measures and tolerances for month-end and quarter-end close and review parallel-run results.
- Plan and coordinate user acceptance testing, track defects and obtain business sign-off.
- Investigate reconciliation differences using SQL and explain them to business owners.
- Maintain business glossary terms and definitions with the client's data stewards.
Required qualifications:
- 8+ years as a business analyst in financial services, with at least two data warehouses, reporting or data migration programs.
- Working knowledge of finance processes: general ledger, financial close, management and regulatory reporting.
- SQL is sufficient to query, profile and reconcile data without engineering support.
- Experience writing source-to-target mappings, acceptance criteria, and test cases.
- Experience leading user acceptance testing with finance or operations users.
- Confident facilitation of workshops with senior business stakeholders.
Preferred qualifications
- Wealth management or broker-dealer data: client accounts, positions, transactions, assets under management.
- Exposure to Databricks, Power BI or another cloud data platform.
- Experience with a parallel-run financial close or system decommissioning.
- AI coding and analysis tools may be used only on endpoints the client has approved.
- Experience in financial services, wealth management or another regulated industry is strongly preferred.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- CG
SQL DBA / Systems Analyst with Security ClearanceRecently posted
Contact Government Services, LLC · Dallas, TX · Hybrid · Posted 18 Nov 2026 🇺🇸
SQLTechnology$89.3k - $114.8k/yr - KT

Business Systems AnalystRecently posted
Kforce Technology Staffing · Jacksonville, FL · Hybrid · Posted 18 Nov 2026 🇺🇸
Business AnalysisProcess ImprovementTechnologySalary not listed - CG
SQL DBA / Systems Analyst with Security ClearanceRecently posted
Contact Government Services, LLC · Atlanta, GA · Hybrid · Posted 18 Nov 2026 🇺🇸
SQLTechnology$89.3k - $114.8k/yr - TT
Systems Analyst (Healthcare)Recently posted
Trigyn Technologies, Inc. · Albany, NY · Hybrid · Posted 18 Nov 2026 🇺🇸
Care CoordinationEHRHIPAA+3TechnologySalary not listed - ST
Salesforce Functional Lead / Senior Business AnalystRecently posted
Shiro Technologies · United States · Hybrid · Posted 18 Nov 2026 🇺🇸
Stakeholder ManagementSalesforceAgileTechnologySalary not listed - RH

Business AnalystRecently posted
Robert Half · Los Angeles, CA · Hybrid · Posted 19 Nov 2026 🇺🇸
ScrumBusiness AnalysisAgileOperations & Project ManagementSalary not listed - MR

Markets Business AnalystRecently posted
Motion Recruitment Partners, LLC · University at Buffalo, NY · Hybrid · Posted 19 Nov 2026 🇺🇸
Process ImprovementOperations & Project ManagementSalary not listed - CI

Senior Oracle EBS Business Analyst - CitiRecently posted
Citi · Tampa, FL · Hybrid · Posted 19 Nov 2026 🇺🇸
Business AnalysisOperations & Project Management$79.1k - $118.7k/yr - HA

Lead, IT Business AnalysisRecently posted
Harris Corporation · Melbourne, FL · Hybrid · Posted 15 Nov 2026 🇺🇸
Microsoft ExcelMicrosoft OfficeAccounts Payable+5Salary not listed - RI
Business AnalystRecently posted
Raas Infotek LLC · Texas City, TX · Hybrid · Posted 18 Nov 2026 🇺🇸
Stakeholder ManagementMicrosoft ExcelScrum+5Operations & Project ManagementSalary not listed - CO

Business Process Specialist - Army G-2 Program Analyst with Security ClearanceRecently posted
Core One · Arlington, VA · Hybrid · Posted 18 Nov 2026 🇺🇸
Data AnalysisSalary not listed - HG

Analyst S&M Business OperationsRecently posted Auto Apply
Hilton Grand Vacations · Las Vegas · On-site · Posted 18 Nov 2026 🇺🇸
OracleSQLMicrosoft Excel+7Salary not listed