Principal - Architecture

Role Description

Role:
Techno functional Snowflake Architect

Mode: 5 Days from Zurich

Type:
Permanent

• 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 dimensional normalized 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 workloads
  
  Work closely with onsite offshore teams for delivery

• 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

• 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

• Strong stakeholder communication
• Ability to work in client facing onsite roles
• Problem solving and ownership mindset

• Willingness to work onsite in Zurich client location
• Ability to collaborate across global teams Europe Offshore