iCapital is building a centralized Data Lakehouse to combine scalable structured and semi-structured data, serving as the core of their Data & Analytics group. This initiative aims to create consistent, secure, scalable, and flexible data with data warehouse governance, supporting downstream data science, machine learning, BI, and CRM integrations.
Requirements
- Possesses a solid understanding of Agile development, object-oriented design, and programming languages
- Able to provide code examples of production ready code
- Experienced in Python, SQL
- Experience with modern cloud infrastructure is highly preferred
Responsibilities
- Working with data platform engineers on projects that apply cutting edge Data Warehouse solutions to business problems
- Implementing ETL and Modeling techniques in production and deploy to our cloud infrastructure
- Collaborate with various data engineers to understand the data flows, validations and testing
Other
- A rising junior or senior in a U.S. college/university bachelor’s degree program in related engineering or science fields
- Must be available to work the duration of the program from June 7th through August 8th to be eligible
- Committed to working five days a week in the New York City office for the entire duration of the internship
- Authorized to work in the United States*
- Highly inquisitive, collaborative, and a creative problem solver