Job Summary:
We are seeking a hands-on Data Engineer with strong experience in Snowflake, SQL, Python, and AWS to build, maintain, and support reliable data pipelines in a production environment. The ideal candidate will be capable of independently diagnosing issues, identifying root causes, and ensuring efficient data ingestion and transformation processes. The role requires strong collaboration with engineering teams, analysts, data scientists, and business stakeholders.
Key Responsibilities:
• Build, maintain, and support ETL/ELT and data ingestion pipelines, particularly file-based ingestion into Snowflake.
• Develop Python scripts for data ingestion, transformation, and automation.
• Implement and manage Snowflake capabilities, including Tasks, Streams, Stages, and Stored Procedures.
• Work with AWS services, particularly Amazon S3, to support data ingestion workflows.
• Monitor and support production data pipelines, including troubleshooting, data validation, and issue resolution.
• Perform root-cause analysis to identify and resolve data pipeline issues.
• Collaborate with engineering teams, analysts, data scientists, and business stakeholders to ensure reliable data delivery.
• Support analytics environments with multiple downstream consumers and cross-functional business teams.
Required Qualifications:
• At least an Associate's degree.
• 3-5+ years of hands-on data engineering experience; more senior experience is welcomed.
• Strong hands-on experience with Snowflake and modern data warehousing.
• Advanced SQL and Python skills, including experience writing Python scripts for data ingestion, transformation, and automation.
• Experience building and supporting ETL/ELT and data ingestion pipelines, particularly file-based ingestion into Snowflake.
• Hands-on AWS experience, including Amazon S3 as part of data ingestion workflows.
• Experience with Snowflake capabilities such as Tasks, Streams, Stages, and Stored Procedures.
• Experience supporting production data pipelines, including troubleshooting, data validation, issue resolution, and root-cause analysis.
• At least 2 years of experience in the healthcare industry.
• Strong communication and collaboration skills.
• Ability to work remotely with availability for recurring morning meetings during EST/CST hours.
• Ability to explain and walk through specific projects listed on the resume.
Preferred Qualifications:
• Healthcare payer or provider data experience, particularly with claims, member, provider, supplemental, or other healthcare analytics data.
• Experience with GitHub, version control, and CI/CD practices.
• Experience with dbt for data transformation and pipeline development.
• Experience with Teradata, particularly as part of modernization or migration to Snowflake.
• Experience with Control-M or similar workload scheduling and orchestration tools.
• Experience using GitHub Copilot or other AI-assisted development tools.