Etl Analyst (Data Engineer)

Role Summary We are seeking a motivated L1 Data Engineer to support data ingestion, pipeline monitoring, data validation, and operational activities within a healthcare analytics environment. The role involves working with SQL, Snowflake, AWS-based data pipelines, and healthcare datasets while ensuring timely resolution of production issues and maintaining data quality. Key Responsibilities Data Pipeline Operations Monitor and execute Snowflake and AWS-based data pipelines. Support daily data load activities and validate pipeline execution results. Ensure successful ingestion of source data into Snowflake layers. Review pipeline run history, task statuses, and execution logs. SQL Development & Data Validation Write and execute SQL queries for data analysis, validation, and troubleshooting. Perform data reconciliation and quality checks across source and target systems. Support root cause analysis for data discrepancies and load failures. Validate fact and dimension table outputs against business requirements. Snowflake Administration & Support Execute and monitor Snowflake tasks, stored procedures, and workflows. Support incremental and full-load processes. Investigate and resolve Snowflake pipeline failures and data quality issues. Assist in performance monitoring and basic query optimization. Data Architecture Understanding Develop an understanding of end-to-end data flow across Landing, Raw, L1, L2, and L3 layers. Understand fact/dimension data models and business KPI generation processes. Work closely with senior engineers to support enhancements and operational activities. Healthcare Business Knowledge Gain knowledge of healthcare and pharmaceutical data domains. Understand healthcare datasets such as sales, patient, provider, product, and market data. Collaborate with business stakeholders to understand reporting and analytical needs. Incident Management & Troubleshooting Perform Level-1 investigation of production incidents. Analyze logs, data loads, workflow failures, and validation errors. Escalate complex technical issues with sufficient troubleshooting details. Maintain operational documentation and incident records. Documentation & Communication Prepare operational runbooks and troubleshooting guides. Provide regular status updates on pipeline executions and issue resolutions. Participate in KT sessions, stand-ups, and operational review meetings. Required Skills Technical Skills Strong SQL querying and data validation skills. Hands-on experience with Snowflake. Understanding of ETL/Data Pipeline concepts. Basic knowledge of AWS services (Glue, S3, Lambda, Step Functions is preferred). Familiarity with data warehousing concepts. Basic scripting knowledge (Python preferred). Functional Skills Understanding of healthcare/pharmaceutical business processes is desirable. Analytical and problem-solving mindset. Strong communication and documentation skills. Ability to work in a production support environment. Experience 1-3 years of experience in Data Engineering, Data Operations, or Data Support. With strong SQL and data engineering fundamentals may also be considered. Role Summary We are seeking a motivated L1 Data Engineer to support data ingestion, pipeline monitoring, data validation, and operational activities within a healthcare analytics environment. The role involves working with SQL, Snowflake, AWS-based data pipelines, and healthcare datasets while ensuring timely resolution of production issues and maintaining data quality. Key Responsibilities Data Pipeline Operations Monitor and execute Snowflake and AWS-based data pipelines. Support daily data load activities and validate pipeline execution results. Ensure successful ingestion of source data into Snowflake layers. Review pipeline run history, task statuses, and execution logs. SQL Development & Data Validation Write and execute SQL queries for data analysis, validation, and troubleshooting. Perform data reconciliation and quality checks across source and target systems. Support root cause analysis for data discrepancies and load failures. Validate fact and dimension table outputs against business requirements. Snowflake Administration & Support Execute and monitor Snowflake tasks, stored procedures, and workflows. Support incremental and full-load processes. Investigate and resolve Snowflake pipeline failures and data quality issues. Assist in performance monitoring and basic query optimization. Data Architecture Understanding Develop an understanding of end-to-end data flow across Landing, Raw, L1, L2, and L3 layers. Understand fact/dimension data models and business KPI generation processes. Work closely with senior engineers to support enhancements and operational activities. Healthcare Business Knowledge Gain knowledge of healthcare and pharmaceutical data dom