Actuarial Data Analyst II - Arbella 56 Group : Job Details

Actuarial Data Analyst II page is loadedActuarial Data Analyst IIApply locations Quincy, MA time type Full time posted on Posted 7 Days Ago job requisition id R01501

Employer: Arbella Insurance Group

Job Site: 1100 Crown Colony Drive, Quincy, MA 02169

Job Title: Actuarial Data Analyst II

Job Duties:

Support financial data project initiatives for interpreting and translating data needs across Property & Casualty (P&C) insurance organization. Duties include:

• Ensure accuracy and completeness of tables and databases used for statistical reporting, pricing, reserving and analytical analyses used for P&C insurance pricing analysis;
• Analyze insurance data needs including quality assurance, data mapping, and data transformation associated with system migration and other company initiatives;
• Collaborate with stakeholders to understand insurance data needs and work with data engineers to build effective data models;
• Write SQL scripts and queries to extract insurance data;
• Create meaningful insurance data visualizations using Tableau and Power BI;
• Use programming languages including: Java, Python or R;
• Create data mappings and perform data gap analysis for downstream insurance applications; and
• Generate reports, dashboards, and data visualizations to present insurance findings.

May telecommute within commuting distance of the worksite.

Minimum Requirements:

Masters degree or foreign equivalent in Computer Science, Business Intelligence, Analytics or related field and 2 years of experience conducting analysis for Property & Casualty (P&C) insurance pricing; or in the alternative, employer will accept Bachelors degree or foreign equivalent in Computer Science, Business Intelligence, Analytics or related field and 5 years of experience conducting analysis for Property & Casualty (P&C) insurance pricing.

Experience must include the following, which may be gained concurrently:

2 years of SQL experience for P&C insurance including: developing custom SQL queries to extract data for analysis and reporting.

2 years of experience using ETL processes and data integration platforms to create and manage data mappings that consolidate data through different systems, applications and services.

2 years of experience verifying accuracy and completeness of data used in pricing analysis, risk models and reserve calculations for P&C insurance.

2 years of experience gathering and analyzing data requirements, and ensuring alignment with business objectives.

1 year of experience documenting data requirements, and ensuring alignment with business objectives.

2 years of experience working with data models.

2 years of experience writing and executing test cases, documenting results, and tracking defects.

2 years of experience analyzing business and regulatory changes and assessing their impact on data reporting and analysis.

**Job Opportunity Qualifies For Employee Incentive Referral Program**

Voted Bostons Best Place To Work by the Boston Business Journal since 2009!

People stay when they love a company and its cultureand our average tenure is over 11 years! We take care of our people with the same warmth and dedication that we do our customers. There is an energy here at Arbella. We are a people-first organization, and you feel that from the moment you walk in the door. Browse open positions and find your perfect fit.