Senior Data Architect: Snowflake Migrations & AI Tools

AIT Global Inc.; New York (NY); Hybrid; USD 150,000 - 210,000; Full time

Job summary

AIT Global Inc. in NYC, NY (Hybrid) is seeking a hands-on Lead Data Architect to anchor the US side of a multi-year data platform modernization project.

The role focuses on migrating on-prem Hadoop workloads to Snowflake, defining the target architecture, and guiding an India-based delivery team through an AI-assisted migration approach. You will own the architecture, collaborate with client stakeholders, and identify growth opportunities within the account by building strong relationships with

Qualifications

• 12+ years in data engineering and architecture.
• Hadoop (Cloudera, Hive, Spark) to cloud data platform migration delivery.
• Strong SQL, Python and Spark; working knowledge of Snowpark, orchestration and CI/CD for data pipelines.
• Experience with data modeling, lineage and reconciliation in a regulated environment.
• Experience leading distributed teams and presenting to senior client stakeholders.
• Track record of solutioning and proposal development, including identifying client needs, framing solutions and contributing to winning new work.

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 account, sales and delivery leadership on scope, approach, estimates and commercials.
• Mentor engineers and support estimates, scope and risk management.

Skills

Data architecture

Data engineering

Snowflake

SQL

Python

Spark

Hadoop migration

CI/CD for data pipelines

Data modeling

Data lineage

Tools

Snowpark

Hadoop

CI/CD

Orchestration

Job description

AIT Global Inc. in NYC, NY (Hybrid) is seeking a hands-on Lead Data Architect to anchor the US side of a multi-year data platform modernization project.

The role focuses on migrating on-prem Hadoop workloads to Snowflake, defining the target architecture, and guiding an India-based delivery team through an AI-assisted migration approach. You will own the architecture, collaborate with client stakeholders, and identify growth opportunities within the account by building strong relationships with