Snowflake Data Architect

Location

Across United States

Salary

Not specified

Company

Akash pawar

Job description

Role & Company / Project Overview: We are seeking an experienced Snowflake Data Architect with strong expertise in Data Engineering, Data Warehousing, and Healthcare Data Modeling to design and oversee robust enterprise data solutions. Key Responsibilities & Daily Duties: • Design and own end-to-end Snowflake architecture, including staging, curated, and conformed data layers. • Develop dimensional models using Star Schema, SCD Type 2, and historical data management. • Design patient/member identity, crosswalk, and entity-resolution models supporting MPI logic. • Build payer attribution, member-month, provider network, PCP, and clinic data models. • Establish data quality, reconciliation, schema validation, and referential integrity controls. • Define architecture standards, exception handling, and data monitoring processes. Required Qualifications, Skills & Experience: • 10+ years of experience in Data Engineering, Data Warehousing, or Analytics. • 5+ years of experience in Data Architecture / Solution Architecture. • Strong hands-on experience with Snowflake and advanced SQL. • Deep expertise in dimensional modeling and data warehouse architecture. • Healthcare payer/member data modeling experience is highly preferred. • Eligible Visa Status: Green Card (GC), US Citizen (USC), or H1B. Working Hours, Shifts & Location Details: • Location: United States (Specific city not specified). Application Instructions: Interested candidates should submit their updated resumes along with their LinkedIn profiles and current visa status for consideration.