Snowflake Data Engineer

Job Description

The Data Engineer is responsible for building and maintaining Snowflake ingestion pipelines, closing data gaps between sandbox and production environments, and supporting AI agent development within Snowflake’s Cortex/Coco ecosystem. This is a 6-month contract with potential extensions. This can sit remotely.

Key Responsibilities

• Build, configure, and maintain Snowpipes for automated ingestion from S3 and other sources
• Ensure accurate movement of data through EDW layers (raw → conform → production)
• Reconcile discrepancies between sandbox and production datasets
• Partner with analytics teams to enforce proper EDW governance and deployment processes
• Support integration work for new data sources, transformations, and stored procedures
• Assist in building and training AI agents within Snowflake/Cortex
• Improve reliability, consistency, and quality of data pipelines across the organization

Skills and Requirements

• 4–8+ years as a Data Engineer
• Deep experience with Snowflake, Snowpipes, and cloud-based ingestion patterns
• Strong SQL and stored procedure experience
• Experience with AWS Lambda
• Familiarity with DBT (nice-to-have but common)
• Understanding of AI agent concepts and LLM-driven workflows
• Ability to collaborate with analytics teams and enforce proper data governance
• Healthcare data experience (EMR, HIE, claims, clinical data)
• Experience with Snowflake Cortex/Coco agent development
• Experience with 5Tran or similar ingestion tools (legacy familiarity)

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.