Consultant, Data Engineer | Snowflake Data Engineer (Python / Snowpark)
Core
Design enterprise-scale data warehousing and cloud integration strategies on Snowflake, building scalable ELT pipelines and optimizing query performance for finance and investment operations.
Role type
Senior IC Snowflake Data Engineer
Builds
Enterprise data warehouses, reusable ELT pipelines, and data modeling frameworks
Domain
Financial services / Cloud Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Snowflake architecture, Python, Advanced SQL, dbt, Apache Airflow/Prefect, AWS/Azure/GCP, Data modeling (Dimensional/Data Vault), Performance tuning, CI/CD
Preferred skills
PySpark, Databricks, Apache Spark, Apache Iceberg, Unity Catalog, Insurance/financial services industry knowledge
Technologies
Snowflake, Snowpark, dbt, Apache Airflow, Apache Spark, PySpark, AWS, Azure, GCP, Databricks, Apache Iceberg, Unity Catalog, JIRA, Jenkins, Confluence, Git
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 Snowpipe, Streams, Tasks, and Snowpark; Implement data modeling frameworks using dbt; Optimize query performance and manage warehouse compute costs; Integrate orchestration tools to manage complex dependency graphs and scheduling.
Seniority
Senior, hands-on IC
