Data Architect

Themesoft Inc.; New York (NY); On-site; USD 150,000 - 210,000; Full time

Job summary

TheThemesoft Inc. is seeking a senior data engineering leader to drive Snowflake migrations to Hadoop, Python, SQL, Spark, AI, LLM and RAG.

With 12+ years in data engineering and architecture and 4+ years of hands-on Snowflake experience, you will translate complex data needs into scalable cloud platforms. You will lead distributed teams, present to senior client stakeholders, craft solutions and contribute to winning new work.

Qualifications

• 12+ years in data engineering and architecture
• 4+ years hands-on Snowflake experience
• Strong SQL, Python and Spark skills
• Experience with data modeling, lineage and reconciliation in regulated environments
• Experience leading distributed teams and presenting to senior client stakeholders
• Track record of solutioning and proposal development, including identifying client needs and framing solutions

Skills

Snowflake

Hadoop migration

SQL

Python

Spark

Snowpark

Data modeling

Stakeholder leadership

Tools

CI/CD for data

Airflow

Job description

Snowflake Migration to Hadoop, Python, SQL, Spark, AI, LLM and RAG

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.

Authorization: Applicants must be legally authorized to work in the United States.