Business Analyst 2

Willis Towers Watson Pittsburgh , PA 15201

Posted 2 months ago

As a Business Analyst 2 within the Benefits Outsourcing team at Willis Towers Watson, you will have the opportunity to use our technical know-how and hands-on experience to provide benefits administration services to many of the world's largest and most complex organizations. Our benefit expertise, consultative approach and focus on quality are unrivaled.

The Role

As a Business Analyst working with Systems, Data, and the Client you will serve a key role for our outsourcing business by serving as the link between consultants, external clients and our internal team of system developers. You will contribute to the implementation of new services, and ongoing business by translating business needs into actionable programming and process steps for developers, practicing the fundamentals of systems analysis, design and testing. You will also consult to clients concerning implementation best practices, provide ongoing technical support, and train client teams.

Note: This role will involve some travel to client sites and other Willis Towers Watson offices.

A Few Select Responsibilities:

  • Ensure that all documentation starts from baseline and adheres to standards; communicate back to base team suggestions for changes or enhancements to standard documentation.

  • Attends client meetings relevant to the components they have responsibility for, to establish client relationship and ensure complete understanding.

  • Responsible for developing requirements documentation.

  • Responsible for system configuration based on client requirements.

  • Responsible for creating test plans, and testing system changes and enhancements to ensure completeness and accuracy. Regression testing as necessary based on the nature of the system change/enhancement.

  • Identify reporting needs and requirements.

  • Understand SOW and be responsible for change order identification and assist with providing work and hours necessary to draft the change order.

  • Work closely with developer to ensure project requirements/requests for changes are understood and within standards.

  • Provide guidance to other team members regarding best/standard practices.

  • Provide guidance/assistance to team members where needed to help ensure issues are resolved by assigned due date.

  • Escalate concerns with ability to meet due dates to Project Manager.

  • Train and help transition ongoing processing requirements to Business Systems Administrator.

  • Lead client requirements meetings as needed.

  • Maintain and update all requirements documents, ensuring adherence to standards.

  • Research issues and cases to determine root cause and provide impact analysis for ongoing issues and changes and requests for new functionality.

  • Addresses all calc or data issues that impact carriers.

  • Assist PM with development of Project Plan for open enrollment and significant change orders.

  • Responsible for any vendor file updates and ongoing support.

  • Provide training for client on large-scale change orders to client, Benefits Outsourcing Center and Service Center, as needed.

  • Visa sponsorship is not provided for this position

The Requirements

  • Desire to learn, accept new challenges, and have fun!

  • 2-4 years' experience as a Business Analyst

  • Understanding of the fundamentals of health and welfare and broader benefit plan design preferred

  • Ability to complete Willis Towers Watson Business Analyst training program

  • Intermediate to advanced SQL skills

  • Experience with relational databases including SQL, Oracle or Access preferred

  • Experience with test plan creation, testing procedures and test plan execution

  • Strong analytical, integrative and problem-solving skills

  • Solid interpersonal skills and client service orientation

  • Ability to work both independently and on client teams, including virtual work teams with members in different geographic regions

  • Strong organizational abilities and flexibility to work in a performance driven environment managing multiple project priorities

  • Sense of accountability, owning one's work and taking pride in it; commitment to quality and continuous improvement

  • Ability to travel and work extended hours as needed

EOE, including disability/vets

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Data Analyst 8179

Federated Hermes, Inc.

Posted 5 days ago

VIEW JOBS 5/6/2021 12:00:00 AM 2021-08-04T00:00 Job Title Business Data Analyst Job ID 8179 Location Pittsburgh Full/Part Time Full-Time Favorite Job Regular/Temporary Regular * JOB OPENING #: 8179 POSITION TITLE: BUSINESS DATA ANALYST DEPARTMENT: CLIENT DATA AND FUND ADMINISTRATION * POSITION SPECIFICATIONS: * Bachelor degree required; Bachelor degree in Accounting, Business, Mathematics or Computer Science preferred * Minimum 3 years of business experience required; Experience in the mutual fund or financial services industry preferred * Familiar with business analysis or business process improvement methodologies required * Proficiency in Microsoft Access and advanced Excel skills required * Experience with data query tools required * Experience with Visio preferred * Experience managing data in an enterprise sales reporting and/or CRM application preferred MAJOR DUTIES: Provides analytical and technical expertise to support the ongoing management of client, sales asset, territory and advisor data in MARS (Sales & Asset Reporting application) and TotalClient Enterprise (CRM application). The position requires exceptional problem-solving skills and the ability to effectively collaborate with peers, managers and 3rd-party vendors. The employee in this position will extensively leverage problem solving, analytical, technical and creative-thinking skills to identify, recommend and implement automated solutions that will ensure the ongoing quality of client, sales asset, territory and advisor data in the MARS and TotalClient Enterprise applications, as well as enhance operational efficiency and effectiveness in the management of such data. * Analyze and evaluate client, sales, asset, territory and advisor data in the MARS and TotalClient Enterprise databases; identify patterns, synthesize findings, derive conclusions and design and implement solutions that will improve overall data quality and increase internal client satisfaction * Identify and implement re-engineering opportunities for existing MARS client data file interfaces to bring greater efficiencies and quality via automation * Develop and execute queries against the MARS and TotalClient Enterprise databases in response to data quality issues escalated by our internal clients; perform complex data analysis to identify root cause and recommend remedial actions to correct the existing data quality issues and avoid perpetuating the issues by introducing changes to business and/or data processes * Collaborate with Enterprise Data Governance, management and internal clients to establish and implement data standards to increase the usefulness, timeliness and accuracy of the data; implement automated processes to monitor and ensure the adherence to such data standards * Develop and maintain relationships with internal business partners, including Decision Support, Risk Management, Intermediary Compensation, Investor Services, External and Internal Sales, Sales Administration and Marketing to understand their business goals and objectives; identify data opportunities to assist them in achieving their business objectives * Participate in the evaluation and implementation of new Advisor data interfaces and/or data augmentation to the MARS and TotalClient Enterprise databases * Participate in evaluation, development and implementation of new client data interfaces to the MARS database * Provide technical and analytical support to business initiatives such as sales territory realignments, new client data file acquisition, enterprise data management initiatives and major system upgrades; extract and analyze data to aid in the development of the approach and creation of the plan to execute such initiatives * Participate in all phases of the project life cycle; define and document business requirements, create detailed work plans and lead the execution of project-related tasks on behalf of CDFA * Create and execute test plans; monitor and escalate issues to project manager, stakeholders and sponsors; ensure issues are appropriately vetted with internal resources and vendor partners and effectively remediated to satisfy the business requirement * Provide technical guidance and consultative services to our internal clients regarding questions and issues related to MARS and TotalClient Enterprise data * Document procedures and create job aids where applicable; review procedures periodically and make requisite changes as appropriate * Perform ad hoc data analysis and reporting as needed HOURS/LOCATION: * 8:30 a.m. - 5:00 p.m. (overtime as required) * Warrendale location - Warrendale, PA 15086 EXPLANATORY COMMENTS: * Strong decision-making, problem solving and analytical skills with attention given to detail and accuracy. * Strong written and oral communication skills * Excellent time management skills with ability to handle multiple projects/priorities simultaneously * Strong problem solving and conceptual thinking ability * Flexibility to work independently and as a member of a team * COMMENCEMENT DATE: 05/04/2021 Federated Hermes is committed to providing equal employment opportunities to qualified individuals without regard to the following criteria: race (including physical characteristics such as hairstyles), color, national origin, religion, sex (including pregnancy), sexual orientation, gender identity or expression, mental or physical disability, age, familial or marital status, ancestry, military status, veteran status or genetic information as well as any other prohibited criteria under any applicable local, state or federal law applicable to Federated Hermes. To review Federated Hermes' California Privacy Notice go to and select CA Applicant Notice. Federated Hermes, Inc. Pittsburgh PA

Business Analyst 2

Willis Towers Watson