Jobs at ICAP Columbia University

Overall function

• Reporting to the Team Lead Software Development, the Data Engineer will play a crucial role in harnessing disease surveillance data for ongoing surveillance of new and emerging infectious diseases. They will focus on designing, implementing, and maintaining data pipelines and storage solutions, ensuring data is readily available for analysis and decision-making. The ideal candidate should have a minimum of 2 years of experience in data engineering, with a strong understanding of data integration, processing, and database management. While reporting to Team Lead Software Development, the Data Engineer will closely collaborate with the DDSR M&E department within the Kenya Ministry of Health.

Major Accountabilities:

• Design and implement data pipelines to capture, process, and transform disease surveillance data from various sources into a usable format.
• Develop and maintain databases that efficiently store and organize large datasets, ensuring data integrity and availability.
• Collaborate with stakeholders to understand data requirements and integrate data from multiple systems into a unified and accessible repository.
• Implement data quality checks and validation processes to ensure the accuracy and consistency of surveillance data.
• Build automated data processing solutions that streamline data ingestion and reduce manual data manipulation.
• Investigate and evaluate new informatics tools and technologies, staying updated with industry advancements to enhance existing data systems.
• Provide training and mentorship to the MoH DDSR surveillance and M&E teams in data engineering best practices.
• Act as a bridge between business stakeholders and the data engineering team, ensuring effective communication and collaboration throughout data-related projects.
• Create comprehensive documentation of data pipelines, data models, and processes for future reference.
• Ensure compliance with data governance and security standards to protect sensitive health data.
• Continuously monitor and optimize data pipelines and databases for improved performance.
• Education: Bachelor’s degree in computer science, information engineering, data science, or a related field. Additional training in data engineering, data management, or relevant certifications is a plus.

Experience, Skills, and Minimum Required Qualifications:

• Minimum of two (2) years of experience in data engineering, including working with large datasets and data processing.
• Proficiency in data integration tools and technologies.
• Strong understanding of database management, ETL (Extract, Transform, Load) processes, and data warehousing.
• Proficient with relevant data engineering tools and programming languages (e.g., Python, SQL, SSIS, Talend, Spark).
• Excellent organizational, communication, and interpersonal skills.
• Strong critical thinking and problem-solving abilities.
• Ability to work independently and collaboratively in a team environment.
• Experience with health data standards and compliance is advantageous.
• Meticulous attention to detail and data quality.

Applications close: 30 Nov 2023 

go to method of application »

Overall function

• Reporting to the Project Director, the Business Analyst will contribute to the development, implementation, and management of automated solutions to harness disease surveillance data for ongoing surveillance of new and emerging infectious diseases across data systems for improved public health action. They will be mainly responsible for analysing software systems that are identified to participate in the SHIELD ecosystem, identifying areas for improvement, and working with stakeholders to define requirements and specifications to guide development of ADAM, SHIELD and E-BRIDGE software system. The ideal candidate will have a minimum of 2 years of experience in software business analysis, with a strong understanding of software development methodologies, requirements gathering, and documentation. While the Business Analyst will report to Project Director, he/she will work closely with members of the ICAP informatics team, US-CDC and DDSR M&E department at the Kenya MOH.

The Business Analyst will be required to use the WHO SMART Guideline approach and specifically utilise the Digital Adaptation Kit (DAK).

Major Accountabilities:

• Study and elicit the requirements from the client (MOH) and develop appropriate specifications to guide development of ADAM, SHIELD and E-BRIDGE.
• Work with stakeholders to a complete DAKs for ADAM, SHIELD and E-BRIDGE as appropriate.      
• Collaborate with software development teams to ensure that the software systems are developed according to the defined requirements and specifications as expressed in the relevant DAKs..
• Test and validate software systems to ensure that it meets the requirements and is functioning as intended.
• Investigate and evaluate new informatics tools and technologies through effective networking and participation in meetings; leverage new knowledge to adapt and improve existing data systems.
• Train and mentor MoH DDSR surveillance and M&E teams.
• Act as a liaison between business stakeholders and software development teams, ensuring effective communication and collaboration throughout the project lifecycle.
• Perform other related duties as directed.

Education: Bachelor’s degree in computer or information science/engineering, information systems/ technology, or related field required and professional certification in Business Analysis. Additional training in public health, health informatics, or health-related field is a plus.

Experience, Skills, and Minimum Required Qualifications

• Minimum of two (2) years of related experience in software business analysis, including experience designing and working directly with databases using large datasets.
• Strong understanding of software development methodologies, requirements gathering, and documentation.
• Proficiency with Microsoft Office Suite (e.g., Excel, Word, Outlook, PowerPoint).
• Excellent organizational and oral/written communication, and interpersonal skills.
• Strong critical thinking, analytical and problem-solving skills.
• Ability to work independently and in a team environment and manage various tasks under tight deadlines.
• Experience with WHO’s SMART Guidelines.     
• Excellent attention to detail

go to method of application »

MAJOR ACCOUNTABILITIES:

• Verify accuracy of information provided on the monthly payroll files prepared by the country office teams including new hires, end of employment dues, allowances, bonuses for each employee to ensure that employees are paid correctly and within the payroll deadlines
• Complete detailed monthly payroll variance analysis (eg. Gross-to-net, taxes, statutory and non-statutory deductions, etc.) and reconciliation in order to inform management of variances that require further review
• Prepare and maintain accurate records and reports of payroll transactions
• Develop in-depth knowledge of allowances policies, country office local hire manuals and ICAP Standard Operating Procedures
• Partner with ICAP country office based HR and Finance colleagues and the global payroll vendor to resolve employee payroll issues
• Act as a super user of the global payroll system to create reports and respond to audit and ad-hoc payroll data requests
• Escalate payroll related issues, seek advice when faced with complex issues/problems and propose reasonable solutions
• Actively participate in the onboarding process of new hires to provide training and coaching on payroll processes and system and provide refresher trainings upon request
• Act as an advisor on routine payroll related enquiries where the answer is defined by a clear precedent or established procedures
• Identify gaps and seek opportunities for continuous payroll process improvement and suggest appropriate corrective action to Senior Management which can simplify, automate, improve accuracy and/or enhance controls.
• Provides strict protection and respect of confident information and records
• Develop annual payroll calendar for review and approval
• Liaise with global payroll vendor to review and maintain current employee access
• Identify global payroll trends and share recommendations for improvement with the team
• Complete other relevant duties and ad-hoc projects as assigned

EDUCATION:

• Bachelor’s Degree required, Business Administration or Accounting degree preferred
• Payroll certification or certificate in global payroll management preferred

EXPERIENCE, SKILLS & MINIMUM REQUIRED QUALIFICATIONS:

• 5+ years of experience preparing payroll for a global organization, non-profit or NGO’s
• 3+ years of experience with a global payroll system and development of payroll reports
• Excellent analytical skills and advanced working knowledge of Excel and Microsoft Suite
• Ability to think critically and conduct complex payroll analysis of multi-country payrolls
• Excellent communication skills, both verbal and written with the ability to build rapport and trust with colleagues and vendors
• Ability to develop a clear understanding of payroll processes and their application and new software, applications and processes
• Effectively manage of strict deadlines
• Awareness of when to refer non-routine enquiries to more senior colleagues
• Demonstrated proactiveness and ability to take ownership of role
• Effectively balance independent work while embracing teamwork

TRAVEL REQUIREMENTS:

• 4 to 6 trips per year lasting 1 to 2 weeks may be required