Technical Architect - Snowflake (1317)
Axtria, Inc.23 hours ago
Berkeley Heights, NJ, USAStaff+
Base Salary
$131k - $175k/yr
Responsibilities
- Own reference architectures for enterprise commercial data platforms on Snowflake, including ingestion, layered data modeling, security, cost governance, and environment strategy.
- Lead migrations from legacy Hadoop, AWS, EMR, EKS, Redshift, and similar platforms to Snowflake, including job refactoring, SQL conversion, parallel runs, reconciliation, and legacy decommissioning.
- Design reusable patterns for data feeds, transformation, data quality, observability, metadata, lineage, semantic layers, and downstream consumption.
- Establish Snowflake practices for RBAC, secure sharing, masking, row-level security, warehouse sizing, performance, resilience, and FinOps.
- Design orchestration, CI/CD, infrastructure-as-code, release governance, monitoring, retries, and backfill strategies.
- Enable AI-ready and agentic use cases through Snowflake Cortex, Snowpark, Streamlit, semantic and context layers, metadata services, and operational integrations.
- Partner with client leaders and downstream application teams on requirements, cutover planning, architecture reviews, roadmaps, and disruption minimization.
- Produce architecture decision records, design documents, diagrams, cost models, and recommendations for technical and executive audiences.
- Mentor onshore and offshore engineers and architects, support Snowflake enablement and change management, and contribute to solutioning and pre-sales proposals.
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 Snowflake solutions.
- Experience leading at least one large-scale migration from Hadoop, EMR, Redshift, or a similar platform to Snowflake.
- Strong SQL, Python, PySpark, data modeling, Data Vault, dimensional modeling, and dbt experience.
- Hands-on AWS experience with S3, EMR, EKS, IAM, Glue, and Lambda, including safe decommissioning of legacy components.
- Experience with Airflow or MWAA, CI/CD, Terraform, data governance, data quality, lineage, and security in regulated environments.
- Excellent communication skills and ability to explain architecture trade-offs to senior stakeholders and engineering teams.
- Preferred: life sciences commercial data experience involving sales, claims, specialty, customer, product master, field reporting, or incentive compensation data.
- Preferred: Snowflake Cortex, Snowpark, Streamlit, semantic layers for GenAI or agentic use cases, and data observability tools such as Monte Carlo, Great Expectations, or Soda.
- Preferred: SnowPro Advanced Architect or Data Engineer certification, AWS certifications, and experience in consulting onshore/offshore delivery models.
Benefits
- The role focuses on high-impact commercial data modernization programs at the intersection of cloud data platforms, data quality, and AI.
- The stated salary range is $131,200 to $174,975 annually, with variation based on qualifications, internal equity, market data, and geographic location.
- The salary range is based on a primary work location of Berkeley Heights, New Jersey, and may vary for other locations.
Tech Stack
Amazon RedshiftApache AirflowApache HadoopApache SparkAWSAzureDatabricksdbtGitGitHub ActionsGoogle Cloud PlatformInformaticaJavaJenkinsPythonScalaSnowflakeSQLTerraform
Categories
Data Engineering
About Axtria, Inc.
Axtria builds cloud software and analytics used by life sciences companies to manage data, sales operations, incentive compensation, and commercial analytics. Its platforms include Axtria DataMAx, SalesIQ, InsightsMAx, and CustomerIQ, which support the product commercialization process from data to insights to action. Founded in 2010 and headquartered in Berkeley Heights, NJ, the company is privately held with customers across more than 75 countries.