Data Migration Analyst

Client Delivery Specialist Associate

This role offers the opportunity to contribute directly to our mission by ensuring the accuracy and integrity of our financial data. This person will be a part of a dynamic team focused on innovation and efficiency, working with cutting-edge technology to streamline client onboarding and reporting.

Responsibilities

• Lead data conversion projects, including extracting, transforming, and loading (ETL) data between portfolio management systems. This involves understanding source system requirements, mapping data to new system standards, and managing the conversion of large datasets from legacy systems.
• Reconcile loaded data in source system against positions, tax lots, and performance.
• Integrate historical financial data by converting potentially complex and unstructured data files and statements into structured formats suitable for backfilling.
• Provide support for automated data feeds, troubleshooting issues and ensuring the seamless transformation of daily financial transactions and positions into source system imports. This requires a strong understanding of the automated data processing system.
• Respond to ad-hoc data requests from client-facing teams, providing timely and accurate information.

Qualifications

• 5 years in the financial industry, demonstrating a proven track record of financial product support, technical proficiency, and solid accounting knowledge
• Subject matter expert in Orion and Black Diamond
• Familiarity with other portfolio management systems, such as Addepar, Advyzon, APX, Axys, Ridgeline, Tamarac
• Strong background working with financial custodial data and proficiency supporting alternative financial instruments
• Advanced proficiency in Excel and text file manipulation. Familiarity with other data formats, such as JSON, XML, and unstructured-to-structured transformation is a plus
• Experience with at least one of the following: Python, SQL, Power Automate or other large data set software, demonstrating the ability to extract and transform data
• Demonstrated history of automating data-related processes such as data integration, including log file creation and maintenance
• Understanding of Salesforce, Monday.com , Jira, and GitLab
• Comfort working with a geographically dispersed team
• Strong interpersonal verbal and written communication skills and comfortable communicating with clients as needed
• Achievement of, or working towards, an MS/MBA or CFA