ternal teams. This individual will support business critical processes from portfolio management system conversions to performance reconciliation.
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.
- 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
- 2-5+ years in the financial industry, demonstrating a proven track record of financial product support, technical proficiency, and solid accounting knowledge
- Expertise with Addepar and familiarity with other portfolio management systems, such as Advyzon, APX, Axys, Black Diamond, Orion, 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, CFA, CAIA, or CFP is a plus
- Strong background working with financial custodial data and proficiency supporting alternative financial instruments
- Exposure to financial data conversion from various file format and/or portfolio management systems and demonstrated data transformation using an ETL tool is a strong plus.
Benefits
The base salary for this role is $75,000 to $85,000. iCapital offers a compensation package which includes salary, equity for all full-time employees, and an annual performance bonus. Employees also receive a comprehensive benefits package that includes an employer matched retirement plan, generously subsidized healthcare with 100% employer paid dental, vision, telemedicine, and virtual mental health counseling, parental leave, and unlimited paid time off (PTO).
We believe the best ideas and innovation happen when we are together. Employees in this role will work in the office Monday-Thursday, with the flexibility to work remotely on Friday.
For additional information on iCapital, please visit https://www.icapitalnetwork.com/about-us Twitter: @icapitalnetwork | LinkedIn: https://www.linkedin.com/company/icapital-network-inc | Awards Disclaimer: https://www.icapitalnetwork.com/about-us/recognition/
iCapital is proud to be an Equal Employment Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.