Data Analytics, Fund Finance - Assistant Vice President

This position does not offer visa sponsorship now or in the future. About the Role iCapital is looking to hire a Data Scientist, Analytics Engineer at the Assistant Vice President level to drive measurable impact across the Corporate Finance and Fund Finance teams. This role involves defining and calculating KPIs, transforming raw source data into processed business data, creating live dashboards to monitor performance, identifying driver metrics and statistical correlations, and finally working with Business teams to implement data insights. This individual will sit in the Analytics group of the broader Data and Analytics team and will work closely with our Data Engineering and Data Science teams. On the technical side, this role will interface with the data stack of Airbyte, Snowflake, dbt, Prefect, Python and Tableau. The ideal candidate will be highly proficient in technical tooling, understand complex business problems, interface with senior stakeholders, develop execution plans, and present on their work. Responsibilities 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 the orchestration infrastructure using Prefect. Drive projects to completion by gathering business requirements, implementing technical solutions, following software best engineering practices, and presenting results. Partner with the Corporate Finance and Fund Finance teams to improve management visibility, drive operational efficiency, and support workflow automation. Convert data insights into concrete, action-oriented and phased execution plans that measurably grow various business metrics over time. Qualifications Bachelor’s degree or advanced degree in computer science, economics, mathematics, statistics or a related technical field 6-10 years of experience in a data-related role Excellent writing, communication and presentation skills Exceptional SQL skills, dbt experience is preferred Strong experience using business intelligence tools such as Tableau or Power BI Working knowledge of Python and Microsoft Excel, with familiarity in applied and intermediate statistics Strong data modeling skills, including designing and maintaining analytical data structures Interest in learning data governance principles, data stewardship, traceability, and lineage Prior experience with end-to-end project delivery (i.e. requirements gathering, scoping, working within large organizations, presenting on project plans and results) Detail-oriented, naturally curious and willing to question the status quo to understand business needs Prior experience in business analyst or project management is preferred Prior experience in the financial services and alternative investments industry 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 Affirmative Action employer. We do not discriminate based upon race, religion, color, national or ... (truncated, view full listing at source)