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: www.prac.com/
Street: 581 Main Street