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."