Job Summary The Reconciliation Analyst is responsible for comparing investment portfolio data from external sources with an advanced web-based system Their primary responsibility is to guarantee the prompt and precise delivery of comprehensive portfolio status updates to clients on a daily basis Responsibilities Meet daily deadlines for reviewing and updating reporting data Investigate and address identified issues within the reconciliation system through problem-solving seeking support from mentors and department experts as needed Create and maintain valuable relationships with data providers clients and internal stakeholders Demonstrate curiosity regarding product innovation opportunities Develop familiarity with and competency in using internal tools and processes Understand financial concepts and apply them to reconciliation errors Communicate effectively with internal and external parties to submit inquiries and provide timely updates on relevant issues Required Skills Basic understanding of investment financial and accounting concepts Knowledge of GAAP and or IFRS will be an added advantage Basic understanding of standard security types Securities or financial markets experience preferred Advanced ability in Microsoft Excel VLOOKUP SUMIF Pivot Tables VBA etc preferred Finance and or accounting experience preferred Strong computer skills including proficiency in Microsoft Office Excellent attention to detail and strong documentation skills Outstanding verbal and written communication skills Solid organizational and interpersonal skills Exceptional problem-solving abilities Education and Experience Bachelor s degree in accounting Finance Business Mathematics Sciences or another related field