Shire Jobs

Mobile Shire Logo

Job Information

Plymouth Rock Assurance Marketing Data Specialist Level 1-3 in Woodbridge, New Jersey

The position will start remotely and then transition to our Woodbridge, NJ office when the office re-opens.

The Marketing Data Specialist will be part of a team that is engaged in efforts to design, develop, implement and support datasets and reports across the enterprise. The Marketing Data Specialist will be expected to implement robust business processes and solutions. In addition, they will be expected to maintain awareness of new technologies and best practices.

This position requires that you must be adept at problem solving, interpersonal relations and have excellent oral/written communication skills. The Marketing Data Specialist will be expected to contribute with hands on development.

Initial level will be established upon hire based on experience.

Essential Functions and Responsibilities

  • Reading, transforming and analyzing data

  • Maintaining datasets according to best practices

  • Producing reports using SQL Server, SSIS and Tableau

  • Interfacing with processes and applications via multiple methods (SQL, FTP, API, Etc…)

  • Translate business needs into technical requirements

  • Work with team to implement solutions

  • Data and Report Validation

  • Ad-hoc work as required

Qualifications and Education

  • Bachelor's degree (B. A.) from four-year college or university.

  • Minimum 2-4 years of experience in SQL Server design and development as well as SSIS package development

  • Minimum 1-2 years of experience in Integration experience (API/Web Service/ETL/Batch)

  • Extensive knowledge of T-SQL programming including writing complex queries, stored procedures and functions

  • Self-motivated and directed, with the ability to effectively prioritize and execute tasks in a high-pressure environment.

  • Analytical and problem-solving abilities, with keen attention to detail.

  • Business Intelligence design and development a plus (preferably using Tableau)

About the Company

The Plymouth Rock Company and its affiliated group of companies write and manage over $1.4 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,800 people and is headquartered in Boston, Massachusetts. Plymouth Rock Assurance Corporation holds an A.M. Best rating of “A-/Excellent”.

Job ID: 2021-1953

External Company URL:

Street: 581 Main Street