Data Analysis Excel Jobs in Worcester, MA (NOW HIRING)

For more than 170 years, The Hanover has been committed to delivering on our promises and being there when it matters the most. We live our values every day, demonstrating we CARE through our values, Sustainability initiatives and inclusive corporate culture.
Our Corporate Marketing and Communications team is currently seeking a Marketing Associate Data Analyst in our Worcester, MA location. This is a full-time, exempt role. Position is eligible for Hybrid/Flex work arrangement.
POSITION OVERVIEW:
This position is a results-oriented marketing data and reporting analyst who supports the Marketing team by improving contact data quality, maintaining recurring reporting, supporting data refreshes, and completing ad-hoc reporting requests. The role helps ensure that CRM, marketing automation, channel reporting, and campaign reporting data are accurate, current, and usable. Responsibilities include ongoing contact record cleanup, duplicate remediation, reporting maintenance, data quality review, and support for campaign audience and engagement reporting. This position partners closely with Marketing Automation, CRM, and other data/analytics partners to support cleaner contact data, more consistent reporting, and stronger campaign execution.
IN THIS ROLE, YOU WILL:

• Analyze and evaluate marketing, CRM, campaign, and reporting data to identify trends, surface insights, and support campaign recommendations.
• Support CRM and marketing data quality efforts by correcting record errors, reviewing contact statuses, researching and merging duplicate records, validating key contact and agency/account information, and tracking recurring data quality issues for escalation.
• Support campaign data QA by validating audience counts, reviewing duplicate or incomplete records, checking required fields, and escalating data issues prior to campaign execution.
• Conducts analysis to ensure marketing programs are showing adequate returns.
• Work closely with cross-functional teams to share data insights.
• Maintain contact cleanup queues, track remediation progress, and document recurring data quality issues for review by senior marketing data and analytics resources.
• Maintain recurring program and existing marketing reporting by refreshing reports, validating outputs, confirming data accuracy, and ensuring templates, definitions, filters, and reporting processes remain current and consistent.
• Employees are expected to meet the essential functions of their role, including maintaining regular, predictable and reliable attendance and adhering to their assigned work schedules.
• Onsite attendance requirements may vary by position and are subject to change based on business needs consistent with applicable law.
• Communicate effectively with internal and external stakeholders using appropriate channels, including phone, email, teams, and in person interactions as required.
• Ability to maintain sound judgement and attention to detail while managing multiple priorities under pressure in a fast-paced environment.

WHAT YOU NEED TO APPLY:

• 1-3 years of experience in marketing analytics, marketing operations, CRM/data quality, reporting, sales operations, or a related data-focused role. Proficiency in Excel required; experience with SQL, Power BI, CRM systems, or reporting tools preferred.
• Expertise with database querying/reporting tools.
• Familiarity with Marketing Automation tools and Salesforce a plus.
• Comfortable with quantitative information and the ability to recognize key trends and indicators within it.
• Highly analytical and detail oriented.
• Self-motivated and able to work effectively in an autonomous environment, proactive and persistent.
• Ability to communicate effectively, both orally and in writing with strong organizational skills.
• Comfortable with multi-tasking in a very fast-paced work environment.
• Cultivates an environment of teamwork and collaboration.

Core Capabilities:

• Excel including advanced functions
• PowerPoint
• Familiarity with PowerBI
• Familiarity with SQL

Physical Demands and Work Environment:

• Employees are expected to participate professionally in virtual meetings. Use of video cameras is expected under most circumstances.

This job posting provides cursory examples of some of the job duties associated with this position. The examples provided are not complete, and the position may entail other essential and job-related functions and responsibilities that employees will be required to perform.
CAREER DEVELOPMENT:
It's not just a job, it's a career, and we are here to support you every step of the way. We want you to be successful and fulfilled. Through on-the-job experiences, personalized coaching and our robust learning and development programs, we encourage you - at every level - to grow and develop.
BENEFITS:
We offer comprehensive benefits to help you be healthy, build financial security, and balance work and home life. At The Hanover, you'll enjoy what you do and have the support you need to succeed.
Benefits include:

• Medical, dental, vision, life, and disability insurance
• 401K with a company match
• Tuition reimbursement
• PTO
• Company paid holidays
• Flexible work arrangements
• Cultural Awareness Day in support of IDE
• On-site medical/wellness center (Worcester only)
• Click here for the full list of Benefits

EEO statement:
The Hanover values diversity in the workplace and among our customers. The company provides equal opportunity for employment and promotion to all qualified employees and applicants on the basis of experience, training, education, and ability to do the available work without regard to race, religion, color, age, sex/gender, sexual orientation, national origin, gender identity, disability, marital status, veteran status, genetic information, ancestry or any other status protected by law.
Furthermore, The Hanover Insurance Group is committed to providing an equal opportunity workplace that is free of discrimination and harassment based on national origin, race, color, religion, gender, ancestry, age, sexual orientation, gender identity, disability, marital status, veteran status, genetic information or any other status protected by law."
As an equal opportunity employer, Hanover does not discriminate against qualified individuals with disabilities. Individuals with disabilities who wish to request a reasonable accommodation to participate in the job application or interview process, or to perform essential job functions, should contact us at:HRServices@hanover.com and include the link of the job posting in which you are interested.
Privacy Policy:
To view our privacy policy and online privacy statement, click here.
Applicants who are California residents: To see the types of information we may collect from applicants and employees and how we use it, please click here
Compensation:
The target hiring range for this role may vary based on geographic location and other factors, including merit or performance, demonstrated proficiency, skills for the role, education, travel requirements, and experience. Additional compensation may include an annual bonus (which could take the form of a general bonus, sales incentive, or short-term incentive), long-term incentive or spot recognition awards. The posted range reflects our ability to hire at different position titles and levels depending on background and experience.