Data Analyst II

Company: Plymouth Rock Assurance Corporation
Location: Boston, MA
Posted on: January 17, 2018

Job Description:

Develop, improve, publish, understand, explain, reconcile, and maintain

reports, data cubes, and data tables for the department. Produce ad hoc

analysis on a wide variety of insurance topics. Develop specifications

for Enterprise Aligned data cubes/repositories. Own entire books on

budget re-projections. Liaise between data team and various other teams,

scheduling and leading meetings. Work with business teams to understand

data needs, write detailed specifications for data repositories, marts

and cubes, and work to deploy specifications into the production

environment. Lead Data Warehouse and other testing efforts as needed;

including leading testing teams and owning the results. Develop and

design data sets. Create new reports and data elements in response to

adhoc data requests. Update models on a timely basis, analyzing actual

data to improve processes. Own models and assume responsibility for

communicating results to relevant teams. Analyze actual data to improve

processes. Independently troubleshoot and investigate inconsistencies in

reports or processes. Answer complex data-related inquiries and provide

support to internal customers.

Education and Experience:

Master’s degree (or foreign equivalent) in Applied Statistics,

Mathematics, Engineering, Information Systems, or related field and two

(2) years of experience performing insurance data analytics using SQL

and Tableau.

Special Requirements:

Also requires demonstrated expertise: performing insurance analytics; DE

constructing and manipulating data using Python, R and SQL to support

product analyses; DE utilizing Tableau and VBA to build and automate

reports, and Access and Excel to transfer data and create tables for

product profitability; and DE using relational database products,

including writing data queries in SQL, building, updating and

maintaining data cubes in SQL, and assembling code into SSIS packages.

**Expertise may be gained during graduate program.

To apply please email resume clearly referencing Job Code # JO-1801-1533

to recruit@plymouthrock.com

Keywords: Plymouth Rock Assurance Corporation, Boston , Data Analyst II, Insurance , Boston, MA, Massachusetts