Data & Insights Analyst - Gallagher

Discover a world of endless possibilities at Gallagher Benefit Services, where you'll have the power to shape the future of workplaces across industries. As a member of our team, you become the driving force behind positive change, helping clients build environments where employees thrive. Embrace the opportunity to impact lives, unlock potential, and create a legacy of remarkable transformation.

We believe that every candidate brings something special to the table, including you! So, even if you feel that you’re close but not an exact match, we encourage you to apply.

This position will play a critical role in providing (ongoing or custom) reporting, analytics and data-driven insights that support the effective design and management of our clients’ benefit plans. This role will collaborate closely with Financial Benefit Consultants and Actuarial Consultants, fulfilling both custom and ad hoc requests from our approved data warehouse platforms.  In addition, this role will play an important part in developing book of business insights that further Gallagher’s reputation as a thought leader in the benefits market.  As a key member of the Insights & Analysis team, successful candidates must possess strong technical skills and be strong problem solvers and critical thinkers.

Client & Prospect Support

• Develop and deploy aligned divisional processes, templates and dashboards for bringing best-in-class data analytic solutions to drive improved decision making and business performance for our clients;
• Support creation of ad hoc queries and deliver custom reporting / analyses and presentations using SQL, web-based query builders from approved data warehouses, Microsoft Excel or other analytic tools;
• Work collaboratively with Financial & Actuarial Consulting and branch account team members to determine clients’ analytics needs and deliver meaningful and actionable reporting and analytics solutions;
• Support key prospect targets with data-driven insights, as needed;
• Work closely with Data & Insights Lead, as well as the Director, Insights & Analysis and other key stakeholders to develop, improve and build upon our toolbox of benefits-focused analytic deliverables across the division;
• Support internal trainings of FAC teams – both divisional and regional – as well as supporting branch-level promotion of data & analytics services and capabilities.

Insights & Thought Leadership

• Work with Data & Insights Lead to create and deploy a regular cadence of meaningful book of business insights and trends;
• Support divisional marketing and thought leadership initiatives with data-driven Health & Benefits insights and trends from our combined databases in GBSInsider;
• Collaborate with New Business Intelligence team to regularly update metrics in support of prospect opportunity analyses – including book of business data, as well as data cuts by industry, size and/or geography.

Technical Expertise

• Work to develop and maintain expert-level knowledge of all GBS approved data warehouse platforms, learning coding languages and/or different dashboard capabilities, as needed;
• Continue to build technical skills on core tools and platforms – both through informal trainings and self-guided learning;
• Supporting large analytics projects from start to finish, as needed;
• Work to develop strong data storytelling capabilities and use those skills to create and present compelling and actionable analytics;
• Identify ongoing process improvement opportunities, and assist in the design, testing, documentation and implementation of process enhancements – also identifying opportunities for automation as they arise.

Competencies, Expertise and Business Acumen

• Excellent verbal and written communication;
• Strong strategic thinker and incredibly collaborative – both with internal team members and other divisional stakeholders;
• Shows interest and potential to be an excellent “data storyteller”;
• Self-starter with superb research skills and a general mindset of curiosity – investigating key drivers and root causes in data;
• Creative problem solver with strong critical thinking and analytical skills – collecting, organizing, analyzing and presenting significant amounts of information with attention to detail;
• Feels comfortable in giving and receiving constructive feedback;
• Strong interpersonal skills and ability to develop and maintain professional relationships with internal and external stakeholders;
• Consistently meets deadlines, and works well collaboratively as well as independently;
• Ability to sell the value of GBS data analytics products and services by illustrating potential impact to prospects and clients.

 Customer Service and Business Strategy

• Builds knowledge of Gallagher tools, systems and shared resources;
• Consistently follows client service workflows to ensure efficiency, timeliness and accuracy of execution;
• Is willing to go the “Extra Mile” to achieve results that benefit the client, the Branch and Gallagher;
• Accountable for meeting timeline of key analytics deliverables with consistency and accuracy;
• Is able to adapt quickly to a variety of circumstances, and change approach when necessary.

• Bachelor’s Degree in STEM or Business-related field, and 3+ years of health plan financial, data mining or reporting experience;
• Data Science, Analytics, Mathematics or Statistics background preferred, but not required;
• Advanced Excel and data analysis skills, including a working knowledge of PowerBI and/or SQL;
• A quick study with interest in learning new skills, tools and data platforms.

#LI-TW2

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/dental/vision plans, which start from day one!
• Life and accident insurance
• 401(K) and Roth options
• Tax-advantaged accounts (HSA, FSA)
• Educational expense reimbursement
• Paid parental leave

Other benefits include:

• Digital mental health services (Talkspace)
• Flexible work hours (availability varies by office and job function)
• Training programs
• Gallagher Thrive program – elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing
• Charitable matching gift program
• And more...

We value inclusion and diversity

Click Here to review our U.S. Eligibility Requirements

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.

Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as “protected characteristics”) by applicable federal, state, or local laws.

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 person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.