CAIS is a fintech firm on a mission to build the first truly open marketplace for alternative investments, where financial advisors and asset managers can engage and transact directly on a massive scale. We are a rapidly growing, high-energy, and collaborative group looking for people with great attitudes, grit, and creative problem-solving skills. Join us in disrupting a multi-trillion-dollar industry.

We are seeking a full time Data Engineer to join our Technology team. This role will report to our SVP of Data and will be responsible for developing and maintaining the infrastructure that makes data a central part of CAIS. The Data Engineer will collaborate with analytics and product teams to improve data models that feed business intelligence tools, increase data accessibility, and foster data-driven decision making across the firm. In addition, this role will work closely with our Product Engineering and Operations Engineering teams to provide data support on greenfield work. The ideal candidate is a strong cross-functional communicator with a proven ability to solve open-ended problems in an elegant, scalable manner. They possess creativity, flexibility, and the drive to consistently deliver on mission critical projects with tight timelines and competing priorities.

Responsibilities

• Develop and automate secure, robust, and high-performing data platform infrastructure to drive CAIS business growth
• Process data through to Snowflake using SQL and code-based ELT (and/or ETL)
• Analyze production workloads and develop data workflow strategies to optimize Snowflake warehouse with scale and efficiency
• Support BAU operations on Snowflake, including access management, audits, and other administrative activities
• Design data models for optimal storage and retrieval that represent the product entities and meet business requirements
• Leverage open-source technologies and cloud solutions to build sophisticated features that help support business analytics
• Build and support pipeline orchestration via Airflow
• Data Architecture (Snowflake preferred)

What We’re Looking For

• Engineering, Mathematics, or other technical degree(s)
• Understanding of AWS and how to create secure infrastructure and data pipelines
• Experience with AWS solutions such as Lambda, S3, and Kafka
• Experience with Athena
• Experience with DBT
• Experience with Snowflake database
• Experience with Integration tools like Fivetran/Airbyte
• 5+ years of experience with SQL
• Strong understanding of a coding language to extract and transform data such as Python/Java
• 5+ years of data warehousing experience with examples of complex ETL/ELT data workflows
• 5+ years of experience with schema design and dimensional data modeling
• 5+ years of experience with object-oriented/functional programming, strong ability to write easy-to-scale, high-quality code
• Experience with or knowledge of Agile Software Development methodologies

Desirable Skills/Knowledge

• Prior experience working within Alternative Investments and/or Financial Services preferred
• Good knowledge of financial markets and financial instruments a plus
• Experience with GitHub Actions a plus
• Experience in developing, maintaining, and managing Tableau (or similar Business Intelligence tool) a plus