Technical Architect - Snowflake

Location: Berkeley Heights, New Jersey, United States

Salary: $131,200–$174,975 annually; actual pay varies by education, experience, skills, internal equity, market data, and geographic location.

Company

hirify.global helps life sciences companies modernize commercial data and AI platforms through its AI & Data practice.

What you will do

• Own reference architecture for enterprise commercial data platforms on Snowflake, including ingestion, layered modeling, security, governance, cost controls, and environment strategy.
• Lead migrations from Hadoop, AWS EMR, EKS, Redshift, and similar legacy platforms, including Spark/PySpark refactoring, SQL conversion, parallel runs, reconciliation, and decommissioning.
• Define reusable patterns for IQVIA, Symphony, specialty pharmacy, claims, CRM/Veeva, payer, and MDM data feeds and accelerate new product onboarding.
• Architect data quality, observability, lineage, release gating, orchestration, CI/CD, and infrastructure-as-code capabilities.
• Enable AI-ready semantic and context layers, metadata services, Snowflake Cortex/Snowpark use cases, and agentic operations such as feed monitoring and data-quality triage.
• Lead client architecture forums, governance reviews, roadmaps, cutover planning, executive updates, mentoring, enablement, solutioning, and pre-sales activities.

Requirements

• Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
• 12+ years in data engineering and architecture, including 4+ years designing and delivering enterprise Snowflake solutions.
• Experience leading at least one large-scale migration from Hadoop/EMR, Redshift, or a similar platform to Snowflake.
• Strong SQL, Python/PySpark, dimensional and Data Vault modeling, and ELT experience with dbt.
• Hands-on AWS experience with S3, EMR, EKS, IAM, Glue, and Lambda, including safe decommissioning of legacy components.
• Experience with Airflow, MWAA, or similar orchestration; CI/CD; and Terraform or comparable infrastructure as code.
• Knowledge of data governance, quality, lineage, security, scalability, availability, disaster recovery, auditability, and regulatory compliance in regulated environments.
• Excellent communication skills for explaining architecture trade-offs to senior client stakeholders and engineering teams.

Nice to have

• Pharma or life sciences commercial data experience covering sales, claims, specialty data, customer and product master data, field reporting, or incentive compensation.
• Snowflake Cortex, Snowpark, Streamlit, semantic layers, GenAI, or agentic use-case experience.
• Experience with Monte Carlo, Great Expectations, Soda, or similar data observability tools.
• SnowPro Advanced: Architect or Data Engineer certification; AWS certifications are a plus.
• Experience with onshore/offshore delivery models in a consulting environment.

Culture & Benefits

• Work on commercial data modernization programs in the life sciences industry at the intersection of cloud data platforms, data quality, and AI.
• Collaborate with client data and technology leaders, hirify.global delivery leads, and onshore/offshore engineering teams.
• Salary is adjusted based on applicant qualifications, internal equity, market data, and geographic location.