Senior Data Architect

IMR Soft LLC; New York (NY); On-site; USD 150,000 - 210,000; Full time

Job summary

IMR Soft LLC is seeking a Senior Data Architect to design and govern large-scale data platforms across Snowflake and PostgreSQL, with a strong emphasis on cloud-native architecture and data warehousing.

You will lead AI/GenAI integrations, data governance, and enterprise-scale modernization initiatives, collaborating with cross-functional teams to drive architecture standards and migrations.

Qualifications

• 10+ years in data architecture and data engineering.
• Enterprise data warehouse design and dimensional modeling.
• Governance and data quality frameworks across large datasets.
• Snowflake architecture, administration, and PostgreSQL performance.
• Programming and automation: Python, Spark, Databricks, Talend.

Responsibilities

• Design and govern large-scale data platforms across Snowflake and PostgreSQL.
• Lead cloud-native data warehousing initiatives and modernization.
• Implement data governance and data quality frameworks.
• Develop AI/GenAI integrations and RAG solutions into data platforms.
• Collaborate with stakeholders on data architecture standards and migrations.

Skills

10+ years in data architecture

Enterprise data warehouse architecture

Data modeling

Data governance

Data quality frameworks

Cloud-native architecture

AI / GenAI (strong preference)

Tools

Snowflake

PostgreSQL

Python

Ansible

Spark

Databricks

Talend

Power BI

Microsoft Fabric

Snowflake Cortex

Snowflake ML

Snowpark

Vector Search

Job description

This is a senior architecture role focused on designing and governing large-scale data platforms across Snowflake and PostgreSQL, with strong emphasis on cloud-native architecture, data warehousing, AI/ML integration, RAG solutions, data governance, and enterprise-scale modernization initiatives.

Must-Have Skills (Priority)

Core Data Architecture

• 10+ years in Data Architecture / Data Engineering
• Enterprise Data Warehouse architecture
• Data Modeling (dimensional & enterprise data models)
• Data Governance and Data Quality frameworks

Database Technologies

• Snowflake Architecture & Administration
• PostgreSQL Administration & Performance Tuning
• Query Optimization
• Distributed Database Design
• Snowflake Design Patterns
• Data Warehouse Migration Projects

Programming / Automation

• Python
• Ansible
• Infrastructure Automation
• Monitoring & Scaling Frameworks
• Spark
• Databricks
• Talend
• Power BI
• Microsoft Fabric

AI / GenAI (Strong Preference)

• Snowflake Cortex
• Snowflake ML
• AI SQL
• Snowpark
• Vector Search

Nice-to-Have Skills

• Knowledge Graphs
• Data Fabric Architecture
• Serverless Architectures
• Audit/Legal/Financial industry experience
• Experience working in regulated environments