Data Engineer - Vice President

iCapital Network; New York (NY); Hybrid; USD 160,000 - 200,000; Full time

Benefits offered by this job

Equity

Annual bonus

Comprehensive benefits

Job summary

iCapital Network is seeking an outstanding Data Engineer to join the Data and Analytics team to build scalable infrastructure that makes data a central part of the business and supports data-driven decisions. The role requires experience with open-source tech, Python/JVM languages, AWS, and diverse databases.

You will design data models, pipelines, and ingestion components for the data lake and data warehouse, and collaborate daily with product and sales to drive growth.

Qualifications

• Bachelor’s degree in computer science, data science, mathematics, statistics or related field.
• 8+ years of experience with open-source technologies or OO/FP programming, high-quality scalable code.
• Experience with Python/pandas or similar numeric frameworks.
• Familiar with OLAP/OLTP databases (Redshift, Snowflake, PostgreSQL, MongoDB).
• Experience with various DB designs (Relational, Columnar, NoSQL).
• Background in probability/statistics.
• Detail-oriented, able to multitask in a fast-paced environment.
• Independent worker and strong team player.
• Passionate about programming and modern tech.
• Master’s degree preferred in CS/DS or related field.
• Experience with Python and JVM languages (Scala/Java/Kotlin) preferred.
• Experience building data pipelines, data lakes, and data warehouses preferred.
• Knowledge of financial markets and instruments preferred.
• Experience with AWS (Lambda, S3, Kinesis, ElastiCache) preferred.
• Familiar with infra-as-code (Terraform/CloudFormation) preferred.
• Familiar with handling of PII data for analysis.
• Full-time or internship experience in financial tech is a plus.

Responsibilities

• Leverage open-source technologies and cloud solutions to build features.
• Develop and automate large-scale, high-performance data platform infrastructure.
• Design reusable ingestion, cleansing, and data quality components.
• Streamline ingestion of raw data into Data Lake and Data Warehouse.
• Design data models for optimal storage and retrieval.
• Collaborate daily with sales and product teams to push FinTech strategy and profitability.

Skills

Open-source technologies

Python

JVM languages

Data pipelines

Data lakes & warehouses

AWS

OLAP/OLTP databases

DB design: Relational/Columnar/NoSQL

Statistics/Probability

Independent yet team player

Cutting-edge tech

Education

Bachelor's degree in CS/Data Science/Math/Stats

Master's degree preferred

Tools

Redshift

Snowflake

PostgreSQL

MongoDB

Job description

We are looking for an outstanding Data Engineer to join the Data and Analytics team to help build the infrastructure to make data a central part of iCapital. Data driven decisions are very critical for iCapital, as a result, we are looking for engineers that will not only be able to use the data but also understand it and help make actionable decisions. The ideal candidate should be able to quickly grasp complex and fluid business problems and solve them with robust and creative analyses after having built highly-performant and highly scalable infrastructure to warehouse the data. If you love using the latest technologies, working on creative software projects, and/or thinking about innovative new business plans in your spare time, read on.

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 and enable data-driven organization.
• 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 the overall profitability of our business.

Qualifications

• Bachelor’s degree in computer science, Data Science, Mathematics, Statistics or other quantitative area or related field
• 8+ years of experience with open-source technologies or object-oriented/functional programming, strong ability to write easy-to-scale, high-quality code
• Experienced in at least 1 numeric research framework (python/pandas, R/Splus, Octave/Matlab)
• Familiar with OLAP (Redshift, Snowflake) and OLTP (PostgreSQL, MongoDB) databases.
• Familiar with various database designs (Relational, Columnar, NoSQL)
• Some background in probability/statistics
• Detail-oriented, ability to multitask and work in a fast-paced environment
• Able to work independently while also being a strong team player
• Passionate about programming and cutting-edge technologies
• Master’s degree in computer science, Data Science or related field is preferred
• Professional experience with Python and JVM based languages such as Scala, Java, and Kotlin is preferred
• Experience building data pipelines, data-lakes and data warehouses is preferred
• Good knowledge of financial markets and financial instruments is preferred
• Experience with AWS solutions such as Lambda, S3, Kinesis, ElastiCache is preferred
• Familiar with AWS and infrastructure-as-code (terraform or cloud formation) is preferred
• Familiar with the use and restrictions of PII data for analysis, research, development, and testing is preferred
• Full-time or internship experience as a data engineer in the financial technology industry is a plus

The base salary range for this role is $160,000 to $200,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.

iCapital is proud to be an Equal Employment Opportunity and Affiliation 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.

Miami, FL

New York, NY

Princeton, NJ

Salt Lake City, UT

Stamford, CT

This only applies to U.S. based roles.

iCapital uses AI-enabled technology to compare your application against our job requirements and to assist in our hiring process.