Data Analytics Engineer - Analyst/Associate

iCapital is seeking an exceptional Data Analytics Engineer to help scale the data foundations that power their business. In this role, you will design, build, and optimize the data pipelines and infrastructure that enable data to be a strategic asset across the organization.

Responsibilities

• Develop and automate large scale, high-performance data platform pipelines and infrastructure to drive iCapital business growth and enable data-driven decision making
• 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 tangible business domains across iCapital’s ecosystem
• Coordinate closely with operations, sales, and product development teams daily to push iCapital’s FinTech strategy and improve the overall profitability of our business

Skills

• 1 - 3+ years of professional experience in a Data Engineering or data-driven Software Engineering role
• Exceptional Python and SQL skills
• Extensive experience with orchestration frameworks (Prefect, Airflow, Dagster, etc.)
• Deep understanding of OLAP (Snowflake, Databricks) / OLTP (PostgreSQL, MongoDB) databases and ELT frameworks (dbt, dlthub)
• Experience developing and deploying code to Cloud environments (AWS, GCP, Azure)
• Possess a strong grasp of object-oriented/functional programming and an ability to write easy-to-scale, high-quality code
• Experience leveraging stream processing frameworks (Kafka, Flink, Spark)
• In depth understanding of infrastructure-as-code frameworks (terraform or cloud formation)
• Detail-oriented, ability to multitask, and work in a fast-paced environment
• Ability to work independently while also being a strong team player
• Excellent written and verbal communication
• Passionate about learning and mastering cutting-edge technologies
• Professional experience with JVM based languages such as Scala, Java, and Kotlin
• Knowledge of financial markets and financial instruments

Benefits

• Equity for all full-time employees
• Annual performance bonus
• Employer matched retirement plan
• Generously subsidized healthcare with 100% employer paid dental
• Vision
• Telemedicine
• Virtual mental health counseling
• Parental leave
• Unlimited paid time off (PTO)

Company Overview