Data Engineer - Assistant Vice President

About the role

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, developing a deep understanding of the business context behind it, and helping 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 CloudFormation).
• 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

• Comprehensive benefits package including 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).
• Equity for all full-time employees and an annual performance bonus.

Pay

The base salary range for this role is $100,000 to $135,000.

Schedule

Employees in this role will work in the office Monday-Thursday, with the flexibility to work remotely on Friday.