Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Technical Architect - Snowflake (1317)

$131.2k - $174.98k

Axtria, Inc.

Job Description

Job Description

About the Role

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.

Key Responsibilities

  • 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.

Required Qualifications

  • 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.

Preferred Qualifications

  • 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.

Why Axtria

You will shape high-impact commercial data modernization programs in the life sciences industry, working at the intersection of cloud data platforms, data quality, and AI, with a team that brings deep, long-standing domain expertise.

Pay Transparency Laws 
Salary range or hourly pay range for the position 

The salary range for this position is $131,200 to $174,975 annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant’s geographic location. 

The salary range reflected is based on a primary work location of Berkeley Heights, New Jersey. The actual salary may vary for applicants in a different geographic location. 

Powered by JazzHR

nIybohBu4o

Vacancy posted 5 days ago
Similar jobs that could be interesting for youBased on the Technical Architect - Snowflake (1317) in Berkeley Heights, NJ vacancy
  •  ...techniques. Ability to simplify complex problems and communicate technical concepts to a diverse audience. Preferred Skills:...  ...modeling and wrangling techniques and tools, including Star Schema, Snowflake Schema, Data Vault, Alteryx, Power BI, Tableau, etc.... 
    Suggested
    Remote work

    Axelon Services Corporation

    East Hanover, NJ
    19 days ago
  •  ...Ability to simplify complex problems and effectively communicating technical concepts to a diverse audience. More about this role...  ...modelling and wrangling techniques and tools i.e., Star Schema, Snowflake Schema, Data vault, Alteryx, Power BI, Tableau, etc. Data quality... 
    Suggested

    TTI of USA, Inc.

    East Hanover, NJ
    21 days ago
  •  ...Role: Agentic AI -Solution Architect (FDE) Location: Berkeley Heights, NJ (5 days Onsite) Duration: Long term contract Must have...  ...artifacts including requirements, design documents, code, and technical specifications. Review and validate AI-generated test... 
    Suggested
    Long term contract

    Delta System & Software, Inc.

    Berkeley Heights, NJ
    1 day ago
  • $110k - $125k

     ...Job Description Job Description Position: Technical Architect (DevOps) Location: Morristown, NJ (Onsite) Duration: Full-time Salary Range: $110,000-$125,000/Annum Job Description: Summary: Havey Azure, DevOps with AwS Exp. Must Have Technical/Functional... 
    Suggested
    Full time

    Diverse Lynx

    Morristown, NJ
    10 days ago
  • $145k - $240k

     ...global scale, come make a difference at Fiserv. Job Title Data Architect About your role: At Fiserv, we are dedicated to transforming...  ...business stakeholders to design modern cloud data platforms, set technical standards, and ensure our data products meet quality,... 
    Suggested
    Full time
    Temporary work
    H1b
    Work at office
    Monday to Friday

    Fiserv

    Berkeley Heights, NJ
    1 day ago
  •  ...Principal, Business Consulting -Solution Architect The vision of the Data &Analytics team...  ...manage data product roadmaps while providing technical leadership and solution architecture...  ...Platforms & Tools: Amazon, Google, Microsoft, Snowflake, Databricks. ., Managed Lakehouse... 
    Full time
    Temporary work
    Work experience placement
    Local area

    Infosys Technologies

    Basking Ridge, NJ
    11 hours ago
  •  ...Presales Solutions Architect (Channel) - NJ This role has been designated as 'Remote/Teleworker', which means you will primarily work...  ...are seeking a Channel Presales Solutions Architect to drive technical enablement and solution design with our strategic partner ecosystem... 
    Local area
    Remote work
    Work from home

    Hewlett Packard Enterprise Development LP

    Berkeley Heights, NJ
    1 day ago
  • $180k - $190k

     ...support Agile/Scrum development, DevOps and CI/CD Design and architect modular and reusable automated testing solutions that satisfy...  ...of envisioned processes Ability to assess functional and technical gaps in designs Support continuous improvement processes, analyzing... 

    ApTask

    Berkeley Heights, NJ
    19 days ago
  • Role : AI/ML Developer with Python Location : Berkeley Heights, NJ (All 5 days Onsite – Local’s Preferred) Specification: Design, train, and evaluate ML models Perform feature engineering and data preprocessing Deploy models to production with MLOps practices...
    Local area

    OJUS LLC

    Berkeley Heights, NJ
    1 day ago
  •  ...Job Description Role: Agentic AI -Solution Architect (FDE) Location: Berkeley Heights, NJ (5 days Onsite) Duration: Long term...  ...artifacts including requirements, design documents, code, and technical specifications. Review and validate AI-generated test designs... 
    Long term contract

    Delta System & Software, Inc.

    Berkeley Heights, NJ
    3 days ago
  •  ...data quality checks Required Skills Strong experience with Python, SQL, Git/GitLab Hands-on expertise with MLflow, Snowflake, Power BI Experience in API development (FastAPI / Flask) Solid understanding of OLAP/OLTP data modeling and architecture... 
    Contract work

    Equiliem

    Morristown, NJ
    16 minutes ago
  • $180k - $190k

     ...support Agile/Scrum development, DevOps and CI/CD Design and architect modular and reusable automated testing solutions that satisfy...  ...of envisioned processes Ability to assess functional and technical gaps in designs Support continuous improvement processes, analyzing... 

    ApTask

    Berkeley Heights, NJ
    21 days ago
  •  ...impacts millions of lives every day. We turn ideas into reality.You are:A highly experienced Blue Yonder (JDA/RedPrairie) WMS Technical Architect with deep expertise in designing, architecting, and implementing large-scale Warehouse Management and Supply Chain Execution... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Morristown, NJ
    1 day ago
  •  ...deepest AWS expertise, including more than 1,500 AWS-certified architects who serve as the AWS SWAT team for the most complex and...  ...Accenture AWS Cloud Services You are We are looking to expand our AWS Technical Architect team with talented professionals who have a passion... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Morristown, NJ
    1 day ago
  •  ...operations across manufacturing, warehousing, logistics, engineering and other asset-intensive environments.The Work:The Robotics Technical Architect is the senior technical authority responsible for defining the architecture, integration, deployment and scaling of robotics... 
    Work experience placement
    Live in
    Work at office
    Local area
    Remote work

    Accenture

    Morristown, NJ
    1 day ago
  •  ...rely on you to create and communicate the detailed technology architecture and implementation strategy for the solution? If leading technical teams through the integration and development of underlying Commerce and Product Information Management systems sounds like a... 
    Live in
    Work at office
    Local area

    Accenture

    Morristown, NJ
    1 day ago
  •  ...experts and supports Accenture’s more than 1,500 certified AWS architects across the company. Join our team and be among Accenture’s...  ...solution workshops, and RFP/RFI responses to articulate Accenture's technical vision and differentiated capabilities.Provide hands-on... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Morristown, NJ
    1 day ago
  •  ...enterprise for greater speed, agility and efficiency, all delivered at scale.Learn more about ServiceNow at Accenture HereYou AreAs a Technical Architect with the ServiceNow Business Group you are an experienced innovator of new applications in ServiceNow. You can architect... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Morristown, NJ
    1 day ago
  •  ...Job Description Job Description Position: Data Architect Onsite: 3 days a week Location: irving, Texas Contract: 6 months...  ...needs. Key Responsibilities Design principles and prepare technical and infrastructure architecture deliverables. Participate... 
    Contract work
    Work experience placement
    3 days per week

    Expert In Recruitment Solutions

    Summit, NJ
    21 days ago
  • $197.3k - $225.1k

     ..., implementing, and scaling production-ready data pipelines for training and evaluating ML models. ~1+ years of experience as a technical lead developing ML solutions using industry best practices, patterns, and automation ~ Authored/co-authored a paper on a ML technique... 
    Full time
    Part time
    H1b
    Local area

    Capital One

    New Providence, NJ
    1 day ago
  • $197.3k - $225.1k

     ..., implementing, and scaling production-ready data pipelines for training and evaluating ML models. ~1+ years of experience as a technical lead developing ML solutions using industry best practices, patterns, and automation ~ Authored/co-authored a paper on a ML technique... 
    Full time
    Part time
    H1b
    Local area

    Capital One

    Summit, NJ
    1 day ago
  • $141k - $278k

    Position Summary Salesforce Life Sciences Lead Technical ArchitectOur Deloitte Sales & Service team empowers organizations to build...  ...scientists, operators, creatives, designers, engineers, and architects. Our team balances business strategy, technology, creativity,... 
    Work experience placement
    Local area

    Deloitte

    Morristown, NJ
    2 days ago
  • $110k - $155k

     ...transformation, modern engineering, and technical empowerment. We aren't just manufacturing...  ...our global supply chain.As our Data Architect, you are a hands-on technical driver who...  ...technical blockers across Python, SQL, Snowflake, and dbt pipelines.Perform GitHub PR reviews... 
    Hourly pay
    Local area
    Relocation

    Colgate-Palmolive

    Piscataway, NJ
    4 days ago
  • $134.5k - $265.1k

    Position Summary As a MarTech Multi-Solution Architect, you will be the connective tissue across our clients’ marketing and advertising...  ...across composable, API-first MarTech and AdTech stacksLeading technical pre-sales and solutioning (hunter/farmer cycles), translating... 
    Local area
    Visa sponsorship

    Deloitte

    Morristown, NJ
    4 days ago
  •  ...building something exciting. We're expanding our Atlassian and AI consulting practice and looking for a passionate, technically strong Solutions Architect who loves solving complex problems, working with customers, and turning innovative ideas into real-world solutions.... 
    Remote work

    ANB Technologies

    Iselin, NJ
    27 days ago
  •  ...Role: Lead Solution Architect Location: Remote Contract Position . Key Performance Indicators · Technical win rate and contribution to closed contract value on strategic US GPUaaS pursuits · Size and complexity of deals shaped (committed capacity, multi-year... 
    Contract work
    Remote work

    Astir IT Solutions, Inc.

    South Plainfield, NJ
    12 days ago
  • $140k - $160k

     ...The Role We are looking for a Senior Integration Solution Architect to design, develop and deliver integration solutions connecting...  ...procurement SaaS platforms and ERP/non-ERP systems, accounting for technical architecture, data flows and application configuration... 

    GEP Worldwide

    Clark, NJ
    5 days ago
  •  ...Role Overview: We are seeking an Oracle Fusion HCM Solutions Architect/SME with 13+ years of implementation experience who can be...  ...ideal candidate will bridge the gap between HR business needs and technical capabilities, ensuring seamless delivery of benefits processes... 
    Full time

    Donyati

    Piscataway, NJ
    13 days ago
  • $153k - $193.8k

     ...shape who you are. Position Overview This role sets the technical direction for the Price Optimization business unit's unified platform...  ...performance, and experience consistency across solutions. Architect integrations across internal platforms, partner ecosystems,... 
    Full time
    Work at office
    Local area
    Visa sponsorship
    Flexible hours

    Zelis

    Convent Station, NJ
    1 day ago
  •  ...the autonomy to reach your goals. EisnerAmper is seeking multiple AI Solution Architects who will serve as lead developers on the EisnerAI Platform, designing and implementing the technical architecture that powers EisnerAmper's intelligent solutions across tax, audit,... 
    Remote work
    Work visa

    EisnerAmper

    Woodbridge, NJ
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Technical Architect - Snowflake (1317). Be the first to apply!