iCapital is powering the worlds alternative investment marketplace. Our financial technology platform has transformed how advisors, wealth management firms, asset managers, & banks evaluate & recommend bespoke public & private market strategies for their high-net-worth clients. iCapital services approximately $176 billion in global client assets invested in 1,433 funds, as of December 2023. 

iCapital has been named to the Forbes Fintech 50 for seven consecutive years (2018-2023); a three-time selection by Forbes to its list of Best Startup Employers (2021-2023); & a three-time winner of MMI/Barrons Solutions Provider award (See link below). 

About the Role 

iCapital is looking for a passionate Data Analyst to join out Data Platform team. The ideal candidate will turn data into information, information into insight, & insight into business decisions. Data is the core & central part of iCapital. Data driven decisions are very critical for iCapital, as a result, we are looking for Data Analyst that will be able to use the data and understand it to help make actionable decisions. This individual should quickly grasp complex & fluid business problems & be the bridge between the Data Engineers & Stake Holders.  

The individual should have experience in creating business requirements & technical design documentation, specifically for the development of ETL applications. This role requires extensive SQL experience, such as writing complex queries across multiple tables, & data analysis & profiling skills for the creation of design documentation & discussions with data modelers. The ideal candidate should also have strong verbal & written communication skills to work with stakeholders to gather & formulate business requirements, & then translate technical documentation. The candidate will also be comfortable supporting testing, & production accuracy after deployments. 

Responsibilities 

• Conduct full lifecycle analysis to include requirements, activities, & design.  
• Develop analysis & reporting capabilities as well as monitor performance & quality control plans to identify improvements. 
• Interpret, analyze, & model the data from various data sources into Data Lakehouse. 
• Develop & implement databases, data collection systems, data analytics & other strategies that optimize efficiency & quality. 
• Acquire data from primary or secondary data sources & maintain databases & data systems. 
• Identify, analyze, & interpret trends or patterns in complex data sets. 
• Filter & clean data by reviewing & comparing source data & performance indicators to locate & correct code problems. 
• Work with management to prioritize business & information needs. 

• Locate & define new process improvement opportunities. 

Qualifications 

• 6+ years of experience as a Data Analyst & Business Data Analyst 
• Experienced in creating Business Requirement & Technical Design Documentation, in specific to ETL & Data Lakehouse Development 
• Extensive SQL experience, such as writing complex queries across multiple tables, data analysis & profiling skills. 
• Design efficient data modeling techniques to source data into Data Lakehouse to build strong reporting & data integrations. 
• Experienced in suggesting Tactical & Strategic Data Solutions. 
• Must have strong verbal & written communication skills to work with stakeholders to gather & formulate business requirements, & then translate to technical documentation 
• Familiarity with OLAP (Redshift, Snowflake) & OLTP (PostgreSQL, MongoDB) databases. 
• Familiarity with various database designs (Relational, Columnar, NoSQL) 
• Some background in probability/statistics 
• Detail-oriented, ability to multitask & work in a fast-paced environment 
• Ability to work independently while also being a strong team player 
• Passionate about cutting-edge technologies 

Preferred Qualifications 

• Masters in computer science, data science or related field 
• Proven working experience as a Data Analyst or Business Data Analyst 
• Technical Expertise regarding data models, database design development, data mining & segmentation techniques 
• Strong knowledge of reporting packages (Tableau etc.) & experience with databases (SQL etc.), programming (XML, Javascript, or ETL frameworks) 

• Knowledge of statistics & experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc.) 
• Strong analytical skills with the ability to collect, organize, analyze, & disseminate significant amounts of information with attention to detail & accuracy 
• Adept at queries, report writing & presenting findings 
• Good knowledge of financial markets & financial instruments 

Benefits 

The base salary range for this role is $120,000 to $160,000. iCapital offers a compensation package which includes salary, equity for all full-time employees, & 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, & virtual mental health counseling, parental leave, & unlimited paid time off (PTO). 

We believe the best ideas & innovation happen when we are together. We offer most employees the flexibility to work in the office three or four days. Every department has different needs, & some positions will be designated in-office jobs, based on their function. 

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 & 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.