Product Support Analyst III

Clearwater Analytics; Hinoba-an; On-site; PHP 5,003,000 - 6,879,000; Full time

Job summary

Clearwater Analytics is seeking a Regulatory Reporting Analyst to serve as the internal subject matter expert for insurance regulatory reporting (NAIC, Solvency II, BMA). You will guide internal/external stakeholders on reporting best practices and establish controls to ensure data accuracy across the regulatory lifecycle.

The role involves collaborating with Product Owners and engineering teams, implementing tie-out rules, and supporting operations with regulatory updates while maintaining high

Qualifications

• Bachelor's/Master’s degree in finance, accounting, economics, data science or a related field.
• 4+ years of relevant experience in regulatory reporting or insurance/financial services.
• Experience with NAIC, Solvency II or similar reporting standards.
• Strong Excel skills (VLOOKUP, Pivot Tables) and SQL familiarity.

Responsibilities

• Ensure externally delivered regulatory reports meet requirements.
• Apply fixes to reporting and assist development of holistic solutions.
• Collaborate with Product Owner and dev teams on reporting requirements.
• Support Operations by answering questions on Clearwater software and regulatory updates.
• Create tie-out rules to check data accuracy of reports.
• Debug code to identify defects and retest fixes.
• Provide expert knowledge and feedback on requirements and design.
• Educate and train on NAIC Reporting enhancements.

Skills

Excel proficiency

Attention to detail

Communication skills

Problem solving

Data analysis

Organizational skills

Interpersonal skills

Education

Bachelor's/Master’s degree in finance or related field

Tools

SQL

Job description

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.

Thank you for your interest in a career with Clearwater! Clearwater Analytics (NYSE: CWAN) is transforming investment management with the industry’s most comprehensive cloud‑native platform for institutional investors across global public and private markets. While legacy systems create risk, inefficiency, and data fragmentation, Clearwater’s single‑instance, multi‑tenant architecture delivers real‑time data and AI‑driven insights throughout the investment lifecycle. The platform eliminates information silos by integrating portfolio management, trading, investment accounting, reconciliation, regulatory reporting, performance, compliance, and risk analytics in one unified system. Serving leading insurers, asset managers, hedge funds, banks, corporations, and governments, Clearwater supports over $8.8 trillion in assets globally. Learn more at www.clearwateranalytics.com.

Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with the job description, we encourage you to still apply! You may be just what we’re looking for.