JobCubby JobCubby
Sign up
WTW

Pension Systems Business Analyst

WTW Bloomington, Minnesota, United States · $75K–$110K/yr

Financial Services · 10,001+ employees

4 h ago
business-analyst Senior (5-10 yrs) Full-time United States
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The Business Analyst will support pension outsourcing by translating business needs into system requirements, configuration, and data conversion activities. They will collaborate with clients and technical teams to deliver high-quality solutions while managing system functionality, reporting, and production support.

What they look for

Pension outsourcing System configuration SQL Data conversion ETL mapping Relational databases Business analysis System requirements Test planning Regression testing Data modeling Technical documentation Retiree payroll Database queries Impact analysis Software development lifecycle

Requirements

Candidates should have a bachelor's degree and at least 5 years of experience in pension outsourcing or technical delivery roles. Proficiency in SQL, relational databases, and system development lifecycles is required to manage complex data transformations and testing processes.

Benefits

Medical insurance Prescription coverage Dental insurance Vision insurance Health savings account Commuter account Flexible spending accounts Group accident insurance Group critical illness insurance Life insurance AD&D insurance Group legal Identity theft protection Wellbeing program Employee assistance program Paid holidays Paid time off Short-term disability Long-term disability Bereavement leave Parental and adoption leave Contributory pension plan 401k savings plan

Full description

The Role

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.

Clients

  • 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.

Domain Knowledge and Delivery

  • 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.

Problem Solving and Requirements

  • 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.

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

Similar roles