Back to Jobs
Recently postedTechnology

Data & AI Solution Architect -- Snowflake

Sage IT IncPA🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationPA, United States
GitAWSEncryptionSnowflakeAirflowApacheBigQueryGDPRGitHub ActionsGoogle CloudHIPAAKafkaLLMPythonTerraformVaultdbtGenerative AIAzureCI/CDRAG

Job description

Job Description This is a hands-on Senior role at the intersection of data engineering, cloud architecture, and generative AI. You will serve as the primary technical authority on our Snowflake Data Cloud strategy - designing scalable, secure, and cost-efficient data platforms that underpin enterprise analytics, operational reporting, and AI-native applications. You will get hands-on with complex architectural problems while influencing direction at the executive level.

Skills & Experience: Overall, 10-15 years of experience in Solution Architecture, Data Management, Data Lake and Lakehouse design and development.

Snowflake (expert): Virtual warehouses, Snowpark, Cortex AI (LLM functions, vector search, Document AI, Cortex Guard), Dynamic Tables, Streams & Tasks, Data Sharing Data modelling (expert): Data vault 2.0, Kimball dimensional, hybrid schemas; conceptual, logical, and physical design for analytics and AI workloads dbt (advanced): Core and Cloud; modular transformation layer design, testing frameworks, and CI/CD integration with Snowflake Python / Snowpark (proficient): Custom UDFs, ML pipelines, data transformation logic running natively inside Snowflake compute RAG & GenAI (proficient): End-to-end pipeline design - chunking, embedding, vector search, LLM integration, source citation, output validation Cloud (advanced in one, working in others): AWS (S3, Glue, Step Functions), Azure (Data Factory, Key Vault, Synapse), Google Cloud Platform (Dataflow, Composer, BigQuery) Data integration: Fivetran, Airbyte, Kafka, Snowpipe - batch and streaming ingestion patterns at enterprise scale Security & governance: RBAC, dynamic data masking, row-level security, column encryption, private link, SOX / GDPR / HIPAA compliance patterns DevOps & IaC: Git, CI/CD for dbt and Snowflake (GitHub Actions, dbt Cloud), Terraform for infrastructure-as-code Orchestration: Apache Airflow, Prefect, or Dagster in production - dependency management, alerting, and retry patterns

Preferred Qualifications SnowPro Core Certification (required within 90 days); SnowPro Advanced: Architect strongly preferred AWS Certified Solutions Architect Professional, Azure Solutions Architect Expert, or Google Cloud Platform Professional Cloud Architect

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs