Skip to main content

Sr Data Architect

Posted yesterday

aifa solutionsSouthfield (MI)

SENIORITY

Manager

Apply (opens in a new tab)

About the role

Job Description: Job Description Role: Sr Data Architect Location- NYC, NY (Hybrid)
Duration: Fulltime About the Role We're looking for a hands-on Lead Data Architect to anchor the US side of a multi-year data platform modernization for a leading global financial services client. The program moves on-premises Hadoop workloads to Snowflake. You'll own the target architecture, work with client stakeholders, guide an India-based delivery team through an AI-assisted migration approach, and help grow the account by identifying new opportunities and shaping solutions for them.
What You'll Do: 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.
What You Bring: 12 years in data engineering and architecture, with 4 years of hands-on Snowflake experience. - Proven 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. - Preferred: financial services background, generative AI tooling for code conversion, SnowPro Advanced Architect certification.

Before you apply

Applying takes about a minute. These four things decide how fast it moves after that.

Your profile is current

It's what we read first. Occupations, seniority and locations matter more than a long history.

Two examples you can talk through

Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.

A number in mind

What you're on now and what would make you move. We negotiate better when we know both.

Your notice period

Employers plan around it, and it's the question that stalls offers most often.

Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.

More like this