Data Feed Operations - Associate

iCapital; Stamford (CT); Hybrid; USD 75,000 - 85,000; Full time

Benefits offered by this job

Equity

Annual bonus

Retirement plan

Healthcare

Dental

Vision

Telemedicine

Mental health support

Parental leave

Unlimited PTO

Job summary

iCapital is seeking a detail-oriented Associate for the Data Feed Operations team within Data Solutions. The role sits at the intersection of investment operations, data analysis, and technical data management, supporting the quality and reliability of post-trade investment data.

You will monitor data feeds, reconcile investment data, and use SQL/Python to maintain data integrity, while collaborating with technical and business teams in a fast-moving fintech environment.

Qualifications

• 3–5 years in data operations or related field
• Advanced SQL skills with relational databases, Snowflake or PostgreSQL
• Experience with APIs, file-based integrations, ETL/ELT
• Experience monitoring data feeds, reconciling data, mapping documentation
• Experience with investment data, positions, valuations, capital activity
• Knowledge of alternative investments/wealth management
• Python for data analysis, validation, automation
• Data migrations or validation in production environments
• Strong analytical and problem-solving skills
• Excellent attention to detail and multitasking abilities
• Strong communication across business and technical teams

Responsibilities

• Monitor inbound/outbound data feeds, APIs, and file-based integrations
• Reconcile investment data across source systems and outputs
• Investigate data-quality exceptions and coordinate remediation
• Certify completeness/accuracy of reporting data before publication
• Use SQL to analyze relational data and trace data lineage
• Develop controls and automation to reduce manual analysis
• Document feed specifications, mappings, and business rules
• Translate issues into actionable requirements for Product/Engineering
• Participate in testing/certification for feeds and migrations
• Provide status updates on feed health and data quality
• Track operational measures like timeliness, delivery success, and certification status

Skills

SQL

Python

Relational databases

APIs

ETL/ELT

Snowflake

PostgreSQL

Data reconciliation

Data quality

Problem solving

Communication

Tools

Snowflake

PostgreSQL

Job description

iCapital is seeking a detail-oriented and technically capable Associate to join the Data Feed Operations team within Data Solutions. This role sits at the intersection of investment operations, data analysis, and technical data management, with a focus on supporting the quality and reliability of post-trade investment data. This hands-on, highly collaborative role partners across technical and business teams to solve complex data challenges and support scalable data operations within a fast-moving financial technology environment.

Responsibilities

• Monitor inbound and outbound data feeds, APIs, file-based integrations, processing results, validations, deliveries, and service exceptions.
• Reconcile investment positions, transactions, valuations, cash activity, and related reporting data across source systems and downstream outputs.
• Investigate data-quality exceptions and feed breaks, determine root cause, document findings, and coordinate remediation with internal and external partners.
• Certify the completeness and accuracy of reporting data before publication, migration acceptance, or client and partner delivery.
• Use SQL to analyze relational data, validate populations, trace lineage, identify anomalies, and produce repeatable reconciliation evidence.
• Use analytical and automation tools to develop controls, transform and compare data sets, reduce manual analysis, and support scalable monitoring and reconciliation workflows.
• Document feed specifications, source-to-target mappings, business rules, procedures, controls, issue histories, and certification evidence.
• Translate operational issues and recurring break patterns into actionable requirements for the Product and Engineering teams.
• Participate in testing and certification for new feeds, feed changes and platform migrations.
• Provide clear status updates and respond to client, partner, and internal stakeholder questions regarding feed health, data quality, and issue resolution.
• Help define and track operational measures such as feed timeliness, successful delivery, break recurrence, resolution time, certification status, and data adoption.

Qualifications

• 3-5 years of relevant experience in data operations, investment operations, data analysis, financial technology, performance reporting, fund administration, or in a related field
• Advanced SQL skills and experience analyzing data in relational databases, including cloud data platforms such as Snowflake or PostgreSQL
• Experience working with APIs, file-based integrations, external data-provider workflows, ETL or ELT processes, data pipelines, or orchestration workflows
• Experience monitoring data feeds, investigating exceptions, reconciling data, and documenting mappings or business rules
• Experience with investment positions, transactions, valuations, capital activity, partner capital account data, or general-ledger data
• Working knowledge of alternative investments, private markets, wealth management, investment performance reporting, or fund accounting
• Python experience for data analysis, validation, automation, or reconciliation
• Experience supporting data migrations, source-system conversions, or implementation testing in a controlled production environment
• Strong analytical judgment and a structured approach to root-cause analysis and problem solving
• Excellent attention to detail, with the ability to manage multiple priorities in a fast-paced environment
• Strong written and verbal communication skills, with the ability to work effectively across business and technical teams, take ownership of issues through resolution, and contribute as a collaborative team member

The base salary range 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.

iCapital is proud to be an Equal Employment Opportunity and Aff

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.

iCapital Voluntary Self-Identification Questions [U.S. Only]

Candidates are invited to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in iCapital Network ’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, and you voluntarily decide to complete this survey, please indicate by making the appropriate selection. We request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake. Classification of protected categories is as follows:

Voluntary Self-Identification of Disability

Why are you being asked to complete this?

The law requires us to provide equal employment opportunity to qualified people with disabilities. We request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake.

Completing this form is voluntary. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability.Disabilities include, but are not limited to:

• Alcohol or other substance use disorder (not currently using drugs illegally)
• Blind or low vision
• Cancer (past or present)
• Cardiovascular or heart disease
• Celiac disease
• Cerebral palsy
• Deaf or serious difficulty hearing
• Diabetes
• Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
• Epilepsy or other seizure disorder
• Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
• Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
• Missing limbs or partially missing limbs
• Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
• Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
• Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
• Partial or complete paralysis (any cause)
• Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema

This survey should take about 5 minutes to complete.

Voluntary Self-Identification: What is your Gender? Select...

Voluntary Self-Identification: Are you Hispanic / Latino? Select...

Voluntary Self-Identification: Please identify your race if not Hispanic / Latino Select...

Voluntary Self-Identification: What is your veteran status? Select...

Voluntary Self-Identification: What is your disability status? Select...

iCapital uses AI-enabled technology to compare your application against our job requirements and to assist in our hiring process.