← Back to Jobs

Snowflake Solution Architect

OmegaHiresRemote

<b>Key Responsibilities</b><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Architect and implement scalable data warehouse solutions using Snowflake</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Design end-to-end data architectures including ingestion, transformation, storage, and consumption layers</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Develop and optimize data models (dimensional and normalized) to support analytics and reporting use cases</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Lead integration of multiple data sources including commercial, clinical, and third-party vendor data</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Define and implement ETL/ELT pipelines using modern tooling (e.g., DBT, Azure Data Factory, Databricks)</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Establish data governance, security, and data quality frameworks aligned with regulatory requirements</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Optimize Snowflake performance, cost management, and workload scaling strategies</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Collaborate with stakeholders to define data strategy, architecture roadmaps, and platform evolution</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Support downstream analytics, BI (e.g., Power BI), and data science initiatives</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Provide technical leadership and mentorship to data engineering teams</p><p></p><b>Required Qualifications</b><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;10+ years of experience in data architecture, data warehousing, or data engineering</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Experience in life sciences, biotech, or healthcare data (commercial, clinical, RWD, etc.)</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;3+ years of hands-on experience with Snowflake in a solution architecture role</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Strong expertise in SQL and data modeling (dimensional modeling, data vault, etc.)</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Experience designing and implementing cloud-based data platforms (Azure preferred, AWS acceptable)</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Hands-on experience with modern data stack tools (DBT, Databricks, MuleSoft, etc.)</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Experience integrating complex datasets (e.g., transactional, third-party, semi-structured data)</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Strong understanding of data governance, data quality, and security best practices</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Excellent communication skills with ability to interface between business and technical teams</p>&#160;<p><b>Preferred Qualifications</b></p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Familiarity with HCP/HCO, claims, Rx, or clinical trial datasets</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Experience with MDM solutions and customer data integration</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Knowledge of regulatory considerations (e.g., GxP, HIPAA)</p><p>&#183;&#160;&#160;&#160;&#160;&#160; &#160;Snowflake certifications (e.g., SnowPro Core or Advanced)</p>

We use cookies to improve your experience and analyze site traffic. By clicking "Accept", you agree to our use of cookies as described in our Privacy Policy.