Remote Data Analyst Insurance Risk & Analytics

Introduction

At Gallagher, we help clients face risk with confidence because we believe that when businesses are protected, they’re free to grow, lead, and innovate. You’ll be backed by our digital ecosystem: a client-centric suite of consulting tools making it easier for you to meet your clients where they want to be met. Advanced data and analytics providing a comprehensive overview of the risk landscape is at your fingertips.

Here, you’re not just improving clients' risk profiles, you’re building trust. You’ll find a culture grounded in teamwork, guided by integrity, and fueled by a shared commitment to do the right thing. We value curiosity, celebrate new ideas, and empower you to take ownership of your career while making a meaningful impact for the businesses we serve.

If you’re ready to bring your unique perspective to a place where your work truly matters; think of Gallagher.

Keenan is a leading insurance brokerage and consulting firm serving hospitals, public agencies, and California school districts. Specializing in employee benefits, workers' compensation, loss control, financial services, and property & liability, Keenan is committed to delivering innovative solutions that protect and empower the communities we serve.

As part of Gallagher, a global leader in insurance, risk management, and consulting, you’ll be joining a team that’s passionate about helping individuals and organizations thrive.

Keenan has an exciting career opportunity for a Data Analyst. The Data Analyst is responsible for all data tasks related to the implementation and ongoing support of Keenan’s proprietary benefits eligibility management systems. This includes data mapping, auditing, reconciliation, and import for the preparation of electronic carrier data transmittals.

• Collect and analyze policy, claims, and financial data to support underwriting and client reporting.
• Collaborate with business units to develop custom reports and dashboards.
• Use SQL, Power BI, and Excel for data extraction and visualization.
• Analyze treaty data and ensure accurate coding of claims.
• Work with the finance and underwriting teams on modeling and forecasting losses.
• Develop reports to track premium, loss ratios, and other KPIs for P&C portfolios.
• Collaborate with IT to optimize claims & underwriting data systems and tools.
• Analyze historical underwriting data to identify trends and improve pricing strategies.
• Automate data extraction and reporting processes for underwriting teams.
• Support actuarial teams with data preparation and validation for pricing and reserving models.
• Other duties as assigned.

Compensation:

The target salary range for this position is $60,000 to $75,000 (US Dollar) annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant’s geographic location. Remote work environment flexibility.

• Bachelor’s degree in Computer Science or Mathematics preferred or equivalent work experience of a minimum of two (2) years in a data analyst role.
• Strong analytical and problem-solving skills.
• Proficient in Microsoft Outlook, Excel, PowerPoint, and Word.

• Preferred proficiency in SQL, Python/R, Tableau and Power
  
  BI.

• Excellent verbal and written communication skills.
• Strong interpersonal and organizational skills.
• Ability to work independently and as part of a team.
• A self-motivated and organized work style is essential.
• Attention to detail and commitment to accuracy.

We offer a competitive and comprehensive compensation package. The base salary range represents the anticipated low end and high end of the range for this position. The actual compensation will be influenced by a wide range of factors including, but not limited to previous experience, education, pay market/geography, complexity or scope, specialized skill set, lines of business/practice area, supply/demand, and scheduled hours.

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…