Data Analyst, iCapital
Assistant Vice President
$120-160k
+ Equity and bonus
3-4 days a week in office
Fintech platform for alternative investments
Job no longer available
Fintech platform for alternative investments
1001+ employees
Job no longer available
$120-160k
+ Equity and bonus
3-4 days a week in office
1001+ employees
Company mission
To power the world’s alternative investment marketplace.
Role
Who you are
- ICapital is looking for a passionate Data Analyst to join out Data Platform team
- We are looking for Data Analyst that will be able to use the data and understand it to help make actionable decisions
- The individual should have experience in creating business requirements 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 technical documentation
- The candidate will also be comfortable supporting testing, and production accuracy after deployments
- 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
Desirable
- 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
What the job involves
- The ideal candidate will turn data into information, information into insight, and insight into business decisions
- This individual should quickly grasp complex and fluid business problems and be the bridge between the Data Engineers and Stake Holders
- Conduct full lifecycle analysis to include requirements, activities, and design
- Develop analysis and reporting capabilities as well as 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 and data systems
- Identify, analyze, and interpret trends or patterns in complex data sets
- Filter and “clean” data by reviewing and 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
Otta's take
Xav Kearney
CTO of Otta
Alternative investing can yield huge profits, but it can often be inaccessible, even to enterprises. iCapital solves this problem by guiding large-scale businesses through the alternative investing process.
Since launching in 2013, iCapital has provided enterprises with an investing marketplace. Its focus has been on banking, wealth management, and asset management companies, and iCapital now serves clients such as JP Morgan, Evercore, and Rockefeller. As of February 2023, the company services over $153 billion in global client assets, clear evidence of industry confidence in the company.
iCapital's impact on the financial world is undeniable, forging strong and profitable partnerships with leading institutions like Morgan Stanley. With a proven track record and a rapidly growing platform, iCapital is poised for significant further expansion in the years to come.
Insights
Some candidates hear
back within 2 weeks
42% employee growth in 12 months
Company
Funding (last 2 of 8 rounds)
Dec 2021
$50m
LATE VC
Jul 2021
$440m
GROWTH EQUITY VC
Total funding: $680.6m
Company HQ
Murray Hill, New York, NY
Founders
Lawrence Calcano
(CEO)Previously worked as Director of Capitol Acquisition Corp., and served as Director of Vibrant Emotional Health for 10 years.
Salary benchmarks
We don't have enough data yet to provide salary benchmarks for this role.
Submit your salary to help other candidates with crowdsourced salary estimates.
Diversity & Inclusion at iCapital
- We consider applicants of all backgrounds. If you are excited about what we’re building but don't meet some of the criteria above, please don’t let that discourage you from applying
Share this job