Snowflake Data Engineer

Role : Snowflake Data Engineer Location : Remote Contract: W2 Job Summary: As a Cloud Data Engineer, you will design, build, and maintain scalable data pipelines, systems and platforms with primary focus on Snowflake, and leveraging Microsoft Azure services to deliver integrated and high- performing data solutions. You will collaborate with business data analysts, data architects, data scientists, project managers, and GEHA’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, organizational goals, and governance policies. You’ll work in a cloud-native environment to design and optimize data solutions that improve performance, scalability, and efficiency. Key Responsibilities: · Proven experience as a Cloud Data Engineer or similar role, with a strong focus on Snowflake, including architecture, performance optimization and data modeling as well as hands-on experience with Azure cloud services. · Advanced Snowflake ETL/ELT Development: Design and develop complex ETL/ELT pipelines natively in snowflake using snowflake streams, tasks, SnowPipe and other features to automate data transformation and orchestration, leveraging Azure Data services and other tools where appropriate ensuring the efficient flow of data to multiple destinations for processing, storing, analysis, and delivery to downstream external consumers. · Cloud Data Architecture: Design and implement Snowflake-based data solutions to support enterprise data platforms, integrating with Azure Data Lake Storage (ADLS), Azure SQL Data Warehouse, Azure Databricks to support data extracts, data sharing, business intelligence, analytics, and data science initiatives. · Snowflake 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 your assigned stories/tasks, work with other engineers & analysts on the team to take code all the way to Production using Change Management process. · Participate in Architectural discussions, able to understand the bigger picture & expected to provide recommendation to make better architectural decisions for specific domains. · Perform regular Code Reviews and making sure best practices are followed. · 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 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 company Change Management process. · Participate in scrum, backlog grooming, refinement, planning and review sessions. · Other duties as assigned. Required Qualifications: · Requires at least 6-10 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 including Snowpipe, snowflake Tasks and Snowflake streams and Azure including Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure SQL Database, Azure Synapse, and Azure Databricks. · Advanced experience with Snowflake data platform, including schema design, data sharing, internal & external marketplace, performance turning, and cost optimization. · Proficiency in SQL and good experience with writing complex queries, stored procedures, and managing large datasets. · SME level knowledge of Data Warehouse concepts, Data Modeling, database management systems (SQL and NoSQL), and ETL/ELT frameworks, ideally in Azure Data Factory or Azure Synapse. · Experienced with DevOps practices, Repos, Snowflake, and CI/CD pipelines for data solutions. · 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 any issues. · Passionate to learn new technologies & techniques; eagerness towards understanding data & business processes to contribute & make a difference. · Ability to work collaboratively in a team environment. · Prior knowledge or willingness to learn healthcare and analytics industries. · Preferred fundamentals certification in Azure, Snowflake, Databricks, or comparable cloud platforms or technology.