Sr. Cloud Data Engineer Snowflake

Job description

G.E.H.A (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.

G.E.H.A 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, G.E.H.A 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 Sr Cloud Data Engineer, you will be developing and maintaining the 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 of the Data & Analytics activities and initiatives in alignment 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 performance, scalability, and efficiency of our data and analytics offerings.

**SKILLS**

**Key Responsibilities:**

+ Advanced ETL/ELT Development: Design and develop complex ETL/ELT pipelines ensuring the efficient flow of data from multiple sources to Snowflake for processing, storing, analyzing, and consuming large datasets on Snowflake.
+ Cloud Data Architecture: Design and implement data solutions in Snowflake to support business intelligence, analytics, and data science initiatives.
+ Cloud Platform Data Architecture: Oversee the design and optimization of Snowflake architecture, including data models, schema design, partitioning, clustering, and query optimization to ensure high performance and low cost.
+ Work independently on assigned stories/tasks.

Lead and guide other data engineers on the team to deploy data solutions through the environments to Production using the approved Change Management process.
+ Participate in Architectural discussions, able to understand the data strategy, and expected to provide recommendation to make architectural decisions for data domains.
+ Perform regular Code Reviews and make sure best practices are followed.
+ Innovation and Thought Leadership: Stay current with emerging cloud technologies and data engineering trends.

Drive innovation in data architecture and pipeline development to maintain a competitive edge.
+ Collaborate with Stakeholders: Work closely with cross-functional 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.
+ Data Security, Governance & Compliance: Implement best practices 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 business-critical data needs.
+ Ensure that all items follow the company Change Management process.
+ Participate in scrum, backlog grooming, refinement, planning and review sessions.
+ Leads backlog grooming, refinement, and planning meeting, as needed.
+ Other duties as assigned.

**Required Qualifications:**

+ Requires 5-8 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.
+ Expertise in designing and implementing data architectures on Snowflake (preferred).
+ Proven experience as a Cloud Data Engineer or similar role, specifically working with or Snowflake.
+ Advanced experience with Snowflake data platform, including schema design, performance turning, and cost optimization.
+ Proficiency in SQL and valuable experience with writing complex queries, stored procedures, and managing large datasets or equivalent such as Python, R, Apache Spark etc.
+ SME level knowledge of Data Warehouse concepts, Data Modeling, database management systems (SQL and NoSQL), and ETL/ELT frameworks, ideally in Snowflake.
+ Experienced with DevOps practices, Repos, Snowflake, and CI/CD pipelines for data deployments.
+ Ability to work in a collaborative, cross-functional team environment and communicate complex technical concepts to non-technical stakeholders.
+ Very Good understanding of Agile and Scrum processes.
+ Experience & eagerness for problem solving and root cause analysis for data issues.
+ Enthusiastic to learn innovative technologies & techniques; eagerness towards understanding data & business processes to contribute and are effective.
+ 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.

Work-at-home requirements

+ Must have the ability to provide a non-cellular 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 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 (pretax or Roth options) 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

While this is a remote opportunity, at this time G.E.H.A 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.

G.E.H.A considers factors such as (but not limited to) scope and responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as, market and business considerations when extending an offer.

The hiring range for this position is $115,287 - $145,845 USD.

At G.E.H.A, the current maximum salary for this role is $162,513 USD.

While initial compensation may vary based on experience and qualifications, there is a path to work toward this top rate through performance and continued growth within the organization.

G.E.H.A 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.

G.E.H.A 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.

G.E.H.A is headquartered in Lee's Summit, Missouri, in the Kansas City area.

We recognize the importance of balance and flexibility and offer hybrid and work-from-home options for many of our roles.

**Please note: Due to recent fraudulent activity in the job market, if you receive correspondence from someone at G.E.H.A, we recommend you review the following facts to help verify if someone is truly a G.E.H.A employee before sharing any personal information.**

+ All email addresses of G.E.H.A employees will end with our domain, @ geha.com .

Any other domain is not verified and is illegitimate.

**Please double check the spelling as well** .
+ We will never extend a job offer without having at least one live video call.
+ We will never ask you for or provide you with any money, personal or banking information during the interview process or before signing an offer letter.

Please report any suspicious messages to HumanResources@geha.com so that we can help reduce this fraudulent activity.

G.E.H.A (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.

Offering one of the largest medical and dental benefit provider networks available to federal employees in the United States, G.E.H.A empowers health and wellness by meeting its members where they are, when they need care.

Among our core values is embracing diversity and inclusion, where we thrive by creating an environment in which each of our employees feels a sense of belonging, can engage their full potential and focus on enriching our people, culture and community.

Your FUTURE is here with us –COME GROW WITH G.E.H.A!

Benefits start on day one! Great 401(k) match! Tuition assistance programs! Professional development! Advancement opportunities!

For additional information, please visit GEHA Careers.

(https://www.geha.com/careers)

Required Skill Profession

Other General