Product Support Analyst III

Job Summary: 

The Regulatory Reporting Analyst (RRA) serves as an internal subject matter expert in insurance regulatory reporting, covering NAIC, Solvency II, and BMA reporting. In this role, RRAsprovide guidance to both internal and external parties on theappropriate management of regulatory reporting. They alsoestablish and manage internal controls to guarantee the accuracy of data in this context. 

Responsibilities: 

• Ensures regulatory reportingprovided externally meets satisfactory requirements prior to delivery. 

• Applies intermediary fixes to reporting while development works on holistic reporting solutions. 

• Interacts with Product Owner and development teams toidentify and refine satisfactory reporting requirements. 

• Supports Operations Departments by answering questionsregarding the Clearwater software implementation regulatory guidance updates. 

• Creates tie-out rules that are used to check the data accuracy of reports. 

• Debugs code to root cause defects.  

• Responds quickly, accurately, and thoroughly to internal and external inquiries.

• Works closely with Software Development Engineers to resolve defects.

• Submits defects in code updates and retests and verifies these defects once they are fixed. 

• Serves as content expert in area of expertise.

• Reviews andprovides feedback on requirements, design, and scope documents.  

• Mayassist with education and training relating to NAIC Reporting enhancements and conveying corrections to other employees. 

• Applies acquired skills, procedures, and decision-making best practices to complete a variety of issues in creative ways.  I.e.: cash flows, complex assets, corporate actions, reference data, etc.  

• Looks for opportunities to improve our data and systems and can earn the ability toallocate 30% of their time to work on said projects.  

• Proficient knowledge of the front office. Canprovide an externally facing demonstration of our website and answer the most high-level questions about our offering.  

• Addresses client regulatory issues forexternal facing interactions and engages in client meetings andprovides updates. 

• Understands the difference between value and functionality and can consistently deliver value messages in internal and external interactions.  

• Able to fulfill most data mining requests. (Joins, Applies, Functions).  

• Able to read code with minimalassistance. 

• Runs pre-built queries, general understanding of SQL fundamentals and basic knowledge of computer languages (modify selects and where clauses).

Required Skills:  

• Strong skills with Excel such as VLOOKUP, SUMIF, Pivot Tables, and Ribbon Utilization. 

• Knowledge of Statutory Accounting for regulatory reporting and working with regulatory guidance.   

• Knowledge offinancial/investment accounting preferred. 

• Knowledge of fixed income investments preferred. 

• Securities or financial markets experience preferred. 

• SQL query writing skills preferred. 

• Knowledge of STAT and NAIC guidance preferred. 

• Strong computer skills, includingproficiency in Microsoft Office.  

• Excellent attention to detail and strong documentation skills.  

• Outstanding verbal and written communication skills.  

• Strong organizational and interpersonal skills. 

• Exceptional problem-solving abilities. 

Education and Experience:  

• Bachelor's/Master’s degree in finance, accounting, economics,data science, data analyticsor a related field. 

• 4+ years ofrelevantexperience.