Cloud Data Engineer - Snowflake

GEHA • Lee's Summit, MO

91d • $94,039 - $132,561 • Hybrid

About The Position

GEHA (Government Employees Health Association, Inc.) is a nonprofit member association that provides medical and dental benefits to more than two million federal employees and retirees, military retirees and their families. We celebrate diversity and are committed to creating an inclusive environment for all employees. GEHA has one mission: To empower federal workers to be healthy and well. As a Cloud Data Engineer, you will be developing and maintaining scalable data pipelines in Snowflake. You will collaborate with business data analysts, data architects, data scientists, project managers, and G.E.H.A's business stakeholders to build solutions that ensure seamless data flow and enable actionable insights. This role supports data development and maintenance efforts of the Data & Analytics activities and initiatives in alignment with the Enterprise Data strategy, policies, and organizational goals. This role will work in a cloud-native environment to design and optimize data solutions that improve performance, scalability, and efficiency of our data and analytics offerings.

Requirements

• 3-5 years of relevant technical or business work experience with demonstrated experience within healthcare industry or data and analytics.
• Bachelor's degree in computer science, Information Technology, Data Engineering, Mathematics, or a related field or comparable experience.
• Direct experience with Snowflake (preferred) or an equivalent cloud data platform.
• Proficiency in SQL and valuable experience with writing complex queries, stored procedures, and managing large datasets.
• Solid understanding of Data Warehouse concepts, database management systems (SQL and NoSQL), and ETL/ELT frameworks.
• Competent SQL skills or equivalent such as Python, R, Apache Spark.
• Familiarity with DevOps practices, Repos, Snowflake, and CI/CD pipelines for data solutions.
• Ability to work in a collaborative, cross-functional team environment and communicate complex technical concepts to non-technical stakeholders.
• Good understanding of Agile and Scrum processes.
• Experience & eagerness for problem solving and root cause analysis for any issues.
• Enthusiastic to learn innovative technologies & techniques.

Nice To Haves

• Preferred fundamentals certification in Snowflake or comparable cloud platform or technology.

Responsibilities

• Develop scalable, efficient, and secure ETL/ELT pipelines for ingesting, processing, storing, and consuming large datasets in Snowflake.
• Design and implement data solutions on Snowflake to support analytics, business intelligence, and data science initiatives.
• Use enterprise approved ETL/ELT tools and methodologies to automate data ingestion and transformation from various sources into Snowflake.
• Work closely with cross-functional teams to define data requirements and implement data solutions that support documented and approved business goals.
• Work independently on assigned stories/tasks and deploy data solution through environments to Production using the approved Change Management process.
• Implement data solutions that follow best practices and the company policies to ensure data privacy, security, and compliance.
• Implement and manage automated monitoring and logging for all data workflows and pipelines to ensure data integrity and operational reliability.
• Troubleshoot issues with data pipelines, data integrity, and platform performance, providing timely resolutions to business-critical data needs.
• Ensure that all deliverables follow the company Change Management process.
• Participate in scrum, backlog grooming, refinement, planning and review sessions.
• Other duties as assigned.

Benefits

• Competitive pay/salary ranges
• Incentive plan
• Health/Vision/Dental benefits effective day one
• 401(k) retirement plan: company match - dollar for dollar up to 4% employee contribution plus a 6% annual company contribution
• Robust employee well-being program
• Paid Time Off
• Personal Community Enrichment Time
• Company-provided Basic Life and AD&D
• Company-provided Short-Term & Long-Term Disability
• Tuition Assistance Program

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Insurance Carriers and Related Activities
• Education Level: Bachelor's degree
• Number of Employees: 1,001-5,000 employees