Snowflake / DATA Solution Architect

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Hexaware Technologies, Inc, is seeking the following. Apply via Dice today!What Working at Hexaware Offers:Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profiles. We complete the circle with excellent growth opportunities, chances to collaborate with high-profile customers, opportunities to work alongside brilliant minds, and the perfect work-life balance.Job Title: Data & AI Solution Architect - SnowflakeLocation: McLean, VA /DC AreaWork mode: Hybrid (3 days onsite must)Duration: FTEJob DescriptionThis 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.Key Responsibilities:Strategic planning and hands-on engineering of Snowflake/Big Data and cloud environments that supports our clients advanced analytics and data science initiatives.Provide support in defining the scope and sizing of workWorking closely with various enterprise architects Information security teams, Data management team, to ensure the architected solution meets all the needs of a customer, from a functionality perspective and IT solution engineering perspective.Lead designing all aspects of our data solution including artifact creation such as diagrams, playbooks and other technical documents.Translate business requirements into technology solutionsMentor and guide Jr. team members to deliver the solutions on time.Create various architecture blueprints and work with the development team to deliver the vision.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 SharingData modelling (expert): Data vault 2.0, Kimball dimensional, hybrid schemas; conceptual, logical, and physical design for analytics and AI workloadsdbt (advanced): Core and Cloud; modular transformation layer design, testing frameworks, and CI/CD integration with SnowflakePython / Snowpark (proficient): Custom UDFs, ML pipelines, data transformation logic running natively inside Snowflake computeRAG & GenAI (proficient): End-to-end pipeline design chunking, embedding, vector search, LLM integration, source citation, output validationCloud (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 scaleSecurity & governance: RBAC, dynamic data masking, row-level security, column encryption, private link, SOX / GDPR / HIPAA compliance patternsDevOps & IaC: Git, CI/CD for dbt and Snowflake (GitHub Actions, dbt Cloud), Terraform for infrastructure-as-codeOrchestration: Apache Airflow, Prefect, or Dagster in production dependency management, alerting, and retry patternsPreferred QualificationsSnowPro Core Certification (required within 90 days); SnowPro Advanced: Architect strongly preferredAWS Certified Solutions Architect Professional, Azure Solutions Architect Expert, or Google Cloud Platform Professional Cloud ArchitectExperience with Snowflake Native Apps Framework, Polaris Catalog, Unistore, or open table formats (Iceberg)Familiarity with EU AI Act risk classification, NIST AI RMF, or ISO 42001 governance frameworksConsulting or pre-sales solution architecture experience (client-facing delivery a significant plus)Equal Opportunities Employer:Hexaware Technologies is an equal opportunity employer. We are dedicated to providing a work environment free from discrimination and harassment. All employment decisions at Hexaware are based on business needs, job requirements, and individual qualifications. We do not discriminate based on race including colour, nationality, ethnic or national origin, religion or belief, sex, age, disability, marital status, sexual orientation, parental status, gender reassignment, or any other status protected by law. We encourage candidates of all backgrounds to apply.