Snowflake Architect with Lakehouse, Microsoft Fabric and Iceberg

Overview

Remote
Accepts corp to corp applications
Contract - Long Term

Skills

health OR Healthcare
DBT
Lakehouse
Iceberg
Microsoft Fabric

Job Details

Hi Professionals,

Title: Snowflake Architect
Location: Remote

Duration: Long Term

JD:

What is in it for you?

Design and optimize Snowflake-based Lakehouse solutions to support the migration of clinical and claims data from Sailfish. This role focuses on data modeling, ingestion, and performance optimization across the medallion architecture.

Responsibilities: -

  • Design scalable Snowflake schemas and data models for Bronze, Silver, and Gold layers using Iceberg.
  • Develop and optimize Snowpipe-based ingestion pipelines for real-time and batch data from on-prem Event Hubs.
  • Implement data transformation logic and metadata-driven frameworks for structured and semi-structured data.
  • Enable DirectQuery, virtualization, and mirroring strategies for seamless integration with Microsoft Fabric.
  • Collaborate with data engineers and analytics teams to ensure data readiness for reporting and AI/ML use cases.

Experience: -

  • 15+ Years

Location: -

  • This role is remote-friendly. Candidates must reside in or be authorized to work in the United States.

Skills: -

  • 10+ years in data architecture with 3+ years in Snowflake.
  • Hands-on experience with Snowpipe, Iceberg, and medallion architecture.
  • Proficiency in SQL, DBT, and performance tuning in Snowflake.
  • Familiarity with Microsoft Fabric, OneLake, and data virtualization techniques.
"Disclaimer: E-Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability."

Snowflake Architect with Lakehouse, Microsoft Fabric and Iceberg1health OR Healthcare,DBT,Lakehouse,Iceberg,Microsoft FabricN/AC2CUnited States
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.