onsite
Snowflake Platform Engineer - CIBC Mellon
Devops Engineer
Lead the design, deployment, and optimization of Snowflake-based data platforms, leveraging SQL, Python, and AWS to deliver scalable, high‑performance data solutions for institutional investors.
About the role
Key Responsibilities
- Architect, build, and maintain Snowflake data warehouses, ensuring optimal performance and cost efficiency.
- Develop and manage ETL pipelines using SQL, Python, and Airflow to ingest, transform, and load data from diverse sources.
- Collaborate with data scientists and business analysts to model data, create schemas, and implement best practices for data governance.
- Integrate Snowflake with AWS services (S3, Glue, Redshift) and third‑party tools to support analytics and reporting.
- Monitor system health, troubleshoot issues, and implement automation for monitoring and alerting.
- Document architecture, processes, and standards to enable knowledge sharing across the team.
Requirements
- 3+ years of experience with Snowflake and large‑scale data warehousing.
- Proficiency in SQL, Python, and ETL tooling (Airflow, dbt).
- Hands‑on experience with AWS services (S3, Glue, Lambda).
- Strong understanding of data modeling, performance tuning, and security best practices.
- Excellent communication skills and a collaborative mindset.
Skills
snowflakesqlpythonaws