Associate Cloud Data Engineer - EDW Team
Government Employees Health Association, Inc. (G.E.H.A) is a nonprofit member association that provides health and dental benefits that millions of federal employees and retirees, military retirees and their families have counted on since 1937. Offering one of the largest health 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.
G.E.H.A has one mission: To empower federal workers to be healthy and well.
As an Assoc Cloud Data Engineer, you will be assisting in developing and maintaining scalable data pipelines on Snowflake based technologies. You will collaborate with business data analysts, 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.SKILLS
Key Responsibilities:
- Support the cloud data framework that aligns with the Enterprise Data Strategy, policies, and organizational goals.
- Design and Build Data Pipelines: Develop scalable, efficient, and secure ETL/ELT pipelines for ingesting, processing, storing, and consuming large datasets on Azure or Snowflake.
- Cloud Data Architecture: Design and implement data solutions in Azure Data Factory (ADF), Azure Data Lake Storage (ADLS) and Snowflake to support analytics, business intelligence, and data science initiatives.
- Collaborate with Stakeholders: Work closely with cross-functional teams, including business data analysts, data architects, data scientists, project managers and business units, to understand data requirements and implement data solutions that support business goals.
- Data Security, Governance & Compliance: Follow the company standards and industry 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 deliverables follow the company Change Management process.
- Participate in scrum, backlog grooming, refinement, planning and review sessions.
- Other duties as assigned.
Required Qualifications:
- Requires 1-2 years of relevant technical or business work experience with preferred 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.
- Firsthand experience with Snowflake, Microsoft Azure tools such as Azure Data Factory (ADF), Azure SQL Database, Azure Synapse, Azure Data Lake Storage (ADLS), and other Azure services.
- Hand-on experience in Data Query language, like SQL, and experience with writing queries, stored procedures, and managing datasets.
- Good understanding of ETL/ELT frameworks, ideally in Snowflake or Azure Data Factory.
- Competent SQL skills or equivalent such Python, R, Apache Spark etc.
- Familiarity with DevOps practices and CI/CD pipelines for data solutions.
- Passion & eagerness to learn innovative technologies & techniques; eagerness towards understanding data & business processes to contribute & are effective.
- Ability to work in a collaborative, cross-functional team environment.
- Basic understanding of Agile and Scrum processes.
- Prior knowledge or willingness to learn healthcare and analytics industries.
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 target hiring range for this position is $75,696 - $95,760 USD. At G.E.H.A, the current maximum salary for this role is $106,704 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.
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.
1-2 years relevant technical or business experience; Bachelor's in computer science, IT, data engineering, math or related field; Snowflake, Azure Data Factory, SQL, ETL/ELT; home office with high-speed internet; US work authorization.
Key Responsibilities
- building data pipelines
- designing cloud architecture
- collaborating with stakeholders
Skills & Tools
Snowflake, Microsoft Azure, Azure Data Factory, Azure SQL Database, Azure Synapse, Azure Data Lake Storage, SQL, Python, R, Apache Spark, DevOps, CI/CD
Job Details
- Category: Information Technology
- Seniority: Entry Level
- Commitment: Full Time
- Workplace: Remote — Missouri or Alabama or Arizona or Arkansas or Delaware or Florida or Georgia or Idaho or Illinois or Indiana or Iowa or Kansas or Kentucky or Louisiana or Maryland or Massachusetts or Michigan or Minnesota or Mississippi or Nebraska or Nevada or New Hampshire or New Jersey or New Mexico or North Carolina or North Dakota or Ohio or Oklahoma or Rhode Island or South Carolina or South Dakota or Tennessee or Texas or Utah or Virginia or West Virginia or Wisconsin or District of Columbia
- Salary: USD 75,696 – 95,760 / year
- Languages: English
Benefits
- 401k matching
- Generous paid time off
- Tuition reimbursement
- Retirement plan
About GEHA
A nonprofit member association providing health and dental benefits to federal employees and retirees. — Industry: Healthcare