Business Systems Analyst

morris plains, New Jersey

A prominent marketing agency is currently seeking a Business Systems Analyst to join their team in Morris Plains, NJ.

Within this role, you will help the client with various data and reported related activities as they transition from AS400 to Microsoft Dynamics. The candidate will have deep expertise with process flows, data analysis, data mapping, translation, validating data feeds, running SQL queries, etc.


  • Document Financial Interface requirements to include data fields and translations where needed
  • Document sender system requirements to include triggering requirements, validation requirements, success/failure condition requirements
  • Validate sample data feeds relative to interface and validation requirements
  • Analyze legacy system usage as it relates to “sunset-ability,” meaning all of the functions that are to be migrated to the new financial platform are accounted for, and no remaining functions survive
  • Inventory and analyze existing financial reports, including purpose, users, usage, selection, filter and sort criteria, control break grouping criteria, access control, etc.
  • Facilitate determination of future-state reporting needs: for each legacy report, replace like-for like or define new reporting requirements


  • 5+ years of proven success as a systems analyst
  • 5+ year experience with data and reporting related activities including process flows, data analysis, data mapping, translation, creating data/system requirement documentation and validating data feeds
  • Comfortable running SQL queries to analyze data
  • 3+ years of Business Analysis experience
  • Experience with General Ledger and Financial systems
  • Comfortable working independently with minimal direction
  • Experienced in coordinating and facilitating meetings of 10 or more people
  • Expert in facilitating requirement gathering and analysis sessions
  • Excellent requirements gathering, analysis and solutioning skills
  • Strong background in both Agile and Waterfall methodologies
  • Exceptional leadership and communication skills (written and verbal)

Job keywords:

Files must be less than 2 MB.
Allowed file types: doc docx pdf.

Vertical Tabs