Snowflake Data Architect

Incedo Inc.; Dallas (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Incedo Inc. in Dallas is seeking a seasoned Data Architect to design enterprise data architectures using Snowflake and cloud platforms. You will define data models, pipelines, and governance to enable scalable analytics across the organization.

The role requires leadership across data engineering, BI, and DevOps teams, with a focus on performance, security, and data quality, and hands-on Snowflake development to drive modernization initiatives.

Qualifications

• 10+ years of experience in Data Engineering, Data Architecture, or related technology roles.
• Strong hands-on experience with Snowflake architecture and development.
• Strong expertise in SQL and enterprise data modeling.
• Experience designing enterprise data warehouses and cloud data platforms.
• Strong understanding of Dimensional Modeling, Star/Snowflake Schemas, Data Vault, and Data Marts.
• Experience with ETL/ELT and data integration technologies.
• Strong understanding of cloud platforms such as AWS or Azure.
• Experience with large-scale data migration and modernization programs.
• Strong understanding of data governance, metadata, lineage, security, and data quality.
• Experience designing batch and real-time/streaming data architectures.
• Strong communication and stakeholder-management skills.
• Ability to translate business requirements into scalable technical architecture.

Responsibilities

• Design and define enterprise data architecture using Snowflake and modern cloud data-platform technologies.
• Develop scalable Snowflake architecture, data models, data pipelines, and integration patterns.
• Define logical, conceptual, and physical data models for enterprise data products.
• Design modern Data Warehouse, Data Lake, and Lakehouse architectures.
• Lead migration and modernization initiatives from legacy platforms to Snowflake.
• Design data ingestion and transformation patterns using ETL/ELT frameworks.
• Work with large-volume structured and semi-structured data using Snowflake.
• Implement Snowflake capabilities including Streams, Tasks, Snowpipe, Dynamic Tables, Time Travel, Zero-Copy Cloning, and Snowflake SQL.
• Define architecture for batch and near-real-time data processing.
• Collaborate with Data Engineers, BI teams, Application Architects, DevOps teams, and business stakeholders.
• Establish data governance, security, privacy, access control, and data-quality standards.

Skills

Snowflake

SQL

Data modeling

ETL/ELT

Cloud platforms

Data governance

Batch/real-time

Stakeholder Mgmt

Architectural leadership

Architecture diagrams

Tools

Snowflake

AWS

Azure

ETL/ELT tools

Data integration

Job description

Incedo Inc. is a high-growth Digital, Data and AI Transformation Specialist firm headquartered in New Jersey. We are a long-term strategy execution partner for Fortune 500 enterprises, operating at the intersection of business and technology across Banking & Payments, Wealth Management, Telecom, Hi-Tech, and Life Sciences.

We are building Incedo 4.0 - an AI-native, execution-focused, founder-led organization designed for scale, speed, and long-term impact.

Incedo delivers ROI from AI @ Scale through the “Power of 3”:

• Engineering & Operations excellence

Key Responsibilities

• Design and define enterprise data architecture using Snowflake and modern cloud data-platform technologies.
• Develop scalable Snowflake architecture, data models, data pipelines, and integration patterns.
• Define logical, conceptual, and physical data models for enterprise data products.
• Design modern Data Warehouse, Data Lake, and Lakehouse architectures.
• Lead migration and modernization initiatives from legacy platforms to Snowflake.
• Design data ingestion and transformation patterns using ETL/ELT frameworks.
• Work with large-volume structured and semi-structured data using Snowflake.
• Implement Snowflake capabilities including Streams, Tasks, Snowpipe, Dynamic Tables, Time Travel, Zero-Copy Cloning, and Snowflake SQL.
• Define architecture for batch and near-real-time data processing.
• Integrate Snowflake with cloud services such as AWS/Azure, APIs, databases, messaging platforms, and enterprise applications.
• Establish data governance, security, privacy, access control, and data-quality standards.
• Design RBAC, data masking, row-level security, encryption, and secure data-sharing solutions.
• Optimize Snowflake workloads for performance, scalability, availability, and cost.
• Establish standards for data lineage, metadata management, data quality, and data observability.
• Collaborate with Data Engineers, BI teams, Application Architects, DevOps teams, and business stakeholders.
• Provide technical leadership and architectural guidance to engineering teams.
• Create architecture diagrams, technical specifications, standards, and reusable reference architectures.
• Evaluate emerging Snowflake and cloud data technologies and recommend appropriate solutions.

Required Skills

• 10+ years of experience in Data Engineering, Data Architecture, or related technology roles.
• Strong hands-on experience with Snowflake architecture and development.
• Strong expertise in SQL and enterprise data modeling.
• Experience designing enterprise data warehouses and cloud data platforms.
• Strong understanding of Dimensional Modeling, Star/Snowflake Schemas, Data Vault, and Data Marts.
• Experience with ETL/ELT and data integration technologies.
• Strong understanding of cloud platforms such as AWS or Azure.
• Experience with large-scale data migration and modernization programs.
• Strong understanding of data governance, metadata, lineage, security, and data quality.
• Experience designing batch and real-time/streaming data architectures.
• Strong communication and stakeholder-management skills.
• Ability to translate business requirements into scalable technical architecture.

Key Qualifications

• Strong architecture and technical leadership capabilities.
• Deep understanding of modern cloud data architecture.
• Strong hands-on Snowflake expertise rather than purely theoretical architecture experience.
• Ability to work across business and technology teams.
• Strong analytical, problem-solving, and communication skills.