Marketing Data Analyst II
Company: Plymouth Rock Assurance Corporation
Location: Boston, MA
Posted on: October 9, 2017
Job Description:
Title: Marketing Data Analyst II (Boston, MA) Description: Will develop, publish, improve and maintain reports and data
sets for the Marketing Department. Will advise on all marketing-related data
and reporting functions. Will produce reports on a wide variety of
insurance marketing analytics such as sales funnels, close ratios, quote
data, and other online metrics. Will collaborate with other teams to
develop data sets for cross-departmental use. Will use ETL tools, Tableau, MS
SQL Server and SSIS to maintain programs, automate reporting processes,
update documentation and publish results. Will review weekly, monthly,
quarterly and annual reporting for accuracy. Will utilize relational
database tools to write data queries in SQL as well as build, update and
maintain data sets in SQL. Will create reports to accommodate ad hoc data
analysis requests. Will update data sets and analyze actual data to
improve processes. Will serve as a resource for complex data-related
inquires and prov provide data and other analytical information to internal
customers. Education and Experience: Master’s degree in Statistics, Mathematics, Marketing Analytics
or related fiel field (foreign educational equivalent accepted) and one (1) year
of expe experience utilizing SQL to extract data and conduct ad hoc
analysis. Special Requirements: Also requires demonstrated expertise: designing statistical
regression models using SAS and R; DE performing clustering analysis for
customer segmentation, and logistic regression models to analyze email
campaign data; DE using Tableau and Google Analytics to capture customer
activity and translate information derived from data analysis to
stakeholders; and DE using SQL to analyze customer activity data and use analysis
to improve Customer Relationship Management (CRM). To apply please email resume clearly referencing Job Code #
JO-1710-1449 to r recruit@plymouthrock.com
Keywords: Plymouth Rock Assurance Corporation, Cranston , Marketing Data Analyst II, Insurance , Boston, MA, Rhode Island