> Markdown version of [/jobs/ext/4690105-technical-architect-snowflake-1317](https://www.wearedevelopers.com/jobs/ext/4690105-technical-architect-snowflake-1317). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Technical Architect - Snowflake (1317) - **Company:** Axtria, Inc. - **Location:** Berkeley Heights, NJ, United States - **Experience:** Experienced - **Salary:** $131,200 - $174,975 - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Application Programming Interfaces (APIs), Artificial Intelligence, Airflow, Amazon Web Services, Amazon S3, Application Frameworks, ARM Architecture, Audit Trail, Microsoft Azure, Cloud Computing, Computer Networks, Continuous Integration, Data Architecture, Data Dictionary, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Security, Data Vault Modeling, Software Design Documents, DevOps, Dimensional Modeling, Disaster Recovery, Github, Apache Hadoop, Identity and Access Management, Python (Programming Language), Metadata, Role-Based Access Control, Power BI, DataOps, Simple Data Format, SQL Stored Procedures, SQL Databases, Data Streaming, Tableau (Software), Data Processing, Macros, Sql Optimization, Great Expectations (Foster Youth College-readiness and Support Program), Large Language Models, Snowflake, Apache Spark, Technical Debt, Generative AI, Amazon Virtual Private Cloud (VPC), Agentic-AI, Git, Data Layers, AI Platforms, Pyspark, Semi-structured Data, Information Technology, Collibra, AWS Glue, Qlikview, Star Schema, Data Management, Dynamic Data, Cloudwatch, Veeva, Streamlit Framework, Terraform, Marketplace, GXP, Legacy Systems, Jenkins, Databricks - **Published:** November 12, 2026 - **Apply:** https://www.careerbuilder.com/job-details/technical-architect-snowflake-1317-berkeley-heights-nj--ea9c6d04-de83-4cda-9913-4f6b66d434e9 ## About the Role Biology, Snowflake Schema, Artificial Intelligence (AI), Cloud Computing, Use Cases, Customer/Client Research, Offshoring, Enterprise Architecture, Data Modeling, Amazon Simple Storage Service (S3), * Bachelor's or Master's degree in Computer Science, Engineering, or a related field. * 12+ years in data engineering and architecture, with 4+ years designing and delivering enterprise solutions on Snowflake. * Proven experience leading at least one large-scale migration from Hadoop/EMR, Redshift, or similar platforms to Snowflake. * Strong command of SQL, Python/PySpark, data modeling (dimensional and Data Vault), and ELT frameworks such as dbt. * Hands-on AWS experience (S3, EMR, EKS, IAM, Glue, Lambda) and an understanding of how to decommission legacy components safely. * Experience with orchestration (Airflow, MWAA, or similar), CI/CD, and infrastructure as code (Terraform). * Solid grounding in data governance, data quality, lineage, and security in regulated environments. * Excellent communication skills, with the ability to explain architecture trade-offs to senior client stakeholders and engineering teams alike., * Pharma or life sciences commercial data experience: sales and claims data, specialty data, customer and product master data, field reporting, incentive compensation. * Experience with Snowflake Cortex, Snowpark, Streamlit, or building semantic layers for GenAI and agentic use cases. * Familiarity with data observability tools (Monte Carlo, Great Expectations, Soda, or similar). * SnowPro Advanced: Architect or Data Engineer certification; AWS certifications are a plus. * Experience working in onshore/offshore delivery models within a consulting environment. ## Description Axtria helps leading life sciences companies modernize their commercial data and AI platforms. Our AI & Data practice is growing its Snowflake capability to support large-scale programs that move legacy cloud and on-premise data stacks to modern, governed, AI-ready commercial data platforms serving brand analytics, field reporting, incentive compensation, and downstream consuming applications. We are looking for a hands-on Technical Architect to own the target-state architecture, lead phased migration programs, and ensure the platform is stable, high-quality, and ready for agentic and GenAI use cases. You will work alongside client data and technology leaders, Axtria delivery leads, and onshore/offshore engineering teams., * Own end-to-end reference architecture for enterprise commercial data platforms on Snowflake, covering ingestion, layered data modeling (raw, curated, consumption), security, cost governance, and environment strategy. * Design and lead migration of workloads from legacy platforms (e.g., AWS S3/EMR/EKS/Redshift, Hadoop) to Snowflake, including Spark/PySpark job refactoring, Redshift SQL conversion, and parallel-run and reconciliation approaches. * Define patterns for onboarding commercial data feeds (IQVIA, Symphony, specialty pharmacy, claims, CRM/Veeva, payer, and MDM outputs), with reusable frameworks that shorten new feed and new product onboarding. * Architect data quality and observability capabilities (rules, anomaly detection, release gating, lineage) in partnership with data governance and data quality teams. * Establish Snowflake best practices for RBAC, secure data sharing, masking and row-level security, warehouse sizing, and FinOps/cost monitoring. * Design orchestration and CI/CD (Airflow or equivalent, dbt, Git-based DevOps, infrastructure as code) for reliable, auditable releases. * Enable AI readiness on the platform: semantic and context layers, metadata and data dictionary services, Snowflake Cortex/Snowpark use cases, and integration points for agentic operations (feed monitoring, change request automation, DQ triage). * Partner with downstream and application teams to plan cutover and minimize disruption to consuming systems and reports. * Act as technical authority in client architecture forums, review boards, and executive updates; produce clear architecture decision records, design documents, and roadmaps. * Mentor engineers and architects across onshore and offshore teams; support change management and Snowflake enablement for client audiences. Technical Skills Snowflake * Snowflake Platform: Deep expertise in Snowflake architecture: virtual warehouses, multi-cluster scaling, micro-partitioning, clustering keys, search optimization, query acceleration, result caching, and Time Travel/Fail-safe. * Ingestion & Processing: Snowpipe and Snowpipe Streaming, Streams and Tasks, Dynamic Tables, external and Iceberg tables, stages, and file formats for batch and near-real-time ingestion. * Sharing & Resilience: Secure data sharing, Data Clean Rooms, Snowflake Marketplace, replication and failover, and cross-region/cross-cloud strategies. * Snowpark & AI: Snowpark (Python/Java/Scala), UDFs/UDTFs, stored procedures, Snowflake Cortex (LLM functions, Cortex Search, Cortex Analyst), and Streamlit in Snowflake. * Security & Governance: RBAC/role hierarchy design, network policies, SSO/SCIM, key-pair auth, dynamic data masking, row access policies, object tagging, and Horizon governance features. * Performance & FinOps: Resource monitors, warehouse right-sizing, query profiling and tuning, workload isolation, and credit consumption chargeback models. Data Engineering * Languages: Advanced SQL (window functions, semi-structured data with VARIANT/FLATTEN), Python, and PySpark; working knowledge of Scala or Java is a plus. * Transformation: dbt (models, macros, tests, snapshots, packages), ELT/ETL design, and tools such as Fivetran, Matillion, Informatica, or AWS Glue. * Orchestration: Apache Airflow/MWAA, Step Functions, or equivalent; dependency management, SLA monitoring, retries, and backfill strategies. * Data Modeling: Dimensional modeling (Kimball), Data Vault 2.0, medallion/layered architectures, slowly changing dimensions, and late-arriving data handling. Cloud, DevOps & Tooling * Cloud: AWS: S3, EMR, EKS, Redshift, Glue, Lambda, IAM, KMS, VPC/PrivateLink, CloudWatch; Azure or GCP exposure is a plus. * DevOps & IaC: Git, GitHub Actions/Jenkins/Azure DevOps, Terraform (including Snowflake provider), schemachange or similar, and environment promotion strategies. * Quality & Observability: Data quality frameworks (Great Expectations, Soda, dbt tests), observability (Monte Carlo or similar), data catalogs and lineage (Alation, Collibra, Atlan, or OpenLineage). * Consumption: Integration with BI and consuming tools such as Tableau, Power BI, Qlik, and downstream applications via APIs and reverse ETL. Architecture Skills * Translate business and analytics requirements into target-state data architectures, logical and physical designs, and phased roadmaps. * Assess current-state platforms, identify technical debt and fragility, and define migration strategies (lift-and-shift, re-platform, re-architect) with clear risk, cost, and timeline trade-offs. * Design for non-functional requirements: scalability, availability, performance SLAs, disaster recovery, security, auditability, and regulatory compliance (HIPAA, GxP, SOX where applicable). * Define reusable reference patterns and accelerators for ingestion, transformation, data quality, metadata, and consumption that teams can adopt consistently. * Establish architecture governance: design standards, architecture decision records (ADRs), review boards, and conformance checks across delivery teams. * Build TCO and cost models, compare platform and tooling options (e.g., Snowflake vs. Databricks, native vs. third-party tools), and present recommendations to senior stakeholders. * Design semantic layers, metadata models, and context layers that make enterprise data usable by BI tools, GenAI applications, and AI agents. * Plan cutover, parallel-run, reconciliation, and legacy decommissioning with minimal disruption to downstream consumers. * Produce clear architecture artifacts (context, component, data flow, and deployment diagrams) and communicate them effectively to both technical and executive audiences. * Guide estimation, solutioning, and proposal responses for new opportunities, contributing to practice growth and pre-sales.