Data Migration Specialist - FundCount

Overview

FundCount is a growing international fintech company with a 20-year history and a global office and staff footprint. We provide a unified software solution for investment, general, and partnership accounting and analysis. Our product delivers operational efficiency and insight to investment management professionals — family offices, fund administrators, and alternative fund managers. The Data Migration Specialist (DMS) is a member of the Implementation team, responsible for transitioning the data required to build an operational database in FundCount . The Implementation team handles the efficient and accurate onboarding of new FundCount clients and their training. Our clients are single- and multi-family offices, fund administrators, and hedge funds who hold a wide range of public and private securities and general ledger transactions. The DMS plays a critical role in ensuring historical data is transferred efficiently and reconciled with official records.

Our Product

All portfolio and partnership accounting activity in FundCount is aggregated within one software system and flows through a single general ledger. Investment information is consolidated, accurate, and instantly available, providing the insight and foundation needed for in-depth analysis that drives decision-making. Our clients are single- and multi-family offices, fund administrators, private equity firms, and hedge funds.

Responsibilities

• Apply expert Excel and related database programming/management skills to export and organize data from legacy systems for import into FundCount .
• Perform data validation tests to understand and improve data quality.
• Document data flow through legacy system antecedents and other databases.
• Perform quantitative and qualitative analysis where necessary in recommending process improvements.
• Assist in the creation of new — and the maintenance of existing — data import and export interfaces between FundCount and 3rd-party systems and services.
• Develop Excel-based macros and scripts to automate data collection, analysis, and reporting.
• Build validation and reconciliation reports and dashboards to confirm migrated data ties out to official records.
• Work on multiple data migration implementation projects simultaneously.
• Interface with internal staff to implement data migration tasks.
• Manage data migration testing and reporting.
• Help identify design and interface process improvements.
• Create systems integration documentation.
• Submit the results of work into the Jira tracking system, properly describing and organizing each task according to the company’s established workflow.

Technical Skills

The core technical toolkit for this role spans spreadsheet automation, business intelligence, data querying, and scripting. Strong candidates