Senior Data Analyst

plymouthrock; Port Reading (NJ); On-site; USD 105,000 - 136,000; Full time

Benefits offered by this job

4 weeks PTO + 9 holidays

Tuition Reimbursement

Health insurance from day 1

Wellness program & reimbursements

Auto/Home insurance discounts

Matching gifts

401(k) employer contribution

Paid family leave

Professional development support (Lic.

Job summary

Plymouth Rock is seeking a Senior Data Analyst to manage, design, test, and implement Data Warehouse projects across Policy, Claims, Quotes, Billing, and Data Marts. You will lead requirements analysis, data modeling, and SDLC activities, guiding teams and ensuring production data quality.

The role requires 10+ years in data analysis and software development, strong SQL skills, and experience with Snowflake in AWS.

Qualifications

• Bachelor's degree in Computer Science or equivalent with 10+ years software development experience (ideally SQL).
• 10+ years of Data Analyst experience.
• Experience in relational databases.
• Experience in data mapping and transformation.
• Experience using a software development life cycle (SDLC) methodology, including project planning and estimating.
• Experience with database applications in the AWS Cloud.
• Experience with SQL - DB2, SQL Server, Oracle and Snowflake preferred.
• Effective oral & written communication skills - must have the ability to be heard.
• Strong data modeling skills.
• Significant testing skillset and project management skills.

Responsibilities

• Internal management of projects throughout the project life cycle.
• Analysis and clarification of Business Requirements.
• Develop system specifications, including data transformations, using SDLC templates.
• Unit testing and involvement in integration, user and performance testing.
• Data Modeling.
• Directing/partnering with development.
• Mentoring Data Warehouse team members.
• Performance tuning.
• Prioritize with little assistance and take initiative.
• Learn new data sources quickly.
• Lead large projects when needed.
• Be an expert in data analyst tasks and seek improvements.
• Knowledge of P&C insurance data lifecycle and DW methodologies.
• Knowledge of Snowflake in AWS and ETL tools like Informatica.

Skills

SQL

Data analysis

Data modeling

SDLC

Project management

Communication

P&C insurance knowledge

Relational databases

AWS Cloud knowledge

Education

Bachelor's degree in Computer Science

Tools

Informatica

Snowflake

DB2

SQL Server

Oracle

Job description

The Senior Data Analyst position will be responsible for the management, design, testing and implementation of Data Warehouse projects for Policy, Claims, Quotes, Billing, Agency, ancillary components and Data Mart insurance application data. Primary duties will include reviewing requirements, estimating, analysis, data modeling, development of technical specification documents, development team support and guidance, significant quality assurance, implementation tracking, downstream application support and monitoring of data in production databases. This role also requires the ability to internally manage the project from Analysis through Post-Implementation phases. This role requires an experienced resource that possesses the ability to significantly contribute to work in all areas. This role will report to the Data Warehouse Analyst Supervisor, but on some projects may report to the Director.

Essential Functions and Responsibilities:

• Internal management of projects throughout the project life cycle.
• Analysis and clarification of Business Requirements
• Develop system specifications, including data transformations, using Software Development Life Cycle (SDLC) methodologies and templates.
• Unit testing and involvement in integration, user and performance testing as well as support of downstream IT and business applications utilizing the Data Warehouse data.
• Data Modeling
• Directing/Partnering with development
• Strong relationships with key Data Warehouse business and IT users
• Supporting users and members of the Data Warehouse team with direction and mentoring
• Performance tuning
• Working independently on both assigned tasks as well as have the initiatives to identify and complete needed tasks without being specifically assigned.
• Proactive approach to all work and the initiative to jump in to assist wherever needed
• Ability to prioritize with little assistance.
• Strong Problem Solving skills
• Ability to learn new data sources and patterns quickly
• Ability to take on a very large project solely if warranted
• Be an expert in data analyst tasks and continue to seek out areas that need improvement
• Knowledge of the Property and Casualty Insurance industry is a must
• Knowledge of the full life cycle of a Policy and Claim within the P&C world
• Knowledge of Data Warehousing Methodologies including Snowflake databases in the AWS Cloud
• Knowledge of Informatica or similar ETL tools to assist with researching the code

Qualifications and Education:

• Bachelor's degree in Computer Science (or equivalent experience), with 10+ years of software development experience (ideally SQL)
• 10+ years of Data Analyst Experience
• Experience in relational databases
• Experience in data mapping and transformation
• Experience using a software development life cycle (SDLC) methodology, including project planning and estimating.
• Experience with database applications in the AWS Cloud
• Experience with SQL - DB2, SQL Server, Oracle and Snowflake preferred
• Effective oral & written communication skills - must have the ability to be heard
• Strong data modeling skills
• Significant testing skillsetProject Management skills

Perks and Benefits

• 4 weeks accrued paid time off + 9 paid national holidays per year
• Tuition Reimbursement
• Low cost and excellent coverage health insurance options that start on Day 1 (medical, dental, vision)
• Robust health and wellness program and fitness reimbursements
• Auto and home insurance discounts
• Matching gift opportunities
• Annual 401(k) Employer Contribution (up to 7.5% of your base salary)
• Various Paid Family leave options including Paid Parental Leave
• Resources to promote Professional Development (LinkedIn Learning and licensure assistance)

Salary Range: $105,000 to $136,000 per year. Actual compensation will vary based on multiple factors, including employee knowledge and experience, role scope, business needs, geographical location, and internal equity.

About the Company:

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

#LI-DNI