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, RRAs provide guidance to both internal and external parties on the appropriate management of regulatory reporting. They also establish and manage internal controls to guarantee the accuracy of data in this context.
Responsibilities
Ensures regulatory reporting provided 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 to identify and refine satisfactory reporting requirements.
Supports Operations Departments by answering questions regarding 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 and provides feedback on requirements, design, and scope documents.
May assist 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 to allocate 30% of their time to work on said projects.
Proficient knowledge of the front office. Can provide an externally facing demonstration of our website and answer the most high-level questions about our offering.
Addresses client regulatory issues for external facing interactions and engages in client meetings and provides 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 minimal assistance.
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 of financial/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, including proficiency 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 analytics or a related field.
4+ years of relevant experience.

Work arrangement
No