Cloud Data Engineer Snowflake

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.

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 cloudnative environment to design and optimize data solutions that improve performance, scalability, and efficiency of our data and analytics offerings.

SKILLS

Key Responsibilities:

• Proven experience as a Cloud Data Engineer or similar role, specifically working with Azure or Snowflake.
• Design and Build Data Pipelines: Develop scalable, efficient, and secure ETLELT pipelines for ingesting, processing, storing, and consuming large datasets in Snowflake.
• Cloud Data Architecture: Design and implement data solutions on Snowflake to support analytics, business intelligence, and data science initiatives.
• Data Integration & Transformation: Use enterprise approved ETLELT tools and methodologies to automate data ingestion and transformation from various sources into Snowflake.
• Collaborate with Stakeholders: Work closely with crossfunctional teams, including business data analysts, data architects, data scientists, project managers and business units, to define data requirements and implement data solutions that support documented and approved business goals.
• With minimal guidance, work independently on assigned storiestasks and deploy data solution through environments to Production using the approved Change Management process.
• Data Security, Governance & Compliance: Implement data solutions that follow best practices and the company policies to ensure data privacy, security, and compliance with relevant governance in the cloud environment.
• Automation and Monitoring: Implement and manage automated monitoring and logging for all data workflows and pipelines to ensure data integrity and operational reliability.
• Troubleshooting and Support: Troubleshoot issues with data pipelines, data integrity, and platform performance, providing timely resolutions to businesscritical 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.

• Required Qualifications:

  • Requires 35 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 ETLELT frameworks, ideally in Snowflake or equivalent data platform.
  • Competent SQL skills or equivalent such Python, R, Apache Spark etc.
  • Familiarity with DevOps practices, Repos, Snowflake, and CICD pipelines for data solutions.
  • Ability to work in a collaborative, crossfunctional team environment and communicate complex technical concepts to nontechnical 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; eagerness towards understanding data & business processes to contribute & have influence.
  • Ability to work collaboratively in a team environment.
  • Prior knowledge or willingness to learn healthcare and analytics industries

  • Preferred Qualifications:

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

    • Workathome requirements

      • Must have the ability to provide a noncellular High Speed Internet Service such as Fiber, DSL, or cable Modems for a home office.
      • A minimum standard speed for optimal performance of 30x5 (30mpbs download x 5mpbs upload) is required.
      • Latency (ping) response time lower than 80 ms
      • Hotspots, satellite and wireless internet service is NOT allowed for this role.
      • A dedicated space lacking ongoing interruptions to protect member PHI HIPAA information

      • How we value you

        • Competitive paysalary ranges
        • Incentive plan
        • HealthVisionDental benefits effective day one
        • 401(k) retirement plan: company match – dollar for dollar up to 4% employee contribution (pretax or Roth options) plus a 6% annual company contribution
        • Robust employee wellbeing program
        • Paid Time Off
        • Personal Community Enrichment Time
        • Companyprovided Basic Life and AD&D
        • Companyprovided ShortTerm & LongTerm Disability
        • Tuition Assistance Program

        • While this is a remote opportunity, at this time GEHA does not hire employees from U.S. territories or the following states: Alaska, Hawaii, California, Washington, Oregon, Colorado, Wyoming, Montana, New York, Connecticut, Vermont, Pennsylvania, Maine.

          Please note that the salary information is a general guideline only. GEHA considers factors such as (but not limited to) scope and responsibilities of the position, candidate’s work experience, educationtraining, key skills, internal peer equity, as well as, market and business considerations when extending an offer.

          The annual base salary range for this position is $94,039 $132,561 USD.

          GEHA is an Equal Opportunity Employer, which means we will not discriminate against any individual based on sex, race, color, national origin, disability, religion, age, military status, genetic information, veteran status, pregnancy, marital status, gender identity, and sexual orientation, as well as all other characteristics and qualities protected by federal, state, or local law. GEHA will not discriminate against employees or applicants because they have inquired about, discussed, or disclosed their compensation or the compensation of another employee or applicant. We are committed to creating an inclusive environment for all employees. Our diversity drives innovation deepens connections and strengthens our organization.

          GEHA is headquartered in Lees Summit, Missouri, in the Kansas City area. We recognize the importance of balance and flexibility and offer hybrid and workfromhome options for many of our roles.