Data Engineer

CAIS is the pioneer in democratizing access to and education about alternative investments and structured notes for independent advisors, asset managers, and bank issuers, empowering them to engage and transact on a massive scale. We believe that the combination of industry-leading technology and human interaction throughout the pre-trade, trade, and post-trade experience delivers superior operational efficiency and a world-class client experience. CAIS provides advisors with a broad selection of alternative investment strategies, including private equity, private credit, real estate, infrastructure, hedge funds, and structured notes. CAIS supports over 34,000 advisors who oversee more than $4.5 trillion in network assets.  

Role Overview 

We are looking to hire a Data Engineer into our technology team. In this role, you will focus on designing and implementing tactical data solutions and automating workflows that enhance CAIS business operations. This role emphasizes close collaboration with data analysts and cross-functional teams to deliver data-driven solutions using Python, Snowflake, DBT, and Kubernetes. 

Key Responsibilities 

• Implement and maintain data platform solutions that meet business needs. 
• Develop and automate data pipelines and workflows to ensure efficient data processing. 
• Collaborate closely with data analysts and cross-functional teams to support data-driven decision-making. 
• Assist in ensuring the security and integrity of data solutions. 
• Participate in the design and development of data models to support reporting and analytical needs. 

Skills & Experience Required 

Education: Degree in Computer Science, Software Engineering, or related field, or equivalent industry experience. 

Experience: 2+ years of experience in data engineering or related fields. 

Programming: Proficiency in Python for data processing and automation. 

Data Management: Experience with SQL and Snowflake for data warehousing and data manipulation. 

Cloud Platforms: 

• Strong understanding of AWS and how to create secure infrastructure and data pipelines. 
• Familiarity with cloud-native applications and CI/CD environments. 

Tools & Technologies: 

• Knowledge of Airflow/DAGS and data pipelines. 
• Extensive experience with DBT and Snowflake for data warehousing, demonstrated through the creation and management of complex SQL/ETL/ELT data workflows. 
• Proficiency with Terraform. 

Collaboration: Strong ability to work with data analysts and other stakeholders to deliver actionable insights. 

Highly Advantageous Skills 

• Experience with FiveTran. 
• Knowledge of AI/ML. 
• Experience with containerization and orchestration tools like Docker and Kubernetes. 
• Familiarity with Kafka or similar data streaming technologies. 
• Understanding of CI/CD environments and infrastructure as code, such as Terraform. 
• Experience with data visualization tools like Power BI or Tableau. 

CAIS is consistently recognized as a Best Place to Work, and our culture is at the heart of our success. We are committed to fostering an inclusive environment where employees can be their most authentic selves and feel inspired and supported to bring their voice forward to drive community, growth, and innovation. We are an equal opportunity employer, and do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law.  Learn more about our culture, benefits, and people at https://www.caisgroup.com/our-company/careers. 

CAIS’ compensation package includes a market competitive salary, a performance bonus, and exceptional benefits. If you are located in New York, New York, the base salary range for this role is $150,000 - $190,000. Actual compensation is influenced by a wide array of factors including but not limited to skill set, level of experience, and specific office location. 

CAIS offers a comprehensive benefits package that includes generously subsidized healthcare with 100% employer paid dental and vision insurance, an employer matched retirement plan, wellness programs, and flexible PTO and generous parental leave. Additionally, CAIS offers a hybrid in-office model. For more information on our benefits and career opportunities, please visit our website: https://www.caisgroup.com/our-company/careers.