Lead Snowflake Architect - Data Warehousing & Pipelines

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

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.