Job Description
The Associate will assist in n identifying, investigating, and resolving data discrepancies across various systems and databases. This includes performing regular data reconciliations, maintaining accurate records, and generating detailed reports.
Perform data reconciliation across multiple systems and databases.
Identify, investigate, and resolve data discrepancies and inconsistencies.
Develop and implement data validation and reconciliation procedures.
Collaborate with other departments to ensure data integrity and accuracy.
Maintain accurate records of reconciliation activities and resolutions.
Generate regular reports on reconciliation results and present findings to management.
Continuously improve data reconciliation processes and procedures.
Develop and maintain complex spreadsheets using advanced Excel functions and formulas.
Automate repetitive tasks and processes using Visual Basic for Applications (VBA).
Analyze data trends and patterns, and present findings in a clear and actionable manner using Excel
Education:
Bachelor's or Master’s degree in business, finance, or another pre-professional field, or a discipline with exposure to accounting or corporate finance.
Experience Required:
3-5 years of experience
Expertise in Microsoft Excel, including advanced functions, pivot tables, and data analysis tools, VBA preferred.
General Requirements:
Detail oriented
Experience with asset management systems or other relational databases
Experience at a regional, national, or global financial services firm
Experience with VBA programming to automate tasks and enhance Excel functionalities. (preferred)
Ability to work independently as well as with “the team”
Good oral and written communication skills and digital literacy
Reporting Relationships
There is no set deadline to apply for this job opportunity. Applications will be accepted on an ongoing basis until the search is no longer active.