Senior Data Architect

Smart IT Frame LLC; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading data solutions firm based in New York is seeking an experienced Data Architect to design and manage scalable, high-performance data solutions. The role includes driving enterprise data architecture, defining data models, and ensuring data governance and quality. Ideal candidates will have 8+ years of experience in data architecture, strong knowledge of data modeling, and expertise with cloud data platforms. This is a client-facing role requiring collaboration with business stakeholders and technical teams.

Qualifications

• 8+ years of experience in data architecture and/or data engineering.
• Strong knowledge of data modeling (3NF, Star Schema, Snowflake Schema).
• Expertise in SQL and database design principles.
• Hands-on experience with at least one modern cloud data platform (Warehouse/Lakehouse).

Responsibilities

• Own enterprise data architecture including standards and best practices.
• Design reusable architecture patterns and ETL/ELT frameworks.
• Build and optimize warehouse/datamart architectures for analytics.
• Ensure data governance, quality, and secure access controls.
• Drive architecture reviews and maintain documentation.
• Collaborate with stakeholders to translate requirements into solutions.
• Client-facing role with ownership of data architecture.

Skills

Data modeling

SQL

Data warehousing

Cloud data platforms

ETL/ELT tools

Communication skills

Education

Bachelor’s/Master’s degree in Computer Science / IT / Engineering

Tools

BigQuery

Databricks

Snowflake

Redshift

Collibra

Kafka

Job description

We are looking for an experienced Data Architect to design and manage scalable, secure, and high-performance data solutions. The candidate will drive enterprise data architecture, define data models, and build end-to-end frameworks for data integration, governance, and analytics across multiple platforms.

Responsibilities

• Own enterprise data architecture across conceptual, logical, and physical models, including data standards, naming conventions, and best practices.
• Design reusable architecture patterns (CDC ingestion, SCD handling, lakehouse/warehouse layers, medallion architecture) and architect scalable ETL/ELT + ingestion frameworks for end-to-end integration and transformations.
• Build and optimize warehouse/datamart architectures for analytics and reporting with strong focus on performance tuning (partitioning, clustering, indexing, query optimization).
• Ensure data governance, quality, lineage, metadata management, and secure access controls (RBAC, encryption, masking).
• Drive architecture reviews, technical decisions, and create/maintain documentation (architecture diagrams, data flows, ERDs, integration specs) ensuring alignment with enterprise standards.
• Collaborate with business stakeholders, data engineers, cloud, and BI teams to translate requirements into validated solutions.
• Client-facing role with end-to-end ownership of data architecture and delivery in a high-stakes, high-impact environment.

Skills & Qualifications

• 8+ years of experience in data architecture and/or data engineering with strong architecture ownership
• Strong knowledge of data modeling (3NF, Star Schema, Snowflake Schema, Dimensional Modeling)
• Expertise in SQL and database design principles
• Strong experience with data warehousing concepts and best practices
• Hands‑on experience with at least one modern cloud data platform (Warehouse/Lakehouse): BigQuery / Databricks / Snowflake / Redshift
• Experience with ETL/ELT tools and orchestration frameworks
• Knowledge of data governance tools (Collibra, Alation, Purview) is a plus
• Exposure to API‑based ingestion and streaming (Kafka / PubSub) is a plus
• Strong communication and stakeholder management skills

Education

• Bachelor’s/Master’s degree in Computer Science / IT / Engineering or equivalent experience