Analytics & Business Intelligence - Assistant Vice President

2 to 4 years of experience in an data-related role

Good knowledge of SQL (dbt experienced preferred)

Good knowledge of a business intelligence tool (e.g.

Tableau, Looker, PowerBI)

Some knowledge of Python, Microsoft Excel and intermediate statistics

Interest in learning data modeling, relational databases, normalization, OLAP stores

The base salary range for this role is $80,000 to $100,000 depending on level and experience.  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

Write SQL within dbt to extract, transform, validate, and aggregate data

Create Tableau dashboards for various business teams, charting key metrics and performing exploratory data analysis

Monitor and deploy data pipelines into our orchestration infrastructure using Prefect

Drive projects to completion by gathering business requirements, implementing technical solutions, following software best engineering practices, and finally presenting on results

Work closely with our engineering, product and business teams to form a thorough understanding of our industry and evolving data model

Convert data insights into concrete, action-oriented and phased execution plans that measurably grow various business metrics over time