NuStar Technologies ยท 1 day ago
Snowflake Solution Architect
Baltimore, MD
Full-time
Onsite
Senior Level
$160K/yr - $180K/yr
5+ years expNuStar Technologies is seeking a Snowflake Solution Architect to design and manage data pipelines and enable AI/ML integration. The role involves collaborating with AI and Data teams, ensuring data governance, and optimizing performance across Snowflake environments.
AnalyticsConsultingEnterprise Resource Planning (ERP)IT ManagementStaffing Agency
Responsibilities
Design and manage data pipelines using dbt, Airflow, and CI/CD frameworks
Implement Snowpipe for continuous ingestion, Streams & Tasks for real-time processing
Enable AI/ML integration: Support predictive analytics and generative AI use cases
Leverage Snowflake Cortex and Copilot for LLM-based applications
Ensure data governance, RBAC, and security compliance across Snowflake environments
Optimize performance and implement Time Travel, Zero Copy Cloning, and Secure Data Sharing
Build production-ready AI applications and LLM-powered features
Collaborate with AI + Data teams to develop agentic AI workflows
Experiment with open-source models and translate prototypes into production systems
Implement RAG pipelines, fine-tuning, and observability for AI models
Design and deploy secure, scalable, and highly available architectures on AWS
Select appropriate AWS services for application design and deployment
Implement cost-control strategies and disaster recovery plans
Collaborate with teams to integrate systems and ensure compliance
Develop Infrastructure as Code (IaC) using Terraform or CloudFormation
Design, build, and maintain data pipelines using dbt for analytics and operational use cases
Implement standards for data quality, consistency, and reliability
Optimize query performance and manage compute costs
Collaborate with analysts and stakeholders to understand data requirements
Build automation into workflows and ensure compliance with governance policies
Qualification
Required
Snowflake expertise: Warehouses, databases, roles, RBAC, SCIM, MFA
Data Engineering: ELT/ETL tools (dbt, Talend), orchestration (Airflow)
Cloud Platforms: AWS, Azure, or GCP with Snowflake integration
Programming: SQL, Python; familiarity with ML frameworks
Security & Compliance: Data masking, encryption, audit processes
Strong experience with LLMs (OpenAI, Anthropic, Hugging Face, LangChain)
Proficiency in Python and modern AI frameworks
Familiarity with vector databases, prompt engineering, and AI best practices
5+ years of product-focused engineering experience
Knowledge of cloud deployment and scaling AI systems
Strong SQL and Python skills
Hands-on experience with dbt and Snowflake
Familiarity with cloud platforms (AWS )
Knowledge of CI/CD, DevOps practices, and data orchestration tools (Airflow, Prefect)
Ability to create lineage graphs, documentation, and validation frameworks
Preferred
snowflake
Cortex AI
AWS
DBT
Benefits
Legal Assistance
401K Plan
Performance Bonus
College Fund
Student Loan Refinancing
Company
NuStar Technologies
NuStar Technologies provides staffing, recruiting, cloud enablement, ERP implementation, analytics, web solution, and managed services.
11-50 employees
H1B Sponsorship
NuStar Technologies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2023 (3)
2022 (1)
2020 (3)
Funding
Current Stage
Early StageCompany data provided by crunchbase