Sr Snowflake Developer

About IKS Health
IKS Health enables the enhanced delivery of exceptional healthcare for today’s practicing clinicians, medical groups and health systems.

Supporting healthcare providers through every function of the patient visit, IKS Health is a go-to resource for organizations looking to effectively scale, improve quality and achieve cost savings through integrated technology and forward-thinking solutions.

Founded in 2007, we have grown a global workforce of 14,000 employees serving over 150,000 clinicians in many of the largest hospitals, health systems, and specialty groups in the United States.
IKS Health revitalizes the clinician-patient relationship while empowering healthcare organizations to thrive.

We take on the chores of healthcare — spanning administrative, clinical, and operational burdens — so that clinicians can focus on their core purpose: delivering great care.

Combining pragmatic technology and dedicated experts, our solutions enable stronger, financially sustainable enterprises.

By bringing joy and purpose back to medicine, we’re creating transformative value in healthcare and empowering clinicians to build healthier communities.
Summary
We are looking for a Senior Snowflake Developer to design, develop, and optimize cloud-based data warehouse solutions on the Snowflake platform.

The ideal candidate will have a strong background in SQL, data modeling, and performance tuning
Job Responsibilities
• Develop and maintain Healthcare Quality Measure and Reporting software.
• Analyze and tune performance of stored procedures.
• Analyze business requirements and specifications to determine an optimal
development strategy and timeline.
• Participate in Industry Certification activities, particularly annual NCQA HEDIS
certification.
• Provide Quality Measures assistance to Customer Support and Project
Management.
• Provide development assistance to DevOps and QA in cases of job failures or
errors.
• Deploy Healthcare Quality Measure Software.
• Attend Agile meetings (Daily scrum meeting/Sprint planning/Backlog refinement) on
assigned project.
Experience & Skills Required:
3–6 years of experience in data engineering or data warehouse development , with at least 2+ years of hands-on experience in Snowflake .
Strong expertise in SQL and Snowflake-specific features (e.g., Virtual Warehouses, Time Travel, Streams, Tasks).
Expert-level SQL programming with a focus on complex query writing and stored procedure development .
Proven experience in query and performance optimization within Snowflake or similar MPP databases.
Solid understanding of data modeling techniques — Star Schema, Snowflake Schema, and dimensional modeling.
Experience working with cloud ecosystems (AWS, Azure, or GCP) and integrating with Snowflake.
Proficiency in Python or SQL scripting for automation and data transformation is preferred.
Strong analytical, debugging, and performance optimization skills.
Excellent communication and collaboration skills; ability to work effectively in cross-functional teams.
Preferred:
Working experience with HL7 and healthcare interfaces
Working experience with healthcare claims a plus.
Exposure to C# / .NET a plus.
Healthcare Industry knowledge