Work in Illinois Jobs

Illinois Job Link Logo

Job Information

Gallagher Senior Salesforce Administrator in Rolling Meadows, Illinois

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:

The Senior Salesforce Administrator & Reporting Applications Specialist will perform hands-on technical implementation, project management, administration and system evangelizing.

Essential Duties and Responsibilities:

  • This person will also be responsible for executing day-to-day configuration, training, maintenance, and general support or improvement to the platform.

  • The successful candidate will embrace the challenge of solving critical business problems and acting as the knowledge expert for evolving new processes within the company.

  • Senior Salesforce Admin & Reporting Applications Specialist will define & create reports as needed and evaluate data to implement new reports as appropriate.

  • Configure dashboards for various audiences and provide clear, cogent explanations of the derivation of metrics and other analysis, includes tracking and analyzing sales and financial metrics relating to pipeline, sales goals, cross-selling, and overall performance.

  • Works to ensure data integrity across reports across the organization, maintaining a reporting dictionary defining core measures on which reports are built.

  • Must also understand the importance of protecting Gallagher’s data and act in accordance with organizational priorities. Compliance with standard SDLC methodologies.


  • Education: Bachelor’s degree with specialization in computer science, finance, accounting or business administration is preferred

  • Professional experience (5 years strongly preferred) in a functional role concerned with Administration at an enterprise level above 500 users preferred in EITHER Sales Cloud and/or Service Cloud environments

  • 5 years’ experience in a functional role concerned with reporting and report analysis

  • Experience within the benefits brokerage, insurance, financial services, or similar industry is desired but not required

  • Possess the strong ability to absorb and evaluate information from a variety of sources and maintain a "big picture" view

Technical Skills:

  • Strong understanding of best-practices and functionality

  • Experience with DataLoader required

  • Use of Workbench

  • Use of Demand Tools

  • Use of Eclipse or Ant

  • Ability to read Visual Force and APEX code

  • Ability to create HTML5/javascript/CSS

  • Experienced in BOTH Salesforce Classic and Lightning UI/UX

  • Advanced level with writing MS Excel 2016 or newer (using functions and macros, pivot tables)

  • Advanced level MS Access (building queries and reports)

  • Intermediate level of reporting tools such as Microsoft SQL Report Services and Power BI

  • Intermediate level of understanding of relational database methodology

  • Experience with Report Writing and Administration

  • Microsoft Office products including Outlook, Word, PowerPoint, and Visio

  • Resolution of internal Service Desk Support Tickets by Users

  • Advanced experience with creating complex Flows

  • Advanced experience in using Process Builder

  • Advanced experience in Aura and Lightning Web Components

  • Implementation experience with Custom Objects, Workflows, Formulas, and Validations Rules

  • Works with internal clients to develop and document clear, testable requirements

  • Oversee the feature request/support backlog and work with the Director/Leader to prioritize and execute

  • Trains stakeholders on how to effectively access and use reports, dashboards and reporting/analytics tools

  • Identifies best-practices supporting business performance relating to efficiency and improved customer service

  • Identifies systems and process barriers to generate ideas for improvement

  • Support and train team members and end-users on how to effectively use both Sales Cloud and Service Cloud

  • Assist in defining required features and mapping features to business processes

  • Evangelize and drive user-adoption across the Division

  • Implement enhancements and roll-out new features to the platform

  • Create and maintain on-going documentation processes as business needs evolve or features are added

  • Comply with AJG IT policies and procedures

  • Work directly with stakeholders, vendors, & Software Engineers to plan & implement technical solutions

  • Creates and maintains reports and dashboards in, SQL Reporting, MS Excel, and Power BI

  • Integrations with other systems – MS Exchange, Enterprise Telephony, and ETL tools

  • Ability to work across multiple Salesforce orgs simultaneously

Interpersonal Skills:

  • Must be able to work independently and in a team environment but remotely

  • EXCELLENT oral, written communication and listening skills

  • Strong analytical and problem-solving skills

  • Must be self-motivated, goal-oriented, people-oriented and have a high energy level

  • Commitment to and record of strong customer service

  • Ability to manage multiple projects and priorities with deadlines

  • Ability to be proactive with regard to problem resolution

  • Effective time-management skills

  • Must have the “heart of a teacher”, patience, and willing to coach and share their knowledge with others

  • Must be comfortable working in a fast-paced environment and handling multiple tasks/priorities

  • Good organizational skills and a strict attention to detail and proven ability to follow through

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 requires, 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.


Job: Information Technology

Organization: GBS - Operations

Title: Senior Salesforce Administrator

Location: Illinois-Rolling Meadows

Requisition ID: 67635