Data Engineer - Assistant Vice President
Summary
Builds and optimizes large-scale data pipelines, Data Lake/Warehouse infrastructure, and data models that power iCapital's fintech platform, partnering daily with Product, Engineering, Analytics, and business teams. Core stack: Python, SQL, Snowflake/Databricks, Airflow/Prefect/Dagster, dbt, AWS/GCP/Azure, Kafka/Spark, Terraform.
iCapital is seeking an exceptional Data Engineer to help scale the data foundations that power the business. This individual will design, build, and optimize the data pipelines and infrastructure that enable data to be a strategic asset across the organization. This role is highly collaborative and will partner with the Product, Engineering, Analytics teams and business stakeholders to quickly understand evolving challenges and deliver scalable, maintainable, and high‑quality solutions.
Data sits at the core of iCapital’s operations. The firm relies on clean, reliable, well‑structured data to drive decision‑making, enhance client experiences, and support a rapidly growing product suite. This individual will be responsible for moving and transforming data and developing a deep understanding of the business context behind it and help teams act on insights.
Responsibilities
- Develop and automate large scale, high-performance data platform pipelines and infrastructure to drive iCapital business growth and enable data-driven decision making.
- Design and develop reusable components and frameworks for ingestion, cleansing, and data quality.
- Streamline the ingestion of raw data from various sources into our Data Lake and Data Warehouse.
- Design data models for optimal storage and retrieval that represent the tangible business domains across iCapital’s ecosystem.
- Coordinate closely with the Operations, Sales, and Product Development teams daily to push iCapital’s FinTech strategy and improve the overall profitability of the business.
Qualifications
- 6-10 years of professional experience in a data engineering or data-driven software engineering role
- Exceptional Python and SQL skills
- Extensive experience with orchestration frameworks (Prefect, Airflow, Dagster, etc.)
- Deep understanding of OLAP (Snowflake, Databricks) and OLTP (PostgreSQL, MongoDB) databases and ELT frameworks (dbt, dlthub)
- Experience developing and deploying code to Cloud environments (AWS, GCP, Azure)
- Possess a strong grasp of object-oriented and functional programming and an ability to write easy-to-scale, high-quality code
- Experience leveraging stream processing frameworks (Kafka, Flink, Spark)
- Knowledge of infrastructure-as-code frameworks (terraform or cloud formation)
- Detail-oriented and able to multitask and work in a fast-paced environment
- Able to work independently while also being a strong team player
- Excellent written and verbal communication
- Passionate about learning and mastering cutting-edge technologies
- Professional experience with JVM based languages such as Scala, Java, and Kotlin is preferred
- Knowledge of financial markets and financial instruments is preferred
Benefits
The base salary range for this role is $100,000 to $135,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 Twitter: @icapitalnetwork | LinkedIn: | 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.
Skills
As published by greenhouse · 14 questions · 1 written answer
Basics
First Name, Last Name, Preferred First Name, Email, Phone, Resume/CV, Cover Letter, Location
Short answers (8)
- What is your LinkedIn profile URL? If applicable, please share the link. optional
- What is your personal website or online portfolio? If applicable, please share the link. optional
- What is your full legal name?
- What is your desired base salary expectation? Please specify the amount and currency.
- What is your desired total annual compensation when considering an equity award? Please specify the amount and currency.
- If "Employee Referral" was selected for "How did you hear about this job?" please type the full name of the referring employee. If not, please type in "N/A".
- Are you subject to any form of Garden Leave or a Non-Compete Agreement? If yes, please provide detail below.
- What is your desired bonus expectation? Please specify the amount and currency.
Pick from a list (5)
- Are you legally eligible to work in the country where this role is located?
- How did you hear about this job?
- Do you currently require any type of visa sponsorship for employment?
- Do you require any type of visa sponsorship for employment in the future (i.e. student visa transfer to H1B, etc)?
- iCapital is an office-first culture, as such all employees are required to work in the office Monday-Thursday, with the flexibility to work remotely on Friday, depending on the department. Please review the job description before applying, to identify the specified location/s for the role.
Written answers (1)
- What forms of deferred compensation do you currently have (e.g., unpaid or deferred bonus, equity, or other long‑term incentive plans)? Please provide as much detail as possible. If no form of deferred compensation exists, please input N/A for this question.