Data Transformation & Operations Associate

iCapital; Salt Lake City (UT); Ibrido; USD 70.000 - 85.000; Tempo pieno

Vantaggi offerti da questo lavoro

Equity for all full-time employees

Annual performance bonus

Employer matched retirement plan

Comprehensive health, dental, vision

Unlimited PTO

Descrizione del lavoro

iCapital is seeking an Associate for Strategic Transformation, Data Operations to own root-cause investigations of production data issues and contribute to ETL pipeline development. You will serve as the liaison between Fund Finance operations and engineering, define requirements, and drive data quality initiatives.

The role sits within an embedded data function that partners with Fund Operations, Technology, and Product teams to resolve data quality issues, build ETL pipelines, and deliver

Competenze

• 2+ years of experience in a business analyst, data support, or application support role within financial services.
• Bachelor’s degree or higher in computer science, business analytics, business administration, finance, or a related field.
• Proficiency in SQL for data analysis, investigation, and root-cause diagnostics.
• Strong relationship management skills with the ability to build partnerships and work effectively across internal teams, fund administrators, vendors, and other external stakeholders.
• Proven ability to balance multiple projects, priorities, and stakeholder conversations across different teams and business functions.
• Proven ability to perform structured root-cause analysis and coordinate with engineers through investigation and resolution.
• Strong analytical and problem-solving skills, with the ability to translate complex data issues into clear business language.
• Excellent communication and stakeholder management skills and comfortable working across technical and non-technical audiences.
• Experience with private equity, hedge fund, or alternative investment operations and data.
• Familiar with ETL pipeline concepts, data ingestion patterns, or workflow automation.
• Experience writing Jira tickets or structured requirement documents for engineering teams.
• Exposure to AI-assisted tooling or automation frameworks and Python are a plus.

Mansioni

• Perform root-cause analysis of production data issues using SQL, working cross-functionally with engineering and operations teams to drive resolution.
• Support and contribute to ETL pipeline development, collaborating closely with Product managers and engineers throughout the development lifecycle.
• Serve as the primary liaison between fund administrators, business groups, and technology teams to manage and resolve data exceptions and discrepancies.
• Develop exception management tooling to strengthen data quality controls and produce metrics and dashboards that help stakeholders prioritize issue resolution.
• Define clear business and technical requirement documents for engineering teams addressing new features or existing issues.
• Build an in-depth understanding of end-to-end organizational data flows and their downstream impact on Fund Finance business processes.
• Write test cases and perform UAT to ensure issues are identified and addressed before production deployment.
• Identify and contribute to automation initiatives that reduce manual intervention in recurring data workflows, including reconciliation, ingestion monitoring, and exception handling.
• Formalize operational knowledge into structured documentation, enabling the team to scale independently of individual expertise.
• Own the end-to-end delivery of data initiatives supporting Fund Finance, Transactional Operations, and Investor Relations workflows, partnering with Product Managers and internal stakeholders to define scope, gather business requirements, translate needs into technical solutions, and drive implementation for both existing workflows and new product features
• Serve as a subject matter expert on data workflows and platform functionality, independently advising internal teams on data dependencies, product functionality, and operational impacts

Conoscenze

SQL proficiency

Stakeholder management

Analytical thinking

Cross-functional work

Root-cause analysis

Communication skills

Prioritization

Problem-solving

Python

AI tooling familiarity

Formazione

Bachelor's degree

Strumenti

Jira

ETL tooling

Data visualization tools

Python

Descrizione del lavoro

iCapital is seeking an Associate for Strategic Transformation, Data Operations to own root-cause investigations of production data issues and contribute to ETL pipeline development. You will serve as the liaison between Fund Finance operations and engineering, define requirements, and drive data quality initiatives.

The role sits within an embedded data function that partners with Fund Operations, Technology, and Product teams to resolve data quality issues, build ETL pipelines, and deliver