Vacancies

About IHAT:

India Health Action Trust was instituted in 2003 as a Charitable Trust with a vision to meaningfully impact the lives of vulnerable and marginalised people by addressing health and social inequities. The Trust is working towards reducing inequities by developing comprehensive and sustainable programmes to improve population health. Since its inception, IHAT has working closely with the Government of India and state governments, including Uttar Pradesh, Madhya Pradesh, Rajasthan, Delhi and Bihar to achieve public health goals. Our work is focused in areas of prevention and control of HIV and Tuberculosis, in achieving significant improvements in Reproductive, Maternal, Neonatal and Child Health, improved Nutrition among mothers and children, and strengthening health systems. We use program science to optimise and scale public health programs while partnering with the governments and communities.

About Program:

The Uttar Pradesh Technical Support Unit (UPTSU) provides integrated Technical Assistance (TA) to the government of Uttar Pradesh (GoUP), which focuses on accelerating progress in reproductive, maternal, new-born and child health, and nutrition (RMNCHN). UPTSU works closely with the GoUP at the state, district and local levels to optimize RMNCHN programs and services. The technical assistance provided by UPTSU is integrated within the GoUP’s health system response for scale-up and sustainability. UPTSU focuses on interventions to improve outcomes in Family Planning, Maternal and New-born Health, and Nutrition, along with Routine Immunization, Digital Health, and other initiatives.

Reporting to:

Nodals of Data Science Centre, KGMU

Travel Requirements:

10%

Job Summary :

The Data Science Centre at KGMU aims to serve as a multidisciplinary hub for transforming health data into actionable insights to improve patient outcomes, enable data-driven research, and support policy decision-making at the institutional and state levels.

The role holder should design, develop, and optimize ETL pipelines for seamless data integration from multiple sources into the data warehouse/analytics systems. The role holder should ensure data integrity, accuracy, and performance across integrated systems, and collaborate with data teams to enable seamless data availability for analytics and AI models.

Key Responsibilities:

• Design and develop robust ETL processes on cloud technology such as AWS to ensure seamless data injestion, data integration and business intelligence.
• Leverage AWS serverless technologies (like Glue / Lambda / Kinesis) for real-time and batch processing of big data.
• Optimize SQL to write complex queries and stored procedures for efficient data extraction and transformation
• Implement and manage ETL processes using SSIS (SQL Server Integration Services) to guarantee high-quality data delivery.
• Design and model data warehouses to cater to reporting and analytics needs.
• Ensure data accuracy, quality, integrity, and performance of pipelines through effective validation testing procedures.
• Collaborate with business analysts, data scientists, and stakeholders to understand data requirements and deliver tailored solutions.
• Monitor and troubleshoot ETL processes to optimize performance and resolve issues promptly.
• Document ETL processes, meta data, workflows, and data mappings to maintain clarity and usability.
• Develop synthetic data using GenAI.
• Stay current with industry trends and best practices in ETL development, data integration, and data warehousing.
• Knowledge dissemination responsibilities include effectively communicating complex findings to both technical and non-technical audiences, sharing insights through presentations, reports, paper publications, and visualizations, and mentoring junior team members.

Work Experience:

• At least 5 years of experience in the IT sector, including a minimum of 3 years of hands-on experience in ETL development
• Experience in data warehousing designs and modeling
• Experience in handling medical information systems, patient data systems, or healthcare data projects is desirable.

Education:

• Tech/Master’s/PhD in Data Engineering, Computer Science, or IT

Key Competencies:

• Proficiency in API, SQL, SSIS, AWS Glue / Talend / Apache Airflow and the likes.
• Knowledge of Microsoft’s Azure cloud suite, including Data Factory, Data Storage, Blob Storage, Power BI, and Power Automate.
• Strong problem-solving and analytical skills for data pipeline optimization.
• Strong attention to detail and commitment to data quality.
• Strong oral communication skills.

How To Apply :

Interested candidates should submit their applications by clicking the “Apply Now” button provided on this page. Only a complete application submitted through the online portal before the closing date will be considered.

IHAT provides a safe working environment for all its employees; follows the principle of equal opportunity and encourages women applicants. Physically challenged with required skills /knowledge and willing to travel are also encouraged to apply.

We will be following a systematic selection process to fill this position based on experience, competency and suitability. Shortlisting for the posts will take place soon after the closing date. Only shortlisted candidates will be invited for an interview. Unfortunately, we can only contact applicants who have been shortlisted for the interview. If you have not heard from us within 6 weeks of the closing date, please assume that the current IHAT positions are unable to accommodate you at the moment. It is also not possible for us to provide you with specific feedback because of the volume of applications we receive.

IHAT does not charge any application, processing, training, interviewing, testing, or other fees in connection with the application or recruitment process. Should you receive a solicitation for the payment of a fee, please disregard it.

Advertisement Publish Date:

28 January, 2026

Advertisement End Date:

08 February, 2026