Pension Systems Business Analyst

WTW•Bloomington, MN

1d•$75,000 - $110,000

About The Position

As a Business Analyst, you will help support Pension Outsourcing client delivery by translating business needs into system requirements, configuration, data conversion, testing, and production support activities. You will work closely with clients, other Business Analysts, developers, and pension administration teams to deliver accurate, high-quality technical solutions within defined scope, timing, and budget expectations. This role will focus on system configuration, data imports and conversions, ongoing imports, retiree payroll system functionality, batch jobs, reports, extracts, and related exports.

Requirements

Understanding of the core application, including functionality, available options, underlying database structure, data model, and process flows.
Ability to define complex system configuration, table updates, reporting requirements, data transformation logic, and related technical documentation.
Experience supporting data conversion, ongoing imports, batch jobs, retiree payroll system functionality, reports, extracts, and other exports.
Proficiency in creating, reviewing, and executing comprehensive component test plans across web applications, data imports, batch jobs, reports, extracts, and related system components.
Experience performing impact analysis and regression testing during release consumptions and other system changes.
Ability to create and evaluate database queries and procedures based on an understanding of the data model, relational database structures, and system relationships.
Proficiency using SQL and related tools to support analysis, validation, issue resolution, and testing of data conversion, imports, extracts, reports, and system functionality.
Experience coordinating issues identified during testing with developers, Business Analysts, and project teams, and driving issues through resolution.
Ability to assist senior Business Analysts in analyzing requests and providing guidance to resolve medium to high complexity configuration, testing, and data-related issues.
Experience ensuring development requests include specification updates, technical documentation, expected results, and unit test cases.

Nice To Haves

Employment-based non-immigrant visa sponsorship and/or assistance is not offered for this specific job opportunity.

Responsibilities

Establish and maintain effective client relationships by understanding client needs, expectations, and how the system supports their processes.
Inform clients and project teams on system functionality, available options, and related impacts.
Understand the statement of work and system scope, identify potential out-of-scope work, and bring those instances to the project team’s attention.
Assist with identifying work and hours needed to support change order drafting.
Demonstrate understanding of the core application, including functionality, available options, underlying database structure, data model, and process flows.
Define complex system configuration, table updates, reporting requirements, data transformation logic, and related technical documentation.
Support data conversion, ongoing imports, batch jobs, retiree payroll system functionality, reports, extracts, and other exports.
Create, review, and execute comprehensive component test plans across web applications, data imports, batch jobs, reports, extracts, and related system components.
Perform impact analysis and regression testing during release consumptions and other system changes.
Create and evaluate database queries and procedures based on an understanding of the data model, relational database structures, and system relationships.
Use SQL and related tools to support analysis, validation, issue resolution, and testing of data conversion, imports, extracts, reports, and system functionality.
Coordinate issues identified during testing with developers, Business Analysts, and project teams, and help drive each issue through resolution.
Assist senior Business Analysts in analyzing requests and providing guidance to resolve medium to high complexity configuration, testing, and data-related issues.
Ensure development requests include specification updates, technical documentation, expected results, and unit test cases.