Reference Data Engineer

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 $148 billion in global client assets invested in 1,155 funds, as of September 2022.

iCapital has been named to the Forbes Fintech 50 for five consecutive years (2018 – 2022); a back-to-back selection by Forbes to its list of Best Startup Employers; and a two-time winner of MMI/Barron’s Solutions Provider award (See link below).

About the Role  

iCapital is looking to hire a Data Engineer to join the Reference Data and Analytics team. We are a result-driven team of difference makers and problem solvers who build the infrastructure to make Reference Data the lifeblood of iCapital’s analytics frameworks. As a data engineer, your job is to build and support one of the most active and complex services within the company, with millions of requests per day. Data Engineers should quickly grasp complex and fluid business problems and solve them with robust and creative analyses after having built highly performant and highly scalable infrastructure to warehouse the data. The ideal candidate should enjoy discovering and using the latest technologies, working on creative software projects, and/or thinking about innovative new business plans.  

Responsibilities  

• Leverage open-source technologies and cloud solutions to build elegant features for iCapital Platform.   
• Develop and automate large scale, high-performance data platform infrastructure to drive iCapital business growth, and enable data-driven organization.  
• Design and develop reusable components and frameworks for ingestion, cleansing, and data quality.  
• Streamline the ingestion of raw data from various sources into our Data Lake and Data Warehouse.  
• Design data models for optimal storage and retrieval that represent the product entities and meet business requirements.  
• Build cloud-native microservices to support internal business units. 
• Coordinate closely with sales and product development teams daily to push iCapital’s FinTech strategy and improve the overall profitability of the business.  

 Qualifications  

• Bachelor’s Degree in Computer Science, Engineering, Mathematics, or other technical area or related field  
• 5-8+ years of experience with open-source technologies or object-oriented or functional programming, able to write easy-to-scale, high-quality code. 
• Experienced in at least 1 numeric research framework (python/pandas, R/Splus, Octave/Matlab)  
• Familiar with OLAP (Redshift, Snowflake) and OLTP (PostgreSQL, MongoDB) databases. 
• Familiar with message broker technologies (Kafka, AWS Kinesis, EventBridge). 
• Familiar with various database designs (Relational, Columnar, NoSQL)  
• Experienced in web-based application development. 
• Detail-oriented, able to multitask, and work in a fast-paced environment.  
• Able to work independently while also being a strong team player. 
• Excellent written and verbal communication. 
• Passionate about programming and cutting-edge technologies  
• Master’s in Computer Science, Engineering, or related field. 
• Professional experience with Python and JVM based languages such as Scala, Java, and Kotlin. 
• Experience building data-pipelines, data-lakes, and data warehouses. 
• Good knowledge of financial markets and financial instruments  
• Experience with AWS solutions such as Lambda, S3, Kinesis, ElastiCache  
• Familiar with AWS and infrastructure-as-code (terraform or cloud formation)  
• Familiar with the use and restrictions of PII data for analysis, research, development, and testing. 
• Full-time or internship experience as a data engineer in the financial technology industry is a plus. 

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. We offer most employees the flexibility to work in the office three or four days. Every department has different needs, and 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 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.