Employee Benefits Data Analyst

HUB International; Scottsdale (AZ); Hybrid; USD 65,000 - 95,000; Full time

Benefits offered by this job

Flexible benefits options

Job summary

HUB International seeks a Data Analyst to provide analytics and underwriting support for the Employee Benefits Department, enabling data-driven decisions for clients. The role emphasizes accuracy, proactive insight, and collaboration within a fast-paced team.

You will source, manipulate, and format data, drive projections, and contribute to cost management as part of a 3–5-year plan. Mentorship and growth paths are offered for early-career professionals.

Qualifications

• BA/BS required, 1-3 years data analysis/finance experience; insurance/employee benefits exposure a plus.
• Must be highly proficient in Microsoft Excel and MS Office.
• Experience or familiarity with data warehouse and BI environments (SQL, Snowflake, Power BI) is a plus.
• Ability to present benefits data to HR, executives, and clients; detail-oriented with high workload management.

Responsibilities

• Provide detailed and accurate data analytics for HUB’s Employee Benefits clients.
• Manage deadlines and workflows in a fast-paced team environment.
• Extract data from primary/secondary sources and ensure accuracy and efficiency.
• Produce client-facing reporting, including financials, claims, renewal analysis, and budgeting.

Skills

BA/BS

Data analysis

Excel

SQL

Snowflake

Power BI

AI tools

Presentation

Education

BA/BS in finance, economics, mathematics, statistics, actuarial science, or related field

Tools

SQL

Snowflake

Power BI

Job description

This is a hybrid role, requiring three days per week in the office.

About HUB

In a rapidly changing world, HUB advises businesses and individuals on how to prepare for the unexpected. As one of the world’s largest insurance brokers, our focus is dedicated to providing our customers with the peace of mind that what matters most will be protected — through unrelenting advocacy and tailored insurance solutions that put our clients in control. Our growing team of professionals across North America represents a broad, deep and one-of-a kind aggregation of entrepreneurs and leaders recognized for their excellence throughout the insurance community.

Why Choose HUB?

Throughout our network of more than 600 HUB offices in North America, we offer a competitive, exciting, and friendly work environment that sets our employees up for long‑term success. At HUB, we believe in investing in the future of our employees and provide continuous opportunities for growth and development. Our culture empowers our people to make the best decisions for our customers and organization, focusing on expanding the industry knowledge of our insurance professionals to better serve our valued clients. We are committed to providing you with competitive and flexible benefits options that are rooted in your current needs yet evolves as your needs change over time. Join us as you build your career and grow your professional skills. We are the perfect fit if you: are seeking a fast‑paced role at a rapidly growing organization have a desire to help others protect their future enjoy taking initiative and helping grow the business are focused on learning and development to enhance your industry knowledge and expertise are a self‑starter willing to invest time and energy to learn the technical aspects of our business believe in integrity and building success by developing relationships with others

Data Analyst

HUB’s Data Analysts provide the critical data analytics and underwriting support to our Employee Benefits Department and customers that make us a leading sales and service organization in the insurance industry. Through a robust network of resources, you will be amongst some of the industry’s top talent to help guide and support our customer’s needs and help them find the right solutions. This role requires an individual who is professional, highly analytical, driven, and self‑motivated. The individual will provide timely, professional, and accurate data analytics services to the Employee Benefits Department and its customers. As a Data Analyst you will be responsible for sourcing, manipulating, and formatting data, using data to formulate projections and drive negotiations, and working in partnership with a team to develop effective cost management solutions as a part of a 3–5‑year strategic plan. This role is designed as a launchpad for early‑career professionals, with structured mentorship and a defined growth path toward senior analyst and financial consulting roles.

Responsibilities

• Provide detailed and accurate data analytics services on a growing block of business to Hub’s clients
• Manage multiple deadlines and workflows within a fast‑paced, team environment while maintaining high levels of accuracy and internal communication
• Maintain proficiency extracting data from primary and secondary sources with an emphasis on driving accuracy and developing process efficiencies
• Produce client‑facing reporting to include financial reporting and claims utilization, independent underwriting and renewal analysis, renewal projections, IBNR estimation, analysis of medical and pharmacy plan cost dynamics and budgeting
• Build strong knowledge of carrier products and networks, cost management solutions, and funding mechanisms
• Provide data and insight to support carrier negotiations and the overall renewal/marketing process
• Build your skill set around data analytics
• Support client service and sales by staying informed on industry trends
• Actively engage in and support training and development opportunities

Qualifications

BA/BS required, preferably in finance, economics, mathematics, statistics, actuarial science, or a related field 1-3 years of professional experience (internships included) in data analysis, finance, or a related field; insurance or employee benefits exposure is a plus but not required. Strong in analytics, mathematics, problem‑solving and negotiation skill sets Must be highly proficient in Microsoft Excel as well as other MS Office products Experience or familiarity with data warehouse and business intelligence environments (e.g., SQL, Snowflake, Power BI) is a plus Comfort learning and working with AI‑assisted analytics tools (e.g., Claude) is a plus Ability to present benefits data to key stakeholders, including HR teams, executives, and clients. Must be detail‑oriented, well‑organized and have the ability to manage a high‑volume workload with competing demands Ability to multi‑task and prioritize in a fast‑paced team environment Ability to travel to client sites as needed Excellent written and verbal communication skills

Hybrid work schedule

Hybrid work schedule; requires a minimum of three in‑office days per week at our Scottsdale, AZ location.

Equal Opportunity Employer

HUB International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.

Department Account Management & Service

Required Experience: 1-2 years of relevant experience Required Travel: No Travel Required Required Education: Bachelor's degree (4-year degree) Equal Employment Opportunity: HUB International Limited is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law. Reasonable Accommodations: HUB International Limited is committed to providing reasonable accommodations to qualified individuals with disabilities throughout the application and hiring process. If you need a reasonable accommodation to access our career site, complete an application, or participate in any part of the hiring process, please contact the Recruiting Team at [e-mail]. This contact information is for accommodation requests only and should not be used to inquire about the status of an application. E-Verify: HUB International Limited participates in E-Verify. Please refer to Our Recruiting Process | Applicant Notices: E-Verify Program for additional information.

Hi, we’re HUB

In a rapidly changing world, we advise businesses and individuals on how to prepare for the unexpected. When you partner with us, you're at the center of a vast network of experts who will help you reach your goals through risk services, claims management, and compliance support. And this gives you the peace of mind that what matters most to you will be protected — through unrelenting advocacy and tailored insurance solutions that put you in control.

About HUB International

Headquartered in Chicago, Illinois, HUB International Limited (HUB) is a leading full‑service global insurance broker providing property and casualty, life and health, employee benefits, investment and risk management products and services. From offices located throughout North America, HUB’s vast network of specialists provides peace of mind on what matters most by protecting clients through unrelenting advocacy and tailored insurance solutions. For more information, please visit hubinternational.com.