Snowflake Architect

Role Overview

• Design and implement scalable, secure, and high-performance data architectures using Snowflake and Databricks
• Develop and manage ELT/ETL workflows using dbt, ensuring modular, testable, and well-documented transformations
• Develop and maintain cloud-native data pipelines on AWS (e.g., S3, Glue, Lambda, Redshift, EMR)
• Architect and optimize data models for analytics, reporting, and machine learning use cases
• Build and manage data ingestion, transformation, and orchestration workflows
• Leverage Python for data engineering, automation, and advanced data processing
• Implement and manage Feature Store solutions for ML lifecycle management
• Utilize Snowflake Cortex for AI/ML-powered data applications and advanced analytics
• Collaborate with data scientists, analysts, and business stakeholders to translate requirements into technical solutions
• Establish data governance, data quality, and security best practices
• Optimize performance, cost, and scalability of data platforms
• Mentor and guide data engineers and other team members

Requirements

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or related field
• 7+ years of experience in data architecture, data engineering, or related roles
• Strong expertise in Snowflake (data modeling, performance tuning, security)
• Strong hands-on experience with dbt, ETL/ELT frameworks and data pipeline orchestration
• Experience with AWS data services (S3, Glue, Lambda, IAM, Redshift, etc.)
• Advanced proficiency in Python for data processing and pipeline development
• Experience designing and implementing enterprise-scale data warehouses and data lake
• Experience with Snowflake Cortex and AI-driven data applications
• Hands-on experience with Databricks (Spark, Delta Lake, notebooks, workflows)
• Experience with Dagster (data orchestration and pipeline management)
• Hands-on experience with Feature Stores (e.g., Snowflake Feature Store or similar)
• Knowledge of machine learning workflows and MLOps practices
• Familiarity with streaming technologies (Kafka, Kinesis, etc.)
• Experience with data governance and compliance frameworks
• Certifications in AWS, Snowflake, or Databricks.

Tech Stack

• Amazon Redshift
• AWS
• Cloud
• ETL
• Kafka
• Python
• Spark

Benefits

• Health Insurance: Comprehensive medical, dental, and employer-paid vision plans through UnitedHealthcare (UHC), with various coverage levels available to meet the needs of our employees and their families. Additional perks through UHC include: Sweat Equity, free subscription to the Calm App, UHC rewards, Real Appeal, and Quit For Life.
• Flexible Spending Account: Set aside pre-tax dollars from your paycheck to pay for qualified out-of-pocket medical, dental, vision, pharmacy or dependent care expenses.
• Lifestyle Spending Account: Employer sponsored post-tax benefits that allow reimbursement for expenses related to physical, mental and financial well-being.
• 100% Company Paid Insurances: Kapitus fully covers the cost of basic short-term and long-term disability insurance, as well as vision insurance, ensuring our employees have comprehensive protection without any personal expense.
• Voluntary Insurance: Supplemental life insurance as well as enhanced short
• and long-term disability coverage are available through Mutual of Omaha, providing additional security for our employees. Additionally, Colonial Accident and Hospitalization insurances are also available, offering further protection against unforeseen events.
• Paid Maternity and Parental Leave: Beyond state-mandated leave policies, Kapitus provides company-paid maternity and parental leave, supporting our employees during important family milestones.
• Commuter Benefits: We offer pre-tax benefits on parking and commuter expenses to cover travel to and from work.
• LifeBalance Program: Enhance your lifestyle with our LifeBalance membership, which offers discounts on outdoor activities, the arts, health, and fitness. Additional benefits include: Pet and car insurance discounts, Financial services such as LegalShield, Relaxation and stress management tools.
• Plum Benefits Discount Program: Access exclusive discounts on shows, travel, car rentals, and more, enriching your personal and family life.
• Tuition Reimbursement: Pursue further education with up to $5,000 annually in tuition reimbursement, plus opportunities to attend relevant conferences and career development events. Managed through our LSA plan, Kapitus Academy.
• Travel Reimbursement: We also offer travel reimbursement for all work-related travel, supporting your involvement in career and personal development activities.
• Paid Time Off and Sick Time.
• Retirement Benefits: Our 401K plan is managed through Fidelity. To support your long-term financial goals, the company provides a 25% match on your contributions, up to 6% of your annual salary.