Data Architect

Data Architect

Pay Range: $60hr - $65hr

Requirement/Must Have:

• Minimum 8 years of experience in data architecture, data engineering, or data platform roles.
• Minimum 4 years of hands-on experience designing and optimizing Snowflake solutions.
• Warehouses.
• Resource monitors.
• Zero-copy cloning.
• Time Travel.
• Data sharing.
• Snowpark.
• Streams and Tasks.
• Security and governance controls.
• Strong proficiency in SQL and enterprise data modeling.
• Experience designing conceptual, logical, and physical data models.
• Experience with ETL/ELT patterns and cloud data platforms such as AWS, Azure, or GCP.
• Experience designing secure and scalable architectures for analytics, reporting, and machine learning workloads.
• Data governance.
• Data quality.
• Data lineage.
• Compliance standards such as GDPR, SOC2, and HIPAA.
• Excellent communication, leadership, and stakeholder management skills.
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or related field.

Experience:

• Experience architecting Snowflake-based data warehouses, data lakes, and lakehouse platforms.
• Experience optimizing query performance, cost management, autoscaling, and workload strategies.
• Experience designing ingestion frameworks for batch and streaming data pipelines.
• Experience implementing Snowpipe, Snowpark, Streams, and Tasks.
• Experience integrating structured and unstructured datasets across enterprise systems.
• Experience leading migrations from legacy or on-premises data platforms to Snowflake.
• Experience designing disaster recovery, replication, and high-availability strategies.
• Experience mentoring technical teams and conducting architecture/design reviews.

Responsibilities:

• Lead end-to-end data architecture and solution design for Snowflake-based platforms.
• Design logical and physical data models, ingestion patterns, and scalable storage architectures.
• Architect analytics-ready and AI-ready data foundations for enterprise reporting and machine learning.
• Optimize Snowflake environments for performance, scalability, and cost efficiency.
• Cortex LLM functions.
• Cortex Search.
• Cortex Analyst.
• Retrieval-Augmented Generation (RAG) patterns.
• Define and enforce enterprise data governance, security, and compliance frameworks.
• Design and implement secure data access controls including RBAC, masking, encryption, and secure sharing.
• Design data pipelines integrating cloud, SaaS, and on-premises systems.
• Collaborate with data engineers, analysts, scientists, and business stakeholders to deliver reusable data products.
• Establish enterprise architecture standards, reference models, and best practices.
• Monitor platform health and implement disaster recovery and high-availability strategies.
• Mentor junior architects and engineers while promoting best practices in data modeling and AI-ready architectures.

Should Have:

• Hands-on experience with Snowflake Cortex AI capabilities.
• SnowPro Core, Advanced, or Architect certifications preferred.
• dbt.
• Airflow.
• Kafka.
• Spark.
• Fivetran.
• Matillion.
• Knowledge of AI/ML workflows, vector databases, semantic search, and generative AI integration.
• Experience with Data Vault 2.0, dimensional modeling, or domain-driven design.
• Experience within regulated industries such as finance, healthcare, or pharmaceuticals preferred.

Skills:

• Snowflake Architecture.
• Data Architecture and Modeling.
• AI/ML Data Platforms.
• Snowflake Cortex.
• SQL.
• ETL/ELT Design.
• Cloud Data Platforms.
• Data Governance and Security.
• Performance Optimization.
• Data Warehousing and Lakehouse Design.
• Streaming and Batch Processing.
• Analytics and Business Intelligence.

Qualification and Education:

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or related field required.
• Snowflake certifications preferred.