Snowflake Solution Architect

OmegaHires • ,

3d

About The Position

We are seeking a highly skilled and experienced Snowflake Solution Architect to join our team. In this role, you will be responsible for designing, implementing, and optimizing scalable data warehouse solutions using Snowflake. You will play a key part in shaping our data strategy and architecture, ensuring robust data governance, security, and quality. This position requires strong technical leadership and the ability to collaborate effectively with both business and technical stakeholders.

Requirements

• 10+ years of experience in data architecture, data warehousing, or data engineering
• Experience in life sciences, biotech, or healthcare data (commercial, clinical, RWD, etc.)
• 3+ years of hands-on experience with Snowflake in a solution architecture role
• Strong expertise in SQL and data modeling (dimensional modeling, data vault, etc.)
• Experience designing and implementing cloud-based data platforms (Azure preferred, AWS acceptable)
• Hands-on experience with modern data stack tools (DBT, Databricks, MuleSoft, etc.)
• Experience integrating complex datasets (e.g., transactional, third-party, semi-structured data)
• Strong understanding of data governance, data quality, and security best practices
• Excellent communication skills with ability to interface between business and technical teams

Nice To Haves

• Familiarity with HCP/HCO, claims, Rx, or clinical trial datasets
• Experience with MDM solutions and customer data integration
• Knowledge of regulatory considerations (e.g., GxP, HIPAA)
• Snowflake certifications (e.g., SnowPro Core or Advanced)

Responsibilities

• Architect and implement scalable data warehouse solutions using Snowflake
• Design end-to-end data architectures including ingestion, transformation, storage, and consumption layers
• Develop and optimize data models (dimensional and normalized) to support analytics and reporting use cases
• Lead integration of multiple data sources including commercial, clinical, and third-party vendor data
• Define and implement ETL/ELT pipelines using modern tooling (e.g., DBT, Azure Data Factory, Databricks)
• Establish data governance, security, and data quality frameworks aligned with regulatory requirements
• Optimize Snowflake performance, cost management, and workload scaling strategies
• Collaborate with stakeholders to define data strategy, architecture roadmaps, and platform evolution
• Support downstream analytics, BI (e.g., Power BI), and data science initiatives
• Provide technical leadership and mentorship to data engineering teams

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed