Job Description

Gallagher is a global leader in insurance, risk management and consulting services. We help businesses grow, communities thrive and people prosper. We live a culture defined by The Gallagher Way, our set of shared values and guiding tenets. A culture driven by our people, over 30,000 strong, serving our clients with customized solutions that will protect them and fuel their futures.

Position Summary:

Primarily focused on collecting, maintaining, managing, interpreting and analyzing data received from internal data and external data sources. Evaluates data integrity to identify potential concerns and opportunities for process improvements.

Key responsibilities further include:

* Analyzing data using statistical methods
* creating reports to illustrate findings and recommendations
* Building statistical models
* Evaluating business requirements to identify new and changing reporting needs
* Performing quality testing and validation of data sets; and presenting data, ideas, and analysis results to business leadership to aid in identifying opportunities and risk exposure.
* Will support on key projects and may lead smaller projects.

Essential Functions

* Primarily focused on collecting, maintaining, managing, interpreting and analyzing data received from internal data and external data sources.

* Evaluates data integrity to identify potential concerns and opportunities for process improvements.

* Key responsibilities further include: o Analyzing data using statistical methods; creating reports to illustrate findings and recommendations; Building statistical models, Evaluating business requirements to identify new and changing reporting needs; Performing quality testing and validation of data sets; and presenting data, ideas, and analysis results to business leadership to aid in identifying opportunities and risk exposure.

* Will support on key projects and may lead smaller projects.

* Support and maintenance of client accounts, including: o Research o Analysis and evaluation of data from medical, dental, life and disability plans and programs o Detailed reconciliation of accounts and data process

* Process monthly variance reports and responses from clients from reconciliation reports

* Process carrier reports related to remittance discrepancies

* Process manual adjustments to billing and carrier remittance

* Processing of monthly data interface files and client enrollment data

* Responsible for resolution of both simple and complex client issues

* Carrier/vendor interaction, at both a transactional and technical level

* Coordination with other Gallagher/McGregor departments on issue resolution, including Accounting, Underwriting, and IT.

* Verify and update rates during Renewal and Open Enrollment processes

* Assist with projects involving large data files and systems

* Participate in process improvement, including needs and testing of solutions

* Development of client ready reports, training materials, and documentation

* Cross training to other departments

* Exhibit the highest degree of professionalism and creativity, representing Gallagher/McGregor in both client and team situations

* Other duties as assigned

Requirements:

* Bachelors degree in business, mathematics, statistics, computer science, information technology, or related field.
* Minimum 3 years of experience in a data analyst or relevant role.
* Strong analytical capabilities.
* Proficient in Microsoft Excel and various business intelligence and analytical tools.

Work Traits:

* Communication skills with the ability to distill complex subjects to a wider audience.
* Excellent leadership, collaboration, and project management skills.
* Keen attention to detail.

U.S. Eligibility Requirements:

* Interested candidates must submit an application and resume/CV online to be considered
* Must be 18 years of age or older
* Must be willing to submit to a background investigation; any offer of employment is conditioned upon the successful completion of a background investigation
* Must have unrestricted work authorization to work in the United States. For U.S. employment opportunities, Gallagher hires U.S. citizens, permanent residents, asylees, refugees, and temporary residents. Temporary residence does not include those with non-immigrant work authorization (F, J, H or L visas), such as students in practical training status. Exceptions to these requirements will be determined based on shortage of qualified candidates with a particular skill. Gallagher will require proof of work authorization
* Must be willing to execute Gallagher's Employee Agreement or Confidentiality and Non-Disclosure Agreement which require, among other things, post-employment obligations relating to non-solicitation, confidentiality and non-disclosure

Gallagher offers competitive salaries and benefits, including: medical/dental/vision plans, life and accident insurance, 401(K), employee stock purchase plan, educational expense reimbursement, employee assistance program, flexible work hours (availability varies by office and job function) training programs, matching gift program, and more.

Gallagher believes that all persons are entitled to equal employment opportunity and does not discriminate against nor favor any applicant because of race, sex, color, disability, national origin, religion, creed, age, marital status, citizenship, veteran status, gender, gender identity / expression, actual or perceived sexual orientation, or any other protected characteristic. 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. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified applicant with a disability, unless the accommodation would impose an undue hardship on the operation of our business.

Additional Information