Principal - Architecture

LTM; West Virginia; On-site; USD 180,000 - 240,000; Full time

Job summary

LTM is seeking a Technofunctional Snowflake Architect to design and implement scalable data pipelines and Snowflake architectures for complex data platforms. The role involves hands-on Snowflake work, data modeling, and collaboration with stakeholders across global teams.

The position requires deep expertise in data warehousing, SQL, ETL/ELT frameworks and cloud platforms (Azure/AWS). The candidate will work with on-site client teams for delivery and governance of data products.

Qualifications

• 12-15 years in Data Warehousing Data Platform Architecture.
• 4-5 years of hands-on Snowflake Architecture experience.
• Experience with Oracle, Informatica or legacy EDW modernization.
• Cloud experience on Azure and AWS.

Responsibilities

• Lead source-to-target 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 with data modeling for analytics and reporting (dimensional/normalized).
• Collaborate with stakeholders to translate requirements into technical solutions.
• Optimize Snowflake performance, cost and storage strategies.
• Ensure data quality, governance and lineage tracking.
• Support EOD batch migration and transformation workloads.
• Coordinate with onsite/offshore teams for delivery.

Skills

Snowflake

SQL

ETL/ELT

Data Modeling

Stakeholder communication

Tools

dbt

Informatica

Talend

Azure Data Factory

Airflow

Job description

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