VP of Intelligence Operations

APN Consulting, Inc. is a progressive IT staffing and services company offering innovative business solutions to improve client business outcomes. We focus on high impact technology solutions in ServiceNow, Fullstack, Cloud & Data, and AI / ML. Due to our globally expanding service offerings we are seeking top-talent to join our teams and grow with us. Title: Snowflake Lead Architect Location: Remote Duration: 6+ Months Contract We are seeking an exceptional Principal Database Engineer to architect and lead our enterprise Snowflake ecosystem as the cornerstone of our PULSE platform modernization. This role will design and implement a secure, multi-tenant data platform that serves multiple departments and workloads across our telehealth organization, while establishing governance frameworks and leveraging cutting-edge Snowflake capabilities to drive inPULSEtion in healthcare analytics and AI. As the technical authority for our Snowflake environment, you will architect a robust platform that balances security, accessibility, and inPULSEtion-enabling teams across the organization to leverage data safely while maintaining HIPAA compliance. You'll work closely with the VP of Data Science to establish our organization as a leader in modern cloud data architecture within the healthcare sector. Key Responsibilities Secure Multi-Tenant Platform Architecture Design and implement enterprise-scale Snowflake architecture supporting multiple departments, business units, and workload types (analytics, data science, operational reporting, AI/ML) within a unified, governed platform Architect logical and physical data isolation strategies using Snowflake databases, schemas, and secure views to enable departmental autonomy while maintaining centralized governance and cost visibility Establish workload separation patterns through virtual warehouse design, resource monitors, and multi-cluster warehouses to ensure performance isolation between production operations, ad-hoc analytics, and ML training workloads Design disaster recovery and business continuity architectures leveraging Snowflake's replication and failover capabilities across Azure regions Create reference architectures for common use cases including clinical analytics, patient insights, operational dashboards, and AI-powered applications Azure-Native Provisioning & RBAC Excellence Develop Infrastructure-as-Code frameworks using Terraform or Azure Bicep for automated Snowflake resource provisioning, ensuring consistent, repeatable, and auditable environment creation Design and implement comprehensive RBAC model that aligns with organizational structure, enabling self-service data access while enforcing least-privilege principles and separation of duties Establish Azure AD integration patterns for seamless single sign-on (SSO) and federated authentication, eliminating password management overhead Create role hierarchies and privilege escalation workflows that support both functional roles (data engineer, analyst, data scientist) and data domain roles (clinical data, billing, patient services) Implement automated provisioning workflows for onboarding new users, departments, and projects with pre-configured access templates and approval processes Design network security architecture including Azure Private Link, service endpoints, and network policies ensuring secure connectivity between Snowflake and Azure services Establish tag-based access control patterns for dynamic, scalable permission management as data assets grow Snowflake Secure Data Sharing & Collaboration Architect internal data sharing strategy enabling seamless, secure data collaboration between departments without data duplication or ETL overhead Design and implement Snowflake Shares for external partner integrations, vendor collaborations, and healthcare data exchange networks Establish data clean rooms for privacy-preserving analytics with external organizations while maintaining HIPAA compliance Create listing management processes for publishing curated data products to internal consumers through share governance Implement reader account strategies for external stakeholders who need access to specific datasets without requiring full Snowflake accounts Design cross-cloud sharing architectures supporting data exchange between Azure Snowflake and partner AWS/Google Cloud Platform environments Snowflake Marketplace Strategy & Implementation Evaluate and integrate third-party datasets from Snowflake Marketplace to enrich internal healthcare analytics (social determinants of health, pharmaceutical data, population health benchmarks) Design procurement and evaluation workflows for marketplace data products, including POC frameworks and cost-benefit analysis Establish governance for external data consumption including data quality validation, refresh monitoring, and usage tracking Create marketplace listing strategy for potential future monetization of anonymized, aggregated healthcare insights (where applicable) Implement Native App Framework for deploying pre-built analytics applications and ML models across the organization Advanced Data Governance & Compliance Implement Snowflake's Universal Search and Tagging to create enterprise-wide data catalog with business glossary, data lineage, and metadata management Design and deploy Object Tagging strategies for automated data classification (PII, PHI, sensitive, public) enabling dynamic access control and compliance reporting Leverage Tag-Based Masking policies to automatically protect sensitive data based on classification, user role, and access context Implement Column-Level Security and Row Access Policies for fine-grained data protection aligned with HIPAA requirements Establish Data Classification framework with automated scanning and tagging of new data assets as they enter the platform Create compliance reporting dashboards using Access History and Query History for audit trails, data lineage, and regulatory reporting Design Data Quality frameworks leveraging Snowflake's data quality functions and monitoring capabilities Implement Horizon Catalog for unified governance across multiple Snowflake accounts and clouds (if multi-account strategy is required) Snowflake Cortex AI Integration Architect AI/ML infrastructure using Snowflake Cortex to enable in-platform machine learning without data movement Implement Cortex LLM functions for natural language processing on clinical notes, patient feedback analysis, and documentation summarization Design Cortex Search capabilities for semantic search across healthcare documentation and knowledge bases Establish Cortex Analyst for natural language query interfaces enabling business users to interact with data conversationally Create ML Feature Stores leveraging Snowflake's native capabilities for centralized feature management and model serving Implement Vector databases using Snowflake's vector data type for similarity search and RAG (Retrieval Augmented Generation) applications Design model deployment patterns for operationalizing ML models directly in Snowflake using Cortex ML Functions Establish responsible AI governance including model versioning, performance monitoring, and bias detection frameworks Snowflake Horizon & Modern Platform Features Implement Snowflake Notebooks for collaborative data science, creating governed environments for Python/SQL development with integrated version control Leverage Streamlit in Snowflake to build and deploy internal analytics applications without separate hosting infrastructure Design Git integration workflows connecting Snowflake development to GitHub/Azure DevOps for version-controlled database objects and data pipeline code Implement Dynamic Tables for simplified incremental data processing and materialized view management, replacing complex streaming table patterns Architect Iceberg Table integration for open format storage enabling multi-engine access to Snowflake-managed data Utilize Snowflake Container Services (if applicable) for deploying custom ML models and applications directly on Snowflake infrastructure Implement Event Tables for enhanced observability, monitoring, and troubleshooting across the platform Leverage Time Travel and Fail-safe enhancements for improved data recovery and historical analysis capabilities InPULSEtion & Continuous Platform Evolution Maintain current expertise on Snowflake's latest releases including recent inPULSEtions in: External volumes with open catalog support, Snowpark optimizations, Polaris Catalog integration, Enhanced UDFs and stored procedures, Advanced Cortex AI capabilities, Improved query optimization features Evaluate and pilot emerging capabilities such as: Native Application Framework for custom app deployment, Cross-cloud Auto-Fulfill for simplified data sharing, Advanced data clean room capabilities, Improved cost management and optimization tools Design POC frameworks for rapidly testing new Snowflake features and assessing organizational fit Lead technical inPULSEtion discussions at Architecture Review Board, proposing adoption of new capabilities aligned with business value Build relationships with Snowflake account team and solution architects to gain early access to preview features and beta programs Required Qualifications Snowflake Platform Expertise 10+ years database engineering with 5+ years architecting enterprise Snowflake environments at scale Expert knowledge of Snowflake architecture including virtual warehouses, storage layers, metadata services, and cloud services layer Deep experience with Azure Snowflake deployment including Private Link, managed identity, Azure AD integration, and cross-service connectivity Proven track record architecting multi-tenant platforms serving diverse workloads and organizational units with robust isolation and governance Advanced RBAC design and implementation including role hierarchies, privilege management, and access automation Production experience with Snowflake Shares for both internal and external data collaboration Hands-on expertise with modern Snowflake features including Dynamic Tables, Iceberg integration, Notebooks, Streamlit, and Git integration Working knowledge of Snowflake Cortex AI capabilities and practical ML use cases Infrastructure & Automation Infrastructure-as-Code proficiency using Terraform, Snowflake's Terraform provider, or Azure Bicep for automated provisioning Azure cloud platform expertise including networking, security services, identity management, and service integration patterns CI/CD pipeline development for database deployments using Azure DevOps, GitHub Actions, or similar platforms Python and SQL mastery for automation, data quality validation, and administrative scripting Governance & Security Healthcare data compliance expertise with deep understanding of HIPAA, PHI protection, and healthcare data privacy requirements Data governance framework design including cataloging, lineage, classification, and policy enforcement Security architecture experience encompassing data encryption, network isolation, audit logging, and threat modeling Experience implementing Tag-Based policies for automated data protection and dynamic access control Leadership & Strategy Demonstrated thought leadership in modern data architecture and platform engineering Proven ability to translate business requirements into technical platform capabilities Experience presenting to Architecture Review Boards and executive stakeholders Track record mentoring technical teams on advanced Snowflake capabilities and best practices Strong documentation skills creating architecture decision records, design patterns, and operational runbooks Preferred Qualifications SnowPro Core Certification (required) with SnowPro Advanced Architect or Data Engineer (strongly preferred) Azure Data Engineer Associate or Solutions Architect certification Experience with Snowflake Marketplace data product integration and evaluation Snowflake Cortex AI implementation for production use cases including LLMs and vector search Healthcare or telehealth platform architecture experience Master Data Management platform migration experience (particularly from IBM InfoSphere MDM) Familiarity with Verato MDM or similar healthcare identity resolution platforms Experience with dbt Cloud and modern data transformation frameworks integrated with Snowflake Knowledge of Polaris Catalog and open table format strategies Background in data monetization or data product development We are committed to fostering a diverse, inclusive, and equitable workplace where individuals from all backgrounds feel valued and empowered to contribute their unique perspectives. We strongly encourage applications from candidates of all genders, races, ethnicities, abilities, and experiences to join our team and help us build a culture of belonging. For applications and inquiries, contact: hirings@openkyber.com