Technical Architect - Snowflake (1317)
$131.2k - $174.98kAxtria, 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 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
- ...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....SuggestedRemote work
- ...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
- ...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...SuggestedLong term contract
$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...SuggestedFull time$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,...SuggestedFull timeTemporary workH1bWork at officeMonday to Friday- ...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 timeTemporary workWork experience placementLocal area
- ...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 areaRemote workWork from home
$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...- 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
- ...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
- ...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
$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...- ...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 placementLive inWork at officeLocal area
- ...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 placementLive inWork at officeLocal area
- ...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 placementLive inWork at officeLocal areaRemote work
- ...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 inWork at officeLocal area
- ...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 placementLive inWork at officeLocal area
- ...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 placementLive inWork at officeLocal area
- ...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 workWork experience placement3 days per week
$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 timePart timeH1bLocal area$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 timePart timeH1bLocal area$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 placementLocal area$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 payLocal areaRelocation$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 areaVisa sponsorship- ...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
- ...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 workRemote work
$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...- ...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
$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 timeWork at officeLocal areaVisa sponsorshipFlexible hours- ...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 workWork visa
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Technical Architect - Snowflake (1317). Be the first to apply!






