Job description

The Direct Marketing team is looking for a Senior Marketing Data Analyst to turn campaign and customer data into clear, actionable guidance for our direct-to-consumer auto insurance marketing programs. You'll own analysis end-to-end — from pulling and modeling the data, to building the dashboards and reports stakeholders rely on, to presenting recommendations that shape media spend, channel mix, and campaign strategy. RESPONSIBILITIES • Design, build, and maintain reporting and dashboards that track customer engagement and campaign performance across channels (digital, direct mail, paid search, affiliate, and more) • Provide analytics and actionable insights on the end-to-end Direct Sales funnel – from landing to sale – and provide concrete recommendations to optimize Customer Experience • Analyze campaign results and customer acquisition data to identify trends, measure ROI, and recommend ways to improve efficiency and conversion • Partner with marketing channel owners to scope reporting needs, define KPIs, and translate business questions into analytical approaches • Support marketing mix and channel attribution modeling, and help evaluate test-and-learn campaign results • Monitor and QA data feeds and tracking tags to ensure campaign performance data is accurate and complete • Collaborate with Data Engineering/BI teams on data pipelines, table structures, and self-service reporting tools • Present findings and recommendations to marketing stakeholders and, on occasion, to senior leadership • Mentor junior analysts on tools, techniques, and best practices as needed QUALIFICATIONS • Bachelor's degree in Marketing Analytics, Statistics, Mathematics, or a related quantitative field • 3–5 years of experience in marketing analytics, digital analytics, or a similar data-focused role • Proficiency with SQL and at least one statistical tool (e.g., R, SAS, Python) • Experience building dashboards and reports in a BI platform such as Tableau or Power BI • Previous experience working with Website analytics, conversion funnels and related metrics and tools (Heap, GA4, Fullstory, VWO) • Solid grasp of marketing & funnel metrics — response rates, CPA, LTV, channel attribution, funnel rates, bounce rates etc. • Experience leveraging AI-based tools for analytics (LLMs, AI-embedded or AI-native analytical tools) • Strong communication skills, with the ability to explain analytical findings to non-technical stakeholders • Comfortable managing multiple projects independently and prioritizing competing requests • Experience in personal auto insurance a plus SALARY RANGE The pay range for this position is $90,000 to $120,000 annually. Actual compensation will vary based on multiple factors, including employee knowledge and experience, role scope, business needs, geographical location, and internal equity. PERKS & BENEFITS • 4 weeks accrued paid time off, 8 paid national holidays per year, and 2 floating holidays • Low cost and excellent coverage health insurance options that start on Day 1 (medical, dental, vision) • Annual 401(k) Employer Contribution • Free onsite gym and health center at our Woodbridge Location • Resources to promote Professional Development (LinkedIn Learning and licensure assistance) • Robust health and wellness program and fitness reimbursements • Various Paid Family leave options including Paid Parental Leave • Tuition Reimbursement ABOUT THE COMPANY The Plymouth Rock Company and its affiliated group of companies write and manage over $2 billion in personal and commercial auto and homeowner’s insurance throughout the Northeast and mid-Atlantic, where we have built an unparalleled reputation for service. We continuously invest in technology, our employees thrive in our empowering environment, and our customers are among the most loyal in the industry. The Plymouth Rock group of companies employs more than 1,900 people and is headquartered in Boston, Massachusetts. Plymouth Rock Assurance Corporation holds an A.M. Best rating of “A-/Excellent”. #LI-DNI

Requirements

Must-haves

Design, build, and maintain reporting and dashboards that track customer engagement and campaign performance across channels (digital, direct mail, paid search, affiliate, and more)
Provide analytics and actionable insights on the end-to-end Direct Sales funnel – from landing to sale – and provide concrete recommendations to optimize Customer Experience
Analyze campaign results and customer acquisition data to identify trends, measure ROI, and recommend ways to improve efficiency and conversion
Partner with marketing channel owners to scope reporting needs, define KPIs, and translate business questions into analytical approaches
Support marketing mix and channel attribution modeling, and help evaluate test-and-learn campaign results
Monitor and QA data feeds and tracking tags to ensure campaign performance data is accurate and complete
Collaborate with Data Engineering/BI teams on data pipelines, table structures, and self-service reporting tools
Present findings and recommendations to marketing stakeholders and, on occasion, to senior leadership
Mentor junior analysts on tools, techniques, and best practices as needed
Bachelor's degree in Marketing Analytics, Statistics, Mathematics, or a related quantitative field
3–5 years of experience in marketing analytics, digital analytics, or a similar data-focused role
Proficiency with SQL and at least one statistical tool (e.g., R, SAS, Python)
Experience building dashboards and reports in a BI platform such as Tableau or Power BI
Previous experience working with Website analytics, conversion funnels and related metrics and tools (Heap, GA4, Fullstory, VWO)
Solid grasp of marketing & funnel metrics — response rates, CPA, LTV, channel attribution, funnel rates, bounce rates etc.
Experience leveraging AI-based tools for analytics (LLMs, AI-embedded or AI-native analytical tools)
Strong communication skills, with the ability to explain analytical findings to non-technical stakeholders
Comfortable managing multiple projects independently and prioritizing competing requests

Nice-to-haves

Experience in personal auto insurance a plus

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonai

Platform: adp-recruiting
Effort: medium

Benefits

Benefits detected in the listing.

Health Insurance

Dental

Vision

401(K)

Paid Time Off

Parental Leave

Wellness

Professional Development