Technical Architect - Snowflake (1317)

Axtria, Inc.•Berkeley Heights, NJ
•$131,200 - $174,975

About The Position

Axtria is seeking a hands-on Technical Architect to own target-state architecture and lead phased migrations to enterprise Snowflake commercial data platforms for life sciences clients. The role focuses on modernizing legacy cloud and on-premise data stacks into stable, governed, high-quality, AI-ready platforms supporting brand analytics, field reporting, incentive compensation, and downstream applications. The architect works with client data and technology leaders, Axtria delivery leads, and onshore/offshore engineering teams. The position owns end-to-end reference architecture across ingestion, data modeling, security, cost governance, and environments; leads migrations from platforms such as AWS S3/EMR/EKS/Redshift and Hadoop; and establishes reusable patterns for commercial data feeds, data quality, orchestration, CI/CD, and governance. It also enables AI and GenAI capabilities through semantic and context layers, metadata services, Snowflake Cortex and Snowpark use cases, and integrations for agentic operations. The role plans cutovers and legacy decommissioning, communicates architecture decisions and roadmaps, mentors teams, and contributes to solutioning and pre-sales. The salary range is $131,200 to $174,975 annually. Actual compensation may vary based on education, experience, skills, abilities, internal equity, market data, and geographic location. The stated range is based on a primary work location of Berkeley Heights, New Jersey.

Requirements

  • Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
  • 12+ years of experience in data engineering and architecture, including 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, dimensional and Data Vault modeling, and ELT frameworks such as dbt.
  • Hands-on AWS experience with S3, EMR, EKS, IAM, Glue, and Lambda, and understanding of safe legacy-component decommissioning.
  • Experience with orchestration such as Airflow or MWAA, CI/CD, and infrastructure as code such as Terraform.
  • Solid grounding in data governance, data quality, lineage, and security in regulated environments.
  • Excellent communication skills and ability to explain architecture trade-offs to senior client stakeholders and engineering teams.
  • Deep Snowflake architecture knowledge, including virtual warehouses, scaling, micro-partitioning, clustering, optimization, caching, and Time Travel/Fail-safe.
  • Knowledge of Snowflake ingestion and processing features, sharing and resilience capabilities, Snowpark and AI features, security and governance, and performance and FinOps practices.
  • Advanced SQL, including window functions and semi-structured data, and Python and PySpark skills.
  • Knowledge of data transformation, orchestration, data modeling, cloud platforms, DevOps and tooling, quality and observability, and BI/consumption integrations as described in the posting.
  • Ability to translate requirements into architecture, assess platforms and migration options, design non-functional capabilities, establish governance, build cost models, plan cutovers, and produce architecture artifacts.

Nice To Haves

  • Pharma or life sciences commercial data experience, including sales and claims data, specialty data, customer and product master data, field reporting, or incentive compensation.
  • Experience with Snowflake Cortex, Snowpark, Streamlit, or semantic layers for GenAI and agentic use cases.
  • Familiarity with data observability tools such as Monte Carlo, Great Expectations, or Soda.
  • SnowPro Advanced: Architect or Data Engineer certification; AWS certifications are a plus.
  • Experience working in onshore/offshore delivery models within a consulting environment.
  • Working knowledge of Scala or Java.
  • Azure or GCP exposure.

Responsibilities

  • Own end-to-end reference architecture for enterprise commercial data platforms on Snowflake, including ingestion, layered modeling, security, cost governance, and environment strategy.
  • Design and lead migration of workloads from legacy platforms such as AWS S3/EMR/EKS/Redshift and Hadoop to Snowflake, including job refactoring, SQL conversion, parallel runs, and reconciliation.
  • Define reusable patterns for onboarding commercial data feeds and new products.
  • Architect data quality and observability capabilities, including rules, anomaly detection, release gating, and lineage, in partnership with governance and quality teams.
  • Establish Snowflake best practices for RBAC, secure sharing, masking, row-level security, warehouse sizing, and FinOps monitoring.
  • Design orchestration and CI/CD approaches using Airflow or equivalent, dbt, Git-based DevOps, and infrastructure as code.
  • Enable AI readiness through semantic and context layers, metadata and data dictionary services, Snowflake Cortex/Snowpark use cases, and agentic operations integrations.
  • Partner with downstream and application teams to plan cutovers and minimize disruption to consuming systems and reports.
  • Serve as technical authority in client architecture forums, review boards, and executive updates; produce architecture decision records, design documents, and roadmaps.
  • Mentor engineers and architects across onshore and offshore teams and support change management and Snowflake enablement for client audiences.
  • Translate business and analytics requirements into target-state architectures, logical and physical designs, and phased roadmaps.
  • Assess current-state platforms, identify technical debt and fragility, and define migration strategies with risk, cost, and timeline trade-offs.
  • Design for scalability, availability, performance SLAs, disaster recovery, security, auditability, and applicable regulatory compliance.
  • Define reusable reference patterns and accelerators for ingestion, transformation, quality, metadata, and consumption.
  • Establish architecture governance through design standards, ADRs, review boards, and conformance checks.
  • Build TCO and cost models, compare platform and tooling options, and present recommendations to senior stakeholders.
  • Design semantic layers, metadata models, and context layers for BI tools, GenAI applications, and AI agents.
  • Plan cutover, parallel-run, reconciliation, and legacy decommissioning with minimal disruption to downstream consumers.
  • Produce architecture diagrams and communicate them to technical and executive audiences.
  • Guide estimation, solutioning, and proposal responses for new opportunities and contribute to practice growth and pre-sales.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service