Company:
AssuredPartners
Location: Torrance
Closing Date: 05/12/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Overview:
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.
Keenan, an Accretive company, is an insurance brokerage and consulting firm meeting the insurance needs of hospitals, public entities and California school districts. Keenan specializes in providing consulting services in the areas of: employee benefits, workers' compensation, loss control, financial, and property & liability.
What You'll Do:
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.
What You'll Need:
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.
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.
Proficient in Microsoft Outlook, Excel, PowerPoint, and Word. Preferred proficiency in SQL, Python/R, Tableau and PowerBI.
What's in it For You?:
To help you make the best decision for your personal growth, it’s important to us to share a glimpse of what we offer our top asset, our people:??
Competitive base salary??
Generous 30+ Days Comprehensive Paid Time Off Package inclusive of Paid Time Off, 10 Company Holidays, 2 Floating Holidays, 5 Sick Days, and 2 Volunteer Days
Health benefit options with you in mind; 5 affordable medical plan options with rates based on your salary, company paid HSA contribution with eligible HSA plan selection, 2 dental plan options offering orthodontia coverage and 3 cleanings per year, and 2 vision plan options???
Company match 401(k) plan – 50% up to 6%!??
Support of your fitness wellness goals! We offer up to 75% off at over 11,000 gyms and fitness centers???
Opportunity to prioritize your mental health with 24/7 access to licensed therapists??
Pet benefits & discounts???
Access to our Employee-led Resource Groups (ERGs) that lend a voice to the variety of demographics represented throughout AssuredPartners?
Compensation:
The target salary range for this position is $75,000.00 to $95,000.00 (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. Hybrid work environment flexibility.
Grow, with us:
Accretive is a collection of elite specialty and wholesale agencies supported by experienced industry leaders. Our expertise is broad, and our innovative culture runs deep. We value relationships above all else and consistently deliver best in class customized solutions and service you can trust.
Accretive is passionate about fueling our clients’ innovation and growth. That makes us the perfect place for creative, dynamic people who want to grow their career while helping businesses, families and people thrive. We are proud to be one of the largest brokers in the country, but we’re even prouder of the honest, caring relationships that our employees build with our clients every day.
Working with us will give you the opportunity to do work that matters while you learn with us, advance with us, and most importantly, grow with us. Accretive is committed to embracing diversity, equity and inclusion to create a workplace that welcomes and thrives on the unique experiences, perspectives and contributions of all team members. Accretive is bringing the best people and most diverse talent forward to drive growth, innovate and think bigger!
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.
Keenan, an Accretive company, is an insurance brokerage and consulting firm meeting the insurance needs of hospitals, public entities and California school districts. Keenan specializes in providing consulting services in the areas of: employee benefits, workers' compensation, loss control, financial, and property & liability.
What You'll Do:
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.
What You'll Need:
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.
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.
Proficient in Microsoft Outlook, Excel, PowerPoint, and Word. Preferred proficiency in SQL, Python/R, Tableau and PowerBI.
What's in it For You?:
To help you make the best decision for your personal growth, it’s important to us to share a glimpse of what we offer our top asset, our people:??
Competitive base salary??
Generous 30+ Days Comprehensive Paid Time Off Package inclusive of Paid Time Off, 10 Company Holidays, 2 Floating Holidays, 5 Sick Days, and 2 Volunteer Days
Health benefit options with you in mind; 5 affordable medical plan options with rates based on your salary, company paid HSA contribution with eligible HSA plan selection, 2 dental plan options offering orthodontia coverage and 3 cleanings per year, and 2 vision plan options???
Company match 401(k) plan – 50% up to 6%!??
Support of your fitness wellness goals! We offer up to 75% off at over 11,000 gyms and fitness centers???
Opportunity to prioritize your mental health with 24/7 access to licensed therapists??
Pet benefits & discounts???
Access to our Employee-led Resource Groups (ERGs) that lend a voice to the variety of demographics represented throughout AssuredPartners?
Compensation:
The target salary range for this position is $75,000.00 to $95,000.00 (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. Hybrid work environment flexibility.
Grow, with us:
Accretive is a collection of elite specialty and wholesale agencies supported by experienced industry leaders. Our expertise is broad, and our innovative culture runs deep. We value relationships above all else and consistently deliver best in class customized solutions and service you can trust.
Accretive is passionate about fueling our clients’ innovation and growth. That makes us the perfect place for creative, dynamic people who want to grow their career while helping businesses, families and people thrive. We are proud to be one of the largest brokers in the country, but we’re even prouder of the honest, caring relationships that our employees build with our clients every day.
Working with us will give you the opportunity to do work that matters while you learn with us, advance with us, and most importantly, grow with us. Accretive is committed to embracing diversity, equity and inclusion to create a workplace that welcomes and thrives on the unique experiences, perspectives and contributions of all team members. Accretive is bringing the best people and most diverse talent forward to drive growth, innovate and think bigger!
Share this job
Useful Links