Lead Data Architect: Snowflake Migration & AI (NYC Hybrid)

Dhaka Technologies Limited; New York (NY); Hybrid; USD 144,000 - 176,000; Full time

Job summary

Altimetrik is hiring a Sr Data Architect on behalf of its client Morgan Stanley for a hybrid position in New York City, NY. We anchor the US side of a data platform modernization, moving on-prem Hadoop workloads to Snowflake and guiding an India-based delivery team.

You will own the target architecture, engage with stakeholders, mentor engineers, and identify new opportunities to grow the account through data platform and AI-enabled consumption initiatives.

Qualifications

• 12+ years in data engineering and architecture.
• 4+ years hands-on Snowflake experience.
• Proven Hadoop to cloud data platform migration delivery.
• Strong SQL, Python and Spark; 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.
• Preferred: financial services background, generative AI tooling for code conversion, SnowPro Advanced Architect cert.

Responsibilities

• Define the target Snowflake architecture, data models, 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.
• 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

12+ years in data engineering and arch

Snowflake experience

SQL

Python

Spark

Data modeling

Data governance

Leadership

Proposal development

AI tooling for code conversion

Tools

Hadoop

Snowflake

Snowpark

Hive

Spark

CI/CD

Job description

Altimetrik is hiring a Sr Data Architect on behalf of its client Morgan Stanley for a hybrid position in New York City, NY. We anchor the US side of a data platform modernization, moving on-prem Hadoop workloads to Snowflake and guiding an India-based delivery team.

You will own the target architecture, engage with stakeholders, mentor engineers, and identify new opportunities to grow the account through data platform and AI-enabled consumption initiatives.