Data Warehouse & ETL Specialist Full Time NEW

About Palladium:  

Palladium is a global company working to design, develop and deliver positive impact on the lives and livelihoods of people around the globe; broaden access to health, water, power, and infrastructure; build enduring, sustainable, and transformative institutions and market systems to address global challenges; and conserve the natural world. We operate in over 90 countries and have a workforce of 4,000 talented, motivated, and diverse staff of all religions, races, languages, and gender identities.  

Project Background:

Palladium is implementing the USAID-funded Translating Data for Implementation (Data.FI) award. Data.FI is a $180 million project which serves as USAID’s primary mechanism for data, technology, and health information systems to support HIV activities across strategic PEPFAR countries.  Data.FI is part of a suite of large-scale global HIV programs that USAID has awarded and represents the next generation of HIV/AIDS programs. Data.FI plays a key role in USAID’s goals of helping partner countries on their Journey to Self-Reliance and transitioning local organizations to prime recipients of USG funding.

The overall goal of the Data.FI project is to improve global, regional, and national in-depth analyses of HIV epidemiologic and program data that can be directly applied to expedite the achievement of PEPFAR targets to attain and sustain control of the HIV epidemic.  The focus also includes directly supporting host country governments and implementing partners to further enhance existing health information system platforms to inform management responses to well-defined gaps in HIV/AIDS programming.  In order to ensure rapid access to high quality data, Data.FI works towards: accelerating data utilization to rapidly course correct and take to scale cost-effective and impactful activities, models and approaches required to attain and maintain HIV epidemic control; scaling and optimizing in-country health information system capabilities to collect, exchange, adapt, govern, and visualize information in order to track the attainment and maintenance of HIV epidemic control; and supporting the transition of prime funding and implementation to capable local partners.

Position Summary: 

The Data Warehouse & ETL Specialist is responsible for architecting and managing robust data pipelines and repositories that support Ethiopia’s health data analytics and reporting. This role focuses on building and optimizing extract-transform-load (ETL) processes from multiple source systems, including EMRs, LMIS, DHIS2, and eCHIS, into a centralized data warehouse that supports real-time and longitudinal analytics.

Primary Duties and Responsibilities: 

• Design, implement, and maintain scalable data warehouses integrating multi-source health data.
• Develop automated ETL processes and data pipelines using open-source and enterprise-grade tools.
• Ensure data quality, standardization, and normalization to support accurate health metrics and reports.
• Optimize data storage, querying, and processing performance using SQL and big data technologies.
• Collaborate with M&E and analytics teams to deliver high-quality data for dashboards and reporting.
• Manage metadata, schema versioning, and lineage tracking to support data governance.
• Document warehouse architecture, ETL logic, and validation checks in line with audit and compliance needs.
• Ensure systems meet data protection and privacy standards, including role-based access control.

Required Qualifications:

• Degree in Computer Science, Data Engineering, or related field.
• Minimum 4 years of experience in ETL, data warehousing, and reporting.
• Expertise in SQL, Python, Pentaho, Talend, or other ETL tools.
• Experience with health information systems like DHIS2, OpenMRS, and LMIS.
• Strong problem-solving skills and attention to data integrity and governance.

Equity, Diversity & Inclusion –

• Palladium is committed to embedding equity, diversity, and inclusion into everything we do. We welcome applications from all sections of society and actively encourage diversity to drive innovation, creativity, success, and good practice. We positively welcome and seek to ensure we achieve diversity in our workforce; and that all job applicants and employees receive equal and fair treatment regardless of their background or personal characteristics. These include: (but are not limited to) socio-economic background, age, race, gender identity and expression, religion, ethnicity, sexual orientation, disability, nationality, veteran, marital or Indigenous status.
  

How To Apply

Should you require any adjustments or accommodation to be made due to a disability, or you are a neurodivergent individual or for any other circumstance, please email our team at accessibility@thepalladiumgroup.com and we will be in touch to discuss.

Safeguarding – We define Safeguarding as “the preventative action taken by Palladium to protect our people, clients and the communities we work with from harm”. We are committed to ensuring that all children and adults who come into contact with Palladium are treated with respect and are free from abuse.  All successful candidates will be subject to an enhanced selection process including safeguarding-focused interviews and a rigorous due diligence process.