GEHA needs to develop and maintain scalable data pipelines in Microsoft Azure or Snowflake to ensure seamless data flow and enable actionable insights, supporting the company's mission to empower federal workers to be healthy and well.
Requirements
- Proven experience as a Cloud Data Engineer or similar role, specifically working with Azure or Snowflake.
- Direct experience in designing and implementing data architectures on Snowflake (preferred).
- Proven experience as a Cloud Data Engineer or similar role, specifically working with Snowflake.
- Experience with Snowflake data platform, specifically on consumption patterns, performance turning, and cost optimization.
- 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, ideally in Snowflake.
- Competent SQL skills or equivalent such Python, R, Apache Spark etc.
Responsibilities
- Design and Build Data Pipelines: Design and develop scalable, efficient, and secure 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: Design and optimization of Snowflake architecture, including data models, schema design, partitioning, clustering, and query optimization to ensure high performance and low cost.
- 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 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 business-critical data needs.
Other
- Requires 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.
- 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.
- Must have the ability to provide a non-cellular High Speed Internet Service such as Fiber, DSL, or cable Modems for a home office.
