Business Analyst - Excel & SQL

Introduction

Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what's right.

We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive.

At Gallagher, you'll find more than a job; you'll find a culture built on trust, driven by collaboration, and sustained by the belief that we're better together. Experience a workplace where you're encouraged to be yourself, supported to succeed, and inspired to keep learning. That's what it means to live The Gallagher Way.

Founded in 2006, the Gallagher Center of Excellence (GCoE) upholds the values of quality, innovation, and teamwork. With 10,000+ professionals across five India locations, GCoE is where knowledge-driven individuals make a significant impact and build rewarding, long-term careers.

Overview

Working closely with clients and colleagues, the Business Analyst Health and Welfare plays a key role in the examination of business and functional/ system requirements to ensure the Health and Welfare system implementation and maintenance activities meet the established standards of quality as well as reliability, usability and performance. You will be responsible to ensure that the system solution in place reflects client's benefits.

How You'll Make An Impact

Be aware of projects and their particularities, develop test scenarios, perform various quality assurance tests and ensure that systems respond effectively

Ensure the quality, the follow-up and the respect of the phases of test schedules, of the various tests

Carry on with post-implementation follow-ups to ensure stability and if need, collaborate with the stakeholders to prioritize and to follow-ups on the patches

Identify situations that may significantly affect the quality of deliverables, provide feedback to stakeholders and ensure that appropriate corrective actions are taken

Participate in the planning, organization and follow-up of projects deliveries so that the various quality assurance, implementation and experimentation tests respect the commitments

Identify opportunities to purchase, propose and recommend solutions to optimize and evolve processes and work methods

Review Business Requirements & System Specifications of client's proposed solution Health and Welfare plan configuration, web set up, data conversion, payroll interface, carrier feeds, premium Billing etc.)

Execute configuration of the system through parameters

Develop and review test plans and expected results

Test system functionality and document results

Attend, participate and contribute to team meeting and client meeting

Work closely with the H&W Team Lead on communicating project progress and delivery

About You

Post-secondary education, bachelor's degree in Information Systems or Computer Science is preferred

Industry specific certifications

Minimum of 1-2 years of experience in a similar role

Bachelor's degree in Business Administration, Mathematics, Finance, Statistics, Technology

Knowledge of Health and Welfare plans

Knowledge of automated testing tool (implement and use) and Project and Test Management Tools

Knowledge of tools, concepts and methodologies of QA

Facility to handle and manage multiple tasks simultaneously

Ability to commit to deadlines and deliver on a timely manner

Capability to take ownership and be accountable for assigned tasks

Excel working in a fast-paced, deadline-oriented project team environment

Demonstrate high problem solving and analytical skills

Excellent oral and written communication skills to share concepts and information to teammates and clients

Client satisfaction focus along with team-oriented work style

Enjoy system analysis/implementation/documentation/testing/programming

Proficient with Microsoft Word, Excel, and Access

Knowledge of SQL, VB

Additional Information

Compensation and benefits

On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits.

Below are the minimum core benefits you'll get, depending on your job level, these benefits may improve:

Medical Insurance and Parental Medical Insurance

Accidental Insurance and Life Insurance

Retirals - Employee Gratuity, Future Service Gratuity benefit - Group Term Life, Employee Provident Fund, National Pension Scheme

Flexi Benefits Plan – Tax Savings Plans

Annual Leave/ Maternity & Paternity Leave/ Additional paid ML, Mental Health Day

Other benefits include:

Employee Wellness Programs

Training programs

And more..

We value inclusion and diversity

Inclusion and diversity (I&D) is a core part of our business, and it's embedded into the fabric of our organization. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work.

Gallagher embraces our employees' diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest.

Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination.