Reconciliation Implementation Analyst

Clearwater Analytics • Boise, ID

5d

About The Position

Reconciles transactions and holdings of investment portfolios to data received from external portfolio providers, using a state-of-the-art web-based system. Responsibilities include ensuring timely delivery of accurate investment information, including accounting, analytic, and compliance reports. The role involves validating investment data against available market data provided by third-party sources, managing internal and external inquiries and requests, and creating and maintaining valuable relationships with data providers, clients, and service delivery managers. This position will also work with product teams to continually iterate and improve reconciliation tools and processes, and with data engineers to automate reconciliation processes, aiming for over 90% automation. The analyst will apply reconciliation procedures and best practices to resolve a variety of issues, be aware of available resources, and correctly identify the appropriate tools to conduct research. A basic understanding of the front office and the accounting impacts of reconciliation options is expected, along with proficiency in navigating the "Big 3" menus. Consistently completing assigned tasks, daily reconciliation on-time and accurately, including red errors, yellow errors, ACEs, Recon Insight, etc., is crucial. When errors or mistakes occur, the analyst is expected to proactively learn from them and work to avoid repeat mistakes going forward.

Requirements

• Bachelor's degree in a finance-related and analytical field
• Dynamic problem solving, organizational and interpersonal skills
• Be naturally curious
• Excellent verbal and written communication skills
• Strong computer skills, including Microsoft Office
• An intense desire to learn something new and improve on a daily basis
• Beginner to Intermediate Excel, such as performing hot keys to performing a COUNTIF or SUMIF.
• Solid understanding of the CW End to End data flow and can identify and know the tools in the process, such as having an understanding that Scavenger feeds data to Prometheus, Prezo and Titan.
• Basic understanding of the front office and the accounting impacts of reconciliation options; Proficient with the "Big 3" menus and navigation.
• Accounting: Basic understanding of investment accounting, financial statements, amortization, interest income, and other accounting Cert concepts.
• Finance: Basic understanding of Time Value of Money, duration, yield, returns, and risk exposures as outlined in Cert material.
• Asset Classes: Basic understanding of vanilla fixed income and equity investments and a deepening knowledge of various security types and/or alternative security types. -what they are, why they are used, and how they work in CW.
• Developing understanding of the security types commonly held by the clients they are assigned.

Nice To Haves

• Finance and/or accounting experience
• Knowledge of GAAP and/or fixed income investments
• Securities or financial markets experience
• Advanced knowledge of Excel such as VLookUp, SUMIF, Pivot Tables, and Ribbon Utilization
• SQL query writing skills

Responsibilities

• Ensure timely delivery of accurate investment information, including accounting, analytic, and compliance reports
• Validates investment data against available market data provided by third party sources
• Manage internal and external inquiries & requests (main contacts include Treasurers & upper-level Accounting Managers)
• Create and maintain valuable relationships with data providers, clients, and service delivery managers
• Work with product teams to continually iterate and improve reconciliation tools and processes
• Work with data engineers to automate reconciliation processes, aiming at >90% automation
• Identifies an automation opportunity at least twice per month (24 total per year). Either submits a case or an account config with the aid of mentors.
• Applies reconciliation procedures and best practices to resolve a variety of issues.
• Aware of resources that are available and correctly identifies the appropriate tools to conduct research.
• Understands the general CW core value proposition (aggregate, reconcile, report).
• Consistently completes tasks assigned, daily reconciliation on-time and accurately, including red errors, yellow errors, ACEs, Recon Insight etc.
• When errors mistakes in daily work occur, proactively learns from mistakes, and works to avoid repeat mistakes going forward.
• Trusted to deliver accurate, timely, and thorough responses (Level 1) to routine inquiries in both written and verbal contexts.
• Communicates effectively and timely with leadership or team when assistance is needed to meet daily deliverables.
• Builds productive internal/external working relationships by communicating proactively (level 2 servicing).
• Able to simplify most concepts when communicating with internal or external parties, keeping the audience in mind.
• Uses the appropriate terminology when communicating with internal or external parties.
• Follows established procedures on work, requires only general instructions only on new issues.
• Builds upon expertise.
• Able to serve as a trainer for level 1 and 2 analysts.
• Can self-evaluate performance and make improvements when identified by self or by leadership.

Benefits

• 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.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level