Role Description
Role: Technofunctional Snowflake Architect
Mode: 5 Days from Zurich
Type: Permanent
Key Responsibilities
- 12-15 years in Data Warehousing Data Platform Architecture
- 4-5 years of handson Snowflake Architecture experience
- Snowflake performance tuning security RBAC data sharing streams tasks Snowpipe
- Data modeling Dimensional Data Vault
- SQL Python ELTETL frameworks
- Experience with Oracle Informatica or legacy EDW modernization
- Cloud experience AzureAWS
- Lead sourcetotarget data mapping from Oracle or legacy systems to Snowflake
- Design and implement scalable data pipelines and ingestion frameworks
- Build and manage data products aligned with business use cases
- Work on data modeling dimensionalnormalized for analytics and reporting
- Collaborate with business stakeholders to translate functional requirements into technical solutions
- Optimize Snowflake performance cost and storage strategies
- Ensure data quality governance and lineage tracking
- Support endofday EOD batch migration and transformation workloadsWork closely with onsiteoffshore teams for delivery
Technical Skills
- Strong handson experience with Snowflake mandatory
- Expertise in SQL data warehousing and ETLELT pipelines
- Experience with tools like dbt Informatica Talend or Azure Data Factory
- Knowledge of data pipeline orchestration Airflow or similar
- Experience in cloud platforms AzureAWSGCP
FunctionalDomain Skills
- Understanding of BFSI domain wealth management preferred
- Experience in data products and analytics platforms
- Investment Management Asset Management domain
- Trade lifecycle understanding
- Securities Equities Fixed Income Derivatives
- Portfolio Position and Holdings data
- Benchmark and Market Data
- IBOR ABOR concepts
- NAV calculations
- Regulatory reporting
Soft Skills
- Strong stakeholder communication
- Ability to work in clientfacing onsite roles
- Problemsolving and ownership mindset
Additional Expectations
- Willingness to work onsite in Zurich client location
- Ability to collaborate across global teams Europe Offshore