Salesforce Data Engineer - Assistant Vice President
iCapital
- New York City, NY
- $120,000-140,000 per year
- Training
- Full-time
- Leverage open-source technologies and cloud solutions to build elegant features that iCapital platform users love.
- 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.
- Design and develop in Salesforce and Apex to automate processes and meet a variety of business needs.
- Coordinate closely with sales and product development teams daily to push iCapital's FinTech strategy and improve the overall profitability of our business.
- Bachelor's degree in computer science, data science, mathematics, statistics or other quantitative area or related field
- 1-4 years of experience with open-source technologies or object-oriented/functional programming, strong ability to write easy-to-scale, and high-quality code
- Experience in at least one numeric research framework (python/pandas, R/Splus, Octave/Matlab)
- Familiar with OLAP (Redshift, Snowflake) and OLTP (PostgreSQL, MongoDB) databases
- Familiar with various database designs (Relational, Columnar, NoSQL)
- Experience with Salesforce development, Apex, and working with Apex classes, batching, bulk processing, triggers, events and event buses, and writing test classes
- Experience using probability/statistics
- 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 skills
- Passionate about programming and cutting-edge technologies
- Master's in computer science, data science, or related field is preferred
- Professional experience with Python and JVM based languages such as Scala, Java, and Kotlin is preferred
- Experience building data-pipelines, data-lakes and data warehouses is preferred
- Good knowledge of financial markets and financial instruments is preferred
- Experience with AWS solutions such as Lambda, S3, Kinesis, ElastiCache is preferred
- Familiar with AWS and infrastructure-as-code (terraform or cloud formation) is preferred
- Experience with Salesforce and Apex development in processing large data sets is preferred
- Familiar with the use and restrictions of PII data for analysis, research, development, and testing is preferred
- Full-time or internship experience as a data engineer in the financial technology industry is a plus