Data Engineer - Assistant Vice President

iCapital; Salt Lake City (UT); Ibrido; USD 100.000 - 135.000; Tempo pieno

Vantaggi offerti da questo lavoro

Equity

Annual bonus

Health coverage

Retirement plan

Unlimited PTO

Parental leave

Hybrid work model

Descrizione del lavoro

iCapital is seeking an exceptional Data Engineer to scale the data foundations that power the business. This role will design, build, and optimize the data pipelines and infrastructure that enable data to be a strategic asset across the organization.

Data sits at the core of iCapital’s operations. You will move and transform data and develop a deep understanding of the business context to help teams act on insights.

Competenze

• 6–10 years of data engineering or data-driven software experience.
• Exceptional Python and SQL skills.
• Experience with orchestration frameworks (Prefect, Airflow, Dagster).
• Deep understanding of OLAP (Snowflake, Databricks) and OLTP (PostgreSQL, MongoDB).
• Experience deploying code to AWS, GCP or Azure.
• Strong OO/functional programming and scalable code writing.
• Experience with Kafka, Flink or Spark.
• Knowledge of IaC (Terraform or CloudFormation).
• Detail-oriented, able to multitask in a fast-paced environment.
• Independent worker and strong team player with excellent communication.

Mansioni

• Develop and automate large scale, high-performance data pipelines and infrastructure.
• Design reusable ingestion, cleansing, and data quality components.
• Streamline ingestion from sources into Data Lake and Data Warehouse.
• Design data models for optimal storage and retrieval across ecosystems.
• Collaborate daily with Operations, Sales, and Product teams to advance data strategy.

Conoscenze

Python

SQL

Data modeling

ETL/ELT

Data warehousing

English communication

Strumenti

Snowflake

Databricks

PostgreSQL

MongoDB

dbt

Prefect

Airflow

Dagster

Terraform

CloudFormation

Kafka

Flink

Spark

AWS

GCP

Azure

Descrizione del lavoro

• Excellent written and verbal communication

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: @icapitalnetwork | LinkedIn: https://www.linkedin.com/company/icapital-network-inc | Awards Disclaimer: https://www.icapitalnetwork.com/about-us/recognition/

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