Back to Jobs
Recently postedOperations & Project Management

Senior Business Analyst

eSolutionsFirst, LLCPhiladelphia, PA🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationPhiladelphia, PA, United States

Job description

Business Analyst – Finance

Job Type: Contract (6-12 Months)- Possible extension

Location: Philadelphia, PA (Hybrid – Flexible Work Model)

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.

Similar jobs