Data Architect

Robotic Process Automation LLC; Austin (TX); On-site; USD 180,000 - 260,000; Full time

Job summary

Robotic Technologies Automation in Austin, TX is seeking a hands-on Lead Data Architect to anchor a US‑side data platform modernization for a global financial services client. You will own the target architecture and guide a distributed team through an AI‑assisted migration from on‑prem Hadoop to Snowflake.

You’ll engage with client stakeholders, shape solutions and proposals, and identify growth opportunities within the account while ensuring data governance, security, and compliance across the

Qualifications

• 12+ years in data engineering and architecture.
• 4+ years hands-on Snowflake experience.
• Experience with Hadoop (Cloudera, Hive, Spark) to cloud migrations.

Responsibilities

• Define the target Snowflake architecture, data models, ingestion and transformation patterns.
• Lead assessment and design for Hadoop-to-Snowflake migrations and determine assets to migrate, re‑engineer, archive or retire.
• Guide conversion of workloads to Snowflake SQL and Snowpark with AI-assisted tools and review controls.
• Set the validation approach: reconciliation, data-quality rules, parallel runs, cutover and rollback.
• Work with client teams on access, retention and compliance decisions.
• Identify growth opportunities within the account and shape solutions and proposals with sales and delivery leadership.
• Mentor engineers and support estimates, scope and risk management.

Skills

SQL

Python

Spark

Data modeling

Data governance

Tools

Snowflake

Hadoop

Snowpark

CI/CD

SnowPro Advanced Architect

Job description

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.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.