Data Engineer - Assistant Vice President

iCapital

$100K — $135K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 6-10 years in data engineering or data-driven software engineering
  • Strong Python and SQL expertise
  • Experience with orchestration frameworks (Prefect, Airflow, Dagster)
  • Knowledge of OLAP/OLTP databases and ELT frameworks (dbt, dlthub)
  • Proficient in Cloud deployments (AWS, GCP, Azure)
  • Familiar with stream processing frameworks (Kafka, Flink, Spark)
  • Preferred knowledge of financial markets and instruments

Responsibilities

  • Develop and automate high-performance data platform pipelines
  • Design and create reusable components for data ingestion and quality
  • Streamline raw data ingestion to Data Lake and Data Warehouse
  • Create data models for optimal storage and retrieval
  • Coordinate with Operations, Sales, and Product Development teams

Benefits

  • Equity for all full-time employees
  • Annual performance bonus
  • Employer matched retirement plan
  • Generously subsidized healthcare
  • 100% employer paid dental, vision, telemedicine, and virtual mental health counseling
  • Parental leave
  • Unlimited paid time off (PTO)
  • In-office work Monday-Thursday with remote flexibility on Fridays
Full Job Description
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 https://www.icapitalnetwork.com/about-us Twitter: [redacted] | LinkedIn: https://www.linkedin.com/company/icapital-network-inc | Awards Disclaimer: https://www.icapitalnetwork.com/about-us/recognition/

Similar Jobs

More Jobs at iCapital

More Information Technology Jobs

Find similar Data Engineer - Assistant Vice President jobs: