Sr. Cloud Data Engineer - Snowflake

GEHA; Lee's Summit (MO); Remote; USD 115,000 - 163,000; Full time

Job summary

A leading nonprofit organization in the healthcare sector is seeking a Senior Cloud Data Engineer to develop scalable data solutions in a cloud-native environment. The role involves designing ETL/ELT pipelines, overseeing Snowflake architecture, and collaborating with various stakeholders to ensure efficient data flow and actionable insights. Candidates should have strong expertise in data architectures, particularly with Snowflake, and a background in data analytics or healthcare. This position offers competitive salary and benefits, including health coverage and a 401(k) plan.

Benefits

Health benefits from day one

401(k) with company match

Paid time off

Tuition assistance

Qualifications

• 5-8 years of relevant experience, preferably in healthcare or data analytics.
• Expertise in designing data architectures on Snowflake.
• Proficiency in SQL and experience with complex queries.

Responsibilities

• Design and develop complex ETL/ELT pipelines for data processing.
• Oversee Snowflake architecture and ensure high performance.
• Collaborate with stakeholders to define data requirements.

Skills

SQL

Data Warehouse concepts

Problem-solving

Agile

Communication

Education

Bachelor's degree in computer science

Tools

Snowflake

Python

R

Apache Spark

Job description

GEHA (Government Employees Health Association, Inc., pronounced G.E.H.A.) 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.

Offering one of the largest medical and dental benefit provider networks available to federal employees in the United States, GEHA empowers health and wellness by meeting its members where they are, when they need care. We serve our members with products they value and a personalized customer experience, sustained by a nimble and efficient organization.

Position: Senior Cloud Data Engineer

As a Sr Cloud Data Engineer, you will develop and maintain scalable data pipelines, systems, and platforms in Microsoft Azure, Databricks, and 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 in Data & Analytics activities, aligning with the Enterprise Data strategy, policies, and organizational goals. You will work in a cloud-native environment to design and optimize data solutions that improve the performance, scalability, and efficiency of our data and analytics offerings.

Key Responsibilities:

1. Design and develop complex ETL/ELT pipelines ensuring efficient data flow from multiple sources to Snowflake for processing, storing, analyzing, and consuming large datasets.
2. Design and implement data solutions in Snowflake to support business intelligence, analytics, and data science initiatives.
3. Oversee Snowflake architecture, including data models, schema design, partitioning, clustering, and query optimization for high performance and low cost.
4. Work independently on assigned tasks and lead other data engineers through deployment to production, following change management processes.
5. Participate in architectural discussions, understand data strategy, and provide recommendations for data domain decisions.
6. Perform regular code reviews and ensure best practices are followed.
7. Stay current with emerging cloud technologies and data engineering trends; drive innovation in data architecture and pipelines.
8. Collaborate with stakeholders to define data requirements and implement solutions supporting business goals.
9. Implement data security, governance, and compliance best practices.
10. Automate and monitor data workflows to ensure data integrity and operational reliability.
11. Troubleshoot data pipeline issues, ensuring timely resolution of data and platform performance problems.
12. Follow change management procedures and participate in agile processes including scrum, backlog grooming, and planning.
13. Lead backlog grooming, refinement, and planning meetings as needed.
14. Perform other duties as assigned.

Required Qualifications:

• 5-8 years of relevant experience, preferably within healthcare or data analytics industries.
• Bachelor's degree in computer science, IT, Data Engineering, Mathematics, or related field, or equivalent experience.
• Expertise in designing and implementing data architectures on Snowflake.
• Proven experience as a Cloud Data Engineer, particularly with Snowflake.
• Advanced knowledge of Snowflake, including schema design, performance tuning, and cost optimization.
• Proficiency in SQL and experience with complex queries, stored procedures, and managing large datasets; experience with Python, R, Apache Spark is a plus.
• Strong understanding of Data Warehouse concepts, Data Modeling, database management systems (SQL and NoSQL), and ETL/ELT frameworks.
• Experience with DevOps practices, repositories, Snowflake, and CI/CD pipelines for data deployment.
• Ability to communicate complex technical concepts to non-technical stakeholders and work collaboratively in teams.
• Good understanding of Agile and Scrum methodologies.
• Strong problem-solving skills and experience with root cause analysis for data issues.
• Enthusiasm for learning new technologies and understanding business processes.
• Willingness to learn healthcare and analytics industries if not already familiar.

Preferred Qualifications:

• Snowflake fundamentals certification or similar cloud platform certification.

Work-from-home Requirements:

• Reliable high-speed internet (fiber, DSL, or cable modem) with minimum speeds of 30x5 Mbps and latency below 80 ms.
• A dedicated, interruption-free space to protect sensitive information.
• Hotspots, satellite, and wireless internet services are not permitted.

What We Offer:

• Competitive salary range: $115,287 - $162,513 USD annually.
• Incentive plan, health/vision/dental benefits from day one, 401(k) with company match, employee well-being programs, paid time off, community enrichment time, life and disability insurance, and tuition assistance.

GEHA is an Equal Opportunity Employer and values diversity and inclusion in the workplace.