Plymouth Rock Assurance Sr. Regulatory Data Analyst in Boston, Massachusetts
The Senior Regulatory Data Analyst position is accountable for the analysis, design support, testing, and implementation of required data changes for all of the regulatory and compliance submissions and reports for the company initiated by a regulatory mandate. This will cover premium and loss-related submissions and reports as well as handling of special audits and market conducts. Primary duties include requirements review, estimation, 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
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
Knowledge of the Property and Casualty Insurance industry desired
Prior experience with statutory and compliance-related reporting a plus
Proficiency with MS Office suite
Exposure to DB2 and SQL Server databases
Required skills and Experience:
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 solid technical skills in data analysis
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
About the Company
The Plymouth Rock Company and its affiliated group of companies write and manage over $1.6 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”.
Job ID: 2021-2383
External Company URL: www.prac.com/
Street: 695 Atlantic Ave