
Senior Data Analyst
Role summary
Plymouth Rock Assurance is seeking a Senior Data Analyst in Woodbridge, NJ, for a hybrid role requiring 4 days onsite per week. This position focuses on implementing a new policy administration system, fixing data issues, and tracking defects. The role requires strong SQL skills, experience with Snowflake, policy administration knowledge, and data mapping/transformation capabilities. The analyst will also be involved in testing and assisting users with SQL queries. The ideal candidate possesses a Bachelor's degree (or equivalent experience) with 5-8 years of experience in querying relational databases, SDLC methodologies, and structured analysis. Excellent communication, analytical, and leadership skills are essential for driving efforts and collaborating with partners.
Senior Data Analyst
Plymouth Rock Assurance
Woodbridge, NJ – 4 days/week onsite
Rate: Open
F2F Interview required
- Need P&C insurance experience and Policy Admin experience
- Candidate needs to have excellent communication skills
- Will be responsible for implementing a brand-new policy administration
- Policy Administration knowledge - new systems - fix the bad data - what came in today whats the balance who is going to get the defect and track it to completion
- Log in defect tracking tool. Will require testing as well and SQL exp as candidate will be helping users with SQL. Knowledge of Snowflake ++
- Need someone with leadership skill, energetic and confident.
Knowledge, Skills and Education Required
• Bachelor’s degree in Computer Science (or equivalent experience), with 5-8 years of software development experience
• Experience in querying relational databases
• Experience in data mapping and transformation
• Knowledge of structured analysis
• Experience using a software development life cycle (SDLC) methodology, including project planning and estimating
• Experience with SQL with ability to create SQL queries for analysis and testing as well as assist developers in creating queries
• Effective oral and written communication skills
• Strong organizational skills
• Strong analytical skills and technical skills
• Ability to work with minimal direction
• Ability to lead, direct, and drive efforts of other team members
• Ability to work on multiple, concurrent projects
• Ability to effectively collaborate and build strong relationships with internal and external partners
• Attention to detail and quality
• Team player
• Strong motivational skills
Specific responsibilities include:
• Analysis and clarification of business requirements both internal and external
• Provision of work effort estimates to Project Managers
• Development of detailed functional and system specifications using Software Development Life Cycle (SDLC) methodologies and software tools.
• Collaboration with the Development team in all phases of the SDLC
• Development of use cases
• Design support, testing and monitoring of all required changes needed to maintain all compliance-related reporting and discretionary projects
• Creation of data and transformation mapping specifications
• Development of test plans and test cases, and execution of accurate and thorough testing
• Involvement in unit, integration, user and performance testing.
• Management of requirement and testing accountabilities through working closely with business and IT partners
• Support of audits and market conduct exams as needed
Other highly valued skills include:
• Knowledge of the Property and Casualty Insurance industry desired
• Prior experience with statutory and compliance-related reporting a plus
• Proficiency with MS Office suite
• Prior Supervisory experience
• Exposure to DB2 and SQL Server databases
• Exposure to Cloud technologies
• Ability to think outside of the box and a strong desire to improve the status quo
Similar roles
- Data AnalystHaystack · Chicago, Illinois, United States · Hybrid
Sr. Data AnalystKaseya · Miami, Florida, United States · Remote
Senior Data AnalystAmTrust Financial Services, Inc. · Dallas, Texas, United States · Hybrid- Data AnalystSolace · United States · Remote
- Junior Data AnalystPaw'some · New York, United States · Onsite