Data Engineer - Assistant Vice President

Icapitalnetwork; Salt Lake City (UT); Hybrid; USD 100,000 - 135,000; Full time

Benefits offered by this job

Equity for all full-time employees

Comprehensive benefits package

Employer matched retirement plan

Unlimited paid time off (PTO)

Job summary

iCapital is looking for an exceptional Data Engineer in Salt Lake City, Utah, to design and optimize data pipelines that empower business growth. This collaborative role will work closely with Product, Engineering, and Analytics teams to enhance decision-making processes with reliable data.

The ideal candidate will have 6-10 years of experience, exceptional Python and SQL skills, and the ability to work independently and as part of a team. iCapital offers a competitive salary and comprehensive benefits including remote flexibility.

Qualifications

• 6-10 years of professional experience in data engineering or related software engineering.
• Proficient in Python and SQL.
• Experience with orchestration frameworks like Prefect, Airflow.
• Knowledge of OLAP and OLTP databases.
• Experience in cloud environments such as AWS or GCP.
• Detail-oriented and multitasking in a fast-paced environment.
• Excellent communication skills.

Responsibilities

• Develop large scale data platform pipelines to drive business growth.
• Automate data infrastructure for decision making.
• Design data models for optimal storage and retrieval.
• Coordinate with Operations and Sales teams.

Skills

Python

SQL

OLAP databases

OLTP databases

Cloud environments

Object-oriented programming

Functional programming

Stream processing frameworks

Infrastructure-as-code frameworks

Tools

Prefect

Airflow

Snowflake

PostgreSQL

AWS

Kafka

Terraform

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 pipelinesand 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’secosystem.


• Coordinate closely with the Operations, Sales, and Product Development teams daily to push iCapital’sFinTech 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).

Employees in this role will work in the office Monday-Thursday, with the flexibility to work remotely on Friday.

Equal Employment Opportunity

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