Senior Data Architect - Snowflake Migration, NYC Hybrid

Staffingine LLC; New York (NY); Hybrid; USD 144,000 - 176,000; Full time

Job summary

Staffingine LLC seeks a hands-on Sr Data Architect to anchor the US side of a multi-year data platform modernization, moving on-prem Hadoop workloads to Snowflake. You will own the target architecture, guide an India-based delivery team, and shape solutions for expanding the account.

The role requires 12+ years in data engineering and architecture with strong Snowflake experience, plus leadership and proposal development skills for new opportunities.

Qualifications

• 12+ years in data engineering and architecture.
• 4+ years of hands-on Snowflake experience.
• Experience leading distributed teams and presenting to senior stakeholders.

Responsibilities

• Define the target Snowflake architecture, including data models, layering, and ingestion and transformation patterns.
• Lead assessment and design for Hadoop-to-Snowflake migrations, deciding which assets to migrate, re-engineer, archive or retire.
• Guide conversion of Hive, Spark, Python and shell workloads to Snowflake SQL and Snowpark, using AI-assisted tools with clear review controls.
• Set the validation approach: reconciliation, data-quality rules, parallel runs, cutover and rollback.
• Work with client architecture, security and governance teams on access, retention and compliance decisions.
• Identify new growth opportunities within the account, such as further migration domains, data platform and AI-enabled consumption initiatives, by building relationships with client architects and business stakeholders.
• Recommend solutions and shape proposals for these opportunities, working with Altimetrik account, sales and delivery leadership on scope, approach, estimates and commercials.
• Mentor engineers and support estimates, scope and risk management.

Skills

Data architecture

Snowflake

Hadoop migration

SQL

Python

Snowpark

CI/CD

Tools

Snowflake

Hadoop

Hive

Spark

Python

Snowpark

CI/CD

Job description

Staffingine LLC seeks a hands-on Sr Data Architect to anchor the US side of a multi-year data platform modernization, moving on-prem Hadoop workloads to Snowflake. You will own the target architecture, guide an India-based delivery team, and shape solutions for expanding the account.

The role requires 12+ years in data engineering and architecture with strong Snowflake experience, plus leadership and proposal development skills for new opportunities.