Client Delivery Specialist, Automation - Associate

iCapital

Stamford (CT)

Hybrid

USD 75,000 - 85,000

Full time

43 hours ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Salary + equity

Annual bonus

Retirement plan

Healthcare

Dental coverage

Vision coverage

Telemedicine

Mental health counseling

Parental leave

Unlimited PTO

Remote Fridays

Job summary

You will lead data conversion projects, integrate historical data, support automated data feeds, and respond to ad-hoc data requests, working with cutting-edge technology on a dispersed,

Qualifications

2–5+ years in the financial industry with proven financial product support and technical proficiency.
Experience with Addepar and familiarity with other portfolio management systems (Advyzon, APX, Axys, Black Diamond, Orion, Ridgeline, Tamarac).
Strong Excel skills and ability to manipulate text files; familiarity with JSON/XML is a plus.
Experience with Python, SQL, Power Automate or other large data set software for data extraction and transformation.
Proven history of automating data-related processes, including log file creation and maintenance.
Good communication skills and ability to interact with clients and dispersed teams.
MS/MBA, CFA, CAIA, or CFP is a plus.

Responsibilities

Lead data conversion projects, including ETL between portfolio management systems and mapping data to new standards.
Integrate historical financial data by converting unstructured data into structured formats.
Provide support for automated data feeds and troubleshoot issues in daily transactions and positions imports.
Respond to ad-hoc data requests from client-facing teams with timely, accurate information.

Skills

Excel

Python

SQL

Power Automate

JSON

XML

Education

Bachelor's degree in finance, CS, statistics, mathematics, data science or similar

Tools

Addepar

Advyzon

APX

Axys

Black Diamond

Orion

Ridgeline

Tamarac

Job description

About The Role

iCapital is seeking a Client Delivery Specialist Associate to join the Automation team within the Data Solution department. This role will ensure a seamless flow of financial data for iCapital’s clients and internal 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

Bachelor's degree with a concentration in finance, computer science, statistics, mathematics, data science, or a similar field
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

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,

Get your free, confidential resume review.

or drag and drop your file here.