L1 Data Engineer

Select Source International; Dadri, Gurugram District; On-site; INR 600,000 - 900,000; Full time

Job summary

Select Source International is seeking an L1 Data Engineer to support data ingestion, pipeline monitoring, data validation, and operational activities in a healthcare analytics environment. The role focuses on Snowflake, AWS-based pipelines, and ensuring data quality and timely issue resolution.

Responsibilities include SQL development, data reconciliation, Snowflake administration, and incident management.

Qualifications

• 1-4 years of experience in Data Engineering, Data Operations, or Data Support.
• Freshers with strong SQL and data engineering fundamentals may also be considered.

Responsibilities

• Monitor Snowflake and AWS-based data pipelines and validate pipeline results.
• Write and execute SQL queries for data analysis and troubleshooting.
• Investigate and resolve data quality issues and load failures in pipelines.
• Understand end-to-end data flow across landing, raw, L1-L3 layers.
• Gain knowledge of healthcare data domains and reporting needs.
• Perform Level 1 incident investigation and document runs and issues.
• Prepare runbooks and provide status updates on pipeline executions.

Skills

SQL querying

Data validation

Data pipeline concepts

Python

Problem solving

AWS

Tools

Snowflake

AWS

ETL

Job description

L1 Data Engineer ( For Ops & Support)

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.

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-4 years of experience in Data Engineering, Data Operations, or Data Support.
• Freshers with strong SQL and data engineering fundamentals may also be considered.