VP of Data Engineering: Scalable Platform & Insights

iCapital; New York (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

iCapital is seeking an outstanding Data Engineer to join the Data and Analytics team in New York. You will help build infrastructure to make data central to the business, enabling data-driven decisions with highly scalable data warehouses and data lakes.

The ideal candidate has 8+ years in open-source tech and programming, with experience in Python, JVM languages, AWS, and data pipeline design. This role requires collaboration with sales and product teams and a strong analytical mindset.

Qualifications

• 8+ years of experience with open-source technologies or object-oriented/functional programming.
• Strong ability to write easy-to-scale, high-quality code.
• Experience with Python/pandas, R/Splus, Octave/Matlab.
• Familiar with OLAP (Redshift, Snowflake) and OLTP (PostgreSQL, MongoDB) databases.
• Familiar with Relational, Columnar and NoSQL database designs.
• Some background in probability/statistics.
• Detail-oriented, multitasker in a fast-paced environment.
• Independent worker and strong team contributor.
• Excellent written and verbal communication.
• Passionate about programming and cutting-edge technologies.
• Professional experience with Python and JVM languages (Scala/Java/Kotlin).
• Experience building data pipelines, data-lakes and data warehouses.
• Good knowledge of financial markets and instruments.
• Experience with AWS (Lambda, S3, Kinesis, ElastiCache).
• Familiar with infrastructure-as-code (Terraform or CloudFormation).
• Familiar with handling PII data for analysis.

Responsibilities

• Leverage open-source technologies and cloud solutions to build elegant features.
• Develop and automate large scale, high-performance data platform infrastructure to drive iCapital business growth.
• 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 product entities and meet business requirements.
• Coordinate closely with sales and product development teams daily to push iCapital’s FinTech strategy and improve profitability.

Skills

Python

Scala

Java

Kotlin

Data pipelines

Data lakes

Data warehouses

AWS

Terraform

CloudFormation

PII data handling

Open-source technologies

Team player

Communication

Education

Bachelor's degree in CS/DS/Math/Statistics

Master's degree preferred

Tools

PostgreSQL

MongoDB

Redshift

Snowflake

ETL

Job description

iCapital is seeking an outstanding Data Engineer to join the Data and Analytics team in New York. You will help build infrastructure to make data central to the business, enabling data-driven decisions with highly scalable data warehouses and data lakes.

The ideal candidate has 8+ years in open-source tech and programming, with experience in Python, JVM languages, AWS, and data pipeline design. This role requires collaboration with sales and product teams and a strong analytical mindset.