Senior Data Analyst

The Senior Regulatory Data Analyst position is accountable for the analysis, design support, testing, and implementation of required data changes for all of our company’s regulatory and compliance submissions and reports initiated by a regulatory mandate or a discretionary project.  This includes premium and loss-related submissions and reports as well as handling of special audits and market conducts.   Primary duties include requirements review, estimation, data and analysis, creation of accurate technical specifications, development team support, thorough quality assurance, implementation tracking, and production validation support. 

Additional responsibilities include oversight and management of assigned submissions and reports - monitoring, creation, balancing, ensuring timely delivery, and supporting inquiries from internal and/or external recipients.

This position will evolve into a lead role within the group and will require oversight of projects and resources within the team.

Responsibilities:

• 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

Qualifications:

• Bachelor’s degree in Computer Science (or equivalent experience), with 5-8 years of software development experience
• Knowledge of the Property and Casualty Insurance industry desired
• Prior experience with statutory and compliance-related reporting a plus
• 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
• Strong analytical skills and technical skills
• 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
• 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

Perks and Benefits

• 4 weeks accrued paid time off + 9 paid national holidays per year
• Free onsite gym at our Boston Location
• 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)
• Convenient location directly across from South Station and Pre-Tax Commuter Benefits

About the Company

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

#LI-DNI