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