Data Engineer / Analyst - Assistant Vice President

iCapital is powering the world’s alternative investment marketplace. Our financial technology platform has transformed how advisors, wealth management firms, asset managers, and banks evaluate and recommend bespoke public and private market strategies for their high-net-worth clients. iCapital services approximately $200 billion in global client assets invested in 1,634 funds, as of September 2024. 

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

Job Description

We are looking for a passionate Data Analyst to join out Data Platform team. The successful candidate will turn data into information, information into insight and insight into business decisions. Data is core and central part of iCapital. Data driven decisions are very critical for iCapital, as a result, we are looking for Data Analyst that will not only be able to use the data but also understand it and help make actionable decisions. Data Analyst quickly grasp complex and fluid business problems and be the bridge between the Data Engineers and Stake Holders. If you love using the latest technologies, working on creative software projects, and/or thinking about innovative new business plans in your spare time, read on.

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

How You Will Fulfill Your Potential

Data analyst responsibilities include conducting full lifecycle analysis to include requirements, activities and design. Data analysts will develop analysis and reporting capabilities. They will also monitor performance and quality control plans to identify improvements.

• Interpret, analyze and model the data from various data sources into Data Lakehouse.

• Develop and implement databases, data collection systems, data analytics and other strategies that optimize efficiency and quality

• Acquire data from primary or secondary data sources and maintain databases/data systems

• Identify, analyze, and interpret trends or patterns in complex data sets

• Filter and “clean” data by reviewing/comparing source data and performance indicators to locate and correct code problems

• Work with management to prioritize business and information needs

• Locate and define new process improvement opportunities

What We’re Looking For

• 6+ years of experience as a Data Analyst and Business Data Analyst

• Experienced in creating Business Requirement and Technical Design Documentation, in specific to ETL and Data Lakehouse Development

• Extensive SQL experience, such as writing complex queries across multiple tables, data analysis and profiling skills.

• Design efficient data modeling techniques to source data into Data Lakehouse to build strong reporting and data integrations.

• Experienced in suggesting Tactical and Strategic Data Solutions.

• Must have strong verbal and written communication skills to work with stakeholders to gather and formulate business requirements, and then translate to technical documentation

• Familiarity with OLAP (Redshift, Snowflake) and OLTP (PostgreSQL, MongoDB) databases.

• Familiarity with various database designs (Relational, Columnar, NoSQL)

• Some background in probability/statistics

• Detail-oriented, ability to multitask and work in a fast-paced environment

• Ability to work independently while also being a strong team player

• Passionate about cutting-edge technologies

Preferred Qualifications

• Master’s 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 and segmentation techniques

• Strong knowledge of reporting packages (Tableau etc) and experience with databases (SQL etc), programming (XML, Javascript, or ETL frameworks)

• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc)

• Strong Analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

• Adept at queries, report writing and presenting findings

• Good knowledge of financial markets and 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, 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 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.