Business Systems Analyst

Job Title: Business Systems Analyst

Location: Hybrid in Newark, NJ

Duration: 12 Months

• Acts as liaison between Operations, Business and Systems personnel to support the unit's business needs through computer systems and/or policy administration rules.
• Represents the user area in all systems enhancements/design activities and answers questions/resolves problems with the systems user and/or Operations.
• Gathers client requirements for a business process change and communicates those terms to systems personnel and/or Operations.
• This position stresses knowledge of the business as well as technology. Programming is not required but is a plus.
• Incumbents typically have 1‑5 years related experience and strong working knowledge of the supported business functions and workflow; familiarity with systems and transactions supporting the business functions; solid working knowledge of systems design processes and methodology; familiarity with testing tools. Knowledge of the system support (including inputs, screens, processing logic, output, reports as well as interfaces with other systems) is helpful.
• Identifies solutions to complex business problems by gathering, analyzing, and documenting business and systems requirements to enhance operational performance.
• Reviews user and/or Operations requests and conducts data‑gathering interviews.
• Writes business specifications/requirements/rules, redesigns applications/processes, creates mockups, and analyzes user data.
• Partners closely with clients and developers to work through the phases of the systems development lifecycle (SDLC).
• Creates test plans to validate that system functionality satisfies associated business requirements.
• Designs and implements tests for system changes. Develops test case matrices, creates actual test cases, executes the tests, reviews actual vs. expected results, communicates and resolves issues, and documents results.
• Interacts with product owners/clients, other business analysts, software developers, and testers in the group.
• Utilizes various technologies, which may include (but are not limited to) Jira, Excel, SQL, Visio, Python, Selenium, Oracle, SQL Server, PowerBI/Tableau, Cognos, and Xceptor.

• Accredited bachelor’s degree or commensurate experience. Preferred (or required if applicable) majors include Management Information Systems (MIS), Business Analytics and Information Technology (BAIT), Business, Accounting, Computer Science, Finance, Economics.
• A business and technology major/minor combination is ideal.
• Minimum 3.1 GPA (on a 4.0 scale) preferred.
• Experience, college‑related coursework with investments (fixed income, equity, or derivatives) or investment accounting systems is a plus.
• Experience with SQL and related tools (e.g., Microsoft Query, Rapid SQL, DBeaver, etc.) preferred.
• Knowledge of the Software Development Life Cycle preferred and Agile methodology is a plus.
• Experience with Cognos or other reporting platforms is a plus.
• Experience with business analysis, requirements, software testing or proficiency tools (e.g., automated testing tools, compare tools, robotics, data visualization, Python) is a plus.
• Experience with Xceptor or other reconciliation platforms is a plus.
• Strong analytical and problem‑solving skills.
• Strong project management, organization, and communication skills.
• Proficiency with PC skills: MS Office suite including Excel, Word, PowerPoint, Visio, SharePoint, One Drive, MS Project, Outlook, dataflow, database and reporting, testing, project management, SQL, data processing/manipulation, compare tools, automated test tools, client server applications, data visualization, workflow, robotics, Power Automate.