ROLE PROFILE
|
Job Title
|
Specialist – Data Engineer (ETL Expert)
|
|
Functional Area
|
Data Engineering
|
|
Reports To
|
Nodals of Data Science Centre, KGMU
|
|
Location
|
Lucknow, Uttar Pradesh
|
Travel Required
|
10% - 20%
|
|
Effective Date
|
September 2026
|
IHAT PURPOSE AND PRIORITIES
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.
ROLE PURPOSE
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.
DIMENSIONS OF THE ROLE
- 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.
QUALIFICATIONS & EXPERIENCE
- B.Tech/Master’s/PhD in Data Engineering, Computer Science, or IT
- 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
CRITICAL 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.
KEY RELATIONSHIPS
Internal:Nodals of Data Science Centre, KGMU and other internal teams
ADDITIONAL INFORMATION
This is a fixed term appointment with option to renew, initially for a period of up to 1 year. After the initial fixed-term period, IHAT may choose to renew the appointment in accordance with its policies.
IHAT’S VALUES IN PRACTICE
Community Centric: It is the communities we serve and the community at IHAT that drives us forward.
Think Sustainability: We believe in engaging with the government and communities to scale up and sustain positive outcomes.
Scientific and Innovative: We relentlessly pursue scientific rigour and adapt our work in the face of new evidence. We encourage out of the box thinking and challenge ourselves to do better.
Interdisciplinary: We foster discussion, debate and deliberation across disciplines to arrive at the best possible solution.
LEVEL OF CONTACT WITH CHILDREN
Low Contact – Low frequency of interaction with children
HOW TO APPLY
IHAT is an equal opportunity employer. The organization is continuously assessing and enhancing its practices allied with gender equity and inclusion. We provide a multicultural and safe working environment for all our employees. Equal opportunity is provided to qualified and interested candidates irrespective of caste, color, religion, marital status, sexual orientation, ability, gender identity expression, or any other basis for attracting diverse talent, cultivating and nurturing an inclusive workplace environment. IHAT is committed to providing an enabling environment to its employees to continue with the learning pathway. Applications are particularly encouraged by women and other diverse genders, applicants from marginalized communities, people living with HIV and different abilities.
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. If you have not heard from us within fifteen days 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.