Data Engineer - Assistant Vice President

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.
• Cook up close 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.