Snowflake Engineer (Python / Snowpark)
Core
Design enterprise-scale data warehousing and cloud integration strategies on Snowflake, building scalable ELT pipelines and optimizing performance for a Fortune 100 financial services company.
Role type
Senior Snowflake Data Engineer (Python/Snowpark)
Builds
Enterprise data warehousing solutions, reusable data capabilities, and ELT pipelines for finance and investment operations.
Domain
Financial Services / Cloud Data Engineering
Deliverable
production ML models
Required skills
Snowflake architecture, Python, PySpark, Snowpark, dbt, SQL, Apache Airflow, data modeling (Dimensional/Data Vault), performance tuning, RBAC
Preferred skills
Certified Snowflake Engineer, experience with Azure/AWS big data technologies, CI/CD practices
Technologies
Snowflake, Snowpipe, Streams, Tasks, dbt, Apache Airflow, Prefect, PySpark
Responsibilities
Lead design of enterprise-scale data warehousing and cloud integration strategies; Establish standards for data ingestion, transformation, orchestration, and performance tuning; Build scalable ELT pipelines leveraging native Snowflake features; Implement data modeling frameworks; Optimize query performance and manage warehouse compute costs; Integrate orchestration tools to manage complex dependency graphs.
Seniority
Senior, hands-on IC