Lead Data Architect

ESRhealthcare and EXEC STAFF RECRUITERS • Nyc, NY

8d

About The Position

Lead the US-side architecture and delivery for a multi-year data platform modernization program for a global financial services client, migrating on-premises Hadoop workloads to Snowflake. Own the target architecture, collaborate with client stakeholders, and guide an India-based delivery team through an AI-assisted migration approach. The role also supports account growth by identifying opportunities and shaping solutions and proposals.

Requirements

• 12+ years of experience in data engineering and architecture.
• 4+ years of hands-on Snowflake experience.
• Proven delivery experience migrating Hadoop (Cloudera, Hive, Spark) to a cloud data platform.
• Strong SQL, Python, and Spark skills.
• 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.

Nice To Haves

• Financial services background.
• Experience with generative AI tooling for code conversion.
• SnowPro Advanced Architect certification.

Responsibilities

• Define the target Snowflake architecture, including data models, layering, and ingestion and transformation patterns.
• Lead assessment and design for Hadoop-to-Snowflake migrations, determining 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 and clear review controls.
• Set the validation approach, including reconciliation, data-quality rules, parallel runs, cutover, and rollback.
• Work with client architecture, security, and governance teams on access, retention, and compliance decisions.
• Identify account growth opportunities, including additional migration domains and data-platform and AI-enabled consumption initiatives, by building relationships with client architects and business stakeholders.
• Recommend solutions and shape proposals with account, sales, and delivery leadership, including scope, approach, estimates, and commercials.
• Mentor engineers and support estimates, scope, and risk management.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed