Posted 17 May, 2026
Data Warehouse Operations Engineer (Python + SQL)
NR Consulting
Pan India
Full Time
Reference: 365_463738_26-02640
Title: Data Warehouse Operations Engineer (Python + SQL)
Location: Pan India
Exp: 6 to 8 Years
Job Description:
Responsibilities
- Monitor and manage data pipelines to ensure reliable and timely data processing.
- Investigate pipeline failures by analyzing logs, job runs, and system errors.
- Perform root cause analysis and resolve pipeline issues.
- Develop and maintain Python scripts for:
- Data extraction and loading
- Data cleansing and transformation
- API integrations
- Use Pandas DataFrames for data manipulation, transformation, and validation.
- Build and maintain DAGbased workflows (e.g., Airflow) for scheduling and orchestration.
- Write advanced SQL queries for validation, analysis, and troubleshooting.
- Ensure data quality and integrity across the warehouse.
- Optimize queries and workflows for performance and scalability.
Required Skills
- Strong experience with Advanced SQL (joins, window functions, aggregations, query optimization).
- Strong Python scripting experience.
- Handson experience with Pandas Data Frames for data manipulation.
- Experience with API integrations using Python.
- Experience with DAGbased orchestration tools (Airflow or similar).
- Experience with pipeline monitoring and log analysis.
- Exposure to Snowflake or other cloud data warehouse platforms.
Location: Pan India
Exp: 6 to 8 Years
Job Description:
Responsibilities
- Monitor and manage data pipelines to ensure reliable and timely data processing.
- Investigate pipeline failures by analyzing logs, job runs, and system errors.
- Perform root cause analysis and resolve pipeline issues.
- Develop and maintain Python scripts for:
- Data extraction and loading
- Data cleansing and transformation
- API integrations
- Use Pandas DataFrames for data manipulation, transformation, and validation.
- Build and maintain DAGbased workflows (e.g., Airflow) for scheduling and orchestration.
- Write advanced SQL queries for validation, analysis, and troubleshooting.
- Ensure data quality and integrity across the warehouse.
- Optimize queries and workflows for performance and scalability.
Required Skills
- Strong experience with Advanced SQL (joins, window functions, aggregations, query optimization).
- Strong Python scripting experience.
- Handson experience with Pandas Data Frames for data manipulation.
- Experience with API integrations using Python.
- Experience with DAGbased orchestration tools (Airflow or similar).
- Experience with pipeline monitoring and log analysis.
- Exposure to Snowflake or other cloud data warehouse platforms.
