Lead a multi-year Hadoop-to-Snowflake modernization, defining target architecture, data models, ingestion patterns, migration strategy, validation, governance, and cutover plans. Convert Hive, Spark, Python, and shell workloads to Snowflake SQL and Snowpark using AI-assisted tools. Partner with stakeholders, mentor distributed engineering teams, support estimates and risk management, and identify and shape new account opportunities through solutioning and proposal development.
Location: New York City, NY (Hybrid)
Employment Type: Full-time
Salary: $160,000 USD per annum
Dhaka Technologies Limited Company (DTLC) is hiring a Sr Data Architect on behalf of its client for a hybrid position in New York City, NY.
About the RoleWe'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 account, sales and delivery leadership on scope, approach, estimates and commercials.
- Mentor engineers and support estimates, scope and risk management.
- 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.
Interested candidates are requested to send their updated resume to [email protected] with the subject line "Sr Data Architect - NYC, NY".
Similar Jobs
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Leads client-focused generative AI and data modernization architecture, translating business needs into scalable solutions using Google Cloud, Vertex AI, LLMs, vector databases, and modern data platforms. Advises stakeholders, develops AI evaluation and guardrail practices, guides experimentation and deployment, presents technical recommendations, supports proposals, and coaches teams through complex transformation programs.
Top Skills:
Agent OrchestrationContext EngineeringGCPLangchainLanggraphLlm ApisLlmopsMachine LearningNatural Language ProcessingPrompt EngineeringPythonRetrieval-Augmented GenerationVector DatabasesVertex Ai
Cloud • Security • Software • Cybersecurity
Designs scalable, secure, resilient cloud and data architectures for high-volume services. Evaluates cloud technologies, develops reusable Terraform infrastructure and automation, and serves as a database architecture expert for PostgreSQL, Oracle, MongoDB, Redis, and Valkey. Builds prototypes and reference implementations, designs highly available distributed database systems, coaches engineers, partners with product and SRE teams, and converts validated concepts into production-ready architecture patterns.
Top Skills:
BashCloud ComputingDistributed Data SystemsGoMongoDBNosql DatabasesOracle DatabasePostgresPythonRedisRelational DatabasesTerraformValkey
Consulting
Leads enterprise information architecture, business intelligence, and data warehouse strategy and delivery. Oversees BI and data warehouse teams, establishes roadmaps and governance, mentors technical staff, manages project priorities, and ensures high-quality implementation. Designs enterprise data models, datamarts, metadata, ETL processes, reporting strategies, and integration artifacts. Partners with business and technology stakeholders to align data solutions with strategic goals, improve adoption, track value, and drive continuous improvement.
Top Skills:
Data WarehousingDaxETLM LanguageMicrosoft FabricMicrosoft Power BiPower QueryPythonSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
