Smart IT Frame LLC
Snowflake Data Architect with AWS Cloud migration
Smart IT Frame LLC, Jersey City, New Jersey, United States, 07390
Snowflake Data Architect with AWS Cloud migration
Direct message the job poster from Smart IT Frame LLC Role: Data Architect – Snowflake
Must have: AWS Cloud migration exp. Must have: Snowflake, Data Architecture and Modeling Key responsibilities
Design and maintain scalable, high-performance Snowflake data warehouse architectures to support both batch and real-time data ingestion. Define and enforce data modeling standards (e.g., dimensional, normalized, or hybrid) tailored to Snowflake architecture. Architect data integration frameworks that support complex transformations, multi-source ingestion, and cross-domain data harmonization. Integrate data from diverse sources (e.g., APIs, on-prem databases, cloud storage, third‑party feeds) into Snowflake. Ensure data pipelines are resilient, fault‑tolerant, and optimized for performance and cost. Define and implement data quality frameworks, validation rules, and monitoring processes. Collaborate with data governance teams to ensure compliance with data privacy, security, and regulatory requirements. Support metadata management, lineage tracking, and data catalog integration. Monitor and tune Snowflake workloads, including query performance, warehouse sizing, and storage optimization. Provide architectural guidance and mentorship to engineering teams on best practices for Snowflake and data integration. Lead design reviews and contribute to strategic planning for enterprise data initiatives. Qualifications / Education / Experience
Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related field. 7+ years of experience in data architecture, data engineering, or enterprise data warehousing. Proven experience designing and implementing large‑scale Snowflake data platforms in production environments. Deep understanding of Snowflake architecture, including virtual warehouses, Snowpipe, Streams, Tasks, and Time Travel. Experience with Snowflake performance tuning, cost optimization, and security best practices. Familiarity with Snowflake data sharing, data marketplace, and multi‑cluster warehouse configurations. Strong experience with both batch and streaming data ingestion frameworks (e.g., Apache Spark, Kafka, Python, dbt, Airflow). Ability to design and manage complex ETL/ELT pipelines integrating data from diverse sources. Proficiency in SQL and scripting languages (e.g., Python, Shell) for data transformation and orchestration. Expertise in data modeling techniques (dimensional, normalized, data vault) and metadata management. Understanding of data governance, data quality frameworks, and regulatory compliance (e.g., GDPR, SOX). Experience with data cataloging tools and lineage tracking (e.g., Alation, Collibra, Microsoft Purview). Strong collaboration skills to work with cross‑functional teams including data engineers, analysts, and business stakeholders. Ability to translate business requirements into scalable and maintainable data architecture. Excellent communication and documentation skills to articulate architectural decisions and data strategies. Seniority level
Not Applicable Employment type
Contract Job function
Other Referrals increase your chances of interviewing at Smart IT Frame LLC by 2x Get notified about new Data Architect jobs in
Jersey City, NJ .
#J-18808-Ljbffr
Direct message the job poster from Smart IT Frame LLC Role: Data Architect – Snowflake
Must have: AWS Cloud migration exp. Must have: Snowflake, Data Architecture and Modeling Key responsibilities
Design and maintain scalable, high-performance Snowflake data warehouse architectures to support both batch and real-time data ingestion. Define and enforce data modeling standards (e.g., dimensional, normalized, or hybrid) tailored to Snowflake architecture. Architect data integration frameworks that support complex transformations, multi-source ingestion, and cross-domain data harmonization. Integrate data from diverse sources (e.g., APIs, on-prem databases, cloud storage, third‑party feeds) into Snowflake. Ensure data pipelines are resilient, fault‑tolerant, and optimized for performance and cost. Define and implement data quality frameworks, validation rules, and monitoring processes. Collaborate with data governance teams to ensure compliance with data privacy, security, and regulatory requirements. Support metadata management, lineage tracking, and data catalog integration. Monitor and tune Snowflake workloads, including query performance, warehouse sizing, and storage optimization. Provide architectural guidance and mentorship to engineering teams on best practices for Snowflake and data integration. Lead design reviews and contribute to strategic planning for enterprise data initiatives. Qualifications / Education / Experience
Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related field. 7+ years of experience in data architecture, data engineering, or enterprise data warehousing. Proven experience designing and implementing large‑scale Snowflake data platforms in production environments. Deep understanding of Snowflake architecture, including virtual warehouses, Snowpipe, Streams, Tasks, and Time Travel. Experience with Snowflake performance tuning, cost optimization, and security best practices. Familiarity with Snowflake data sharing, data marketplace, and multi‑cluster warehouse configurations. Strong experience with both batch and streaming data ingestion frameworks (e.g., Apache Spark, Kafka, Python, dbt, Airflow). Ability to design and manage complex ETL/ELT pipelines integrating data from diverse sources. Proficiency in SQL and scripting languages (e.g., Python, Shell) for data transformation and orchestration. Expertise in data modeling techniques (dimensional, normalized, data vault) and metadata management. Understanding of data governance, data quality frameworks, and regulatory compliance (e.g., GDPR, SOX). Experience with data cataloging tools and lineage tracking (e.g., Alation, Collibra, Microsoft Purview). Strong collaboration skills to work with cross‑functional teams including data engineers, analysts, and business stakeholders. Ability to translate business requirements into scalable and maintainable data architecture. Excellent communication and documentation skills to articulate architectural decisions and data strategies. Seniority level
Not Applicable Employment type
Contract Job function
Other Referrals increase your chances of interviewing at Smart IT Frame LLC by 2x Get notified about new Data Architect jobs in
Jersey City, NJ .
#J-18808-Ljbffr