Palladium is a global leader in the design, development and delivery of Positive Impact - the intentional creation of enduring social and economic value. We work with foundations, investors, governments, corporations, communities and civil society to formulate strategies and implement solutions that generate lasting social, environmental and financial benefits.
We are recruiting to fill the position below:
Job Title: Data Engineer Intern
Job ID: req23555 Location: Abuja
Project Overview and Role
Data.FI is a multi-year global project funded by the U.S. Agency for International Development (USAID) to support the HIV and COVID-19 response.
Data.FI partners with programs to accelerate and sustain access to high-quality data to expedite HIV and COVID-19 epidemic control and maintenance.
By improving global, regional, national, and community/local in-depth analyses of HIV and COVID-19 epidemiologic and programmatic data, Data.FI expedites program achievements to improve client services and attain and sustain control of the epidemics.
Data.FI supports host country governments to enhance existing health information systems (HIS), informing management responses to gaps in programming and sustaining impact by supporting local partner transition.
Purpose of Position
Palladium is seeking to recruit a skilled Data Engineer Intern is responsible for the execution of developing APIs to connect data, developing ETLs, data ingestion, mapping, deduplication, data modelling, data analysis, and reporting tasks in line with work plan and team objectives, develops specific data products and solutions assigned in adherence to the business and functional requirements, quality and timelines set, works closely with a team of individuals from data use, data visualization, project management, software development, quality assurance, business analysts and solutions architects.
The Data engineer intern will report to the supervisor and work in collaboration with the Data Use and Analytics, and the Business Analytics team.
Primary Duties and Responsibilities
Work with the engineering team to identify and implement the most optimal cloud-based solutions
Responsible for the quality of data across the core systems and respective data marts.
Support data modelling and data mart development.
Synthesis of requirements, identification and analysis of data sources for mapping and performing data quality tests to support source system mapping exercise.
Define and arbitrate the transformation rules per source system and develop ETLs to populate respective data marts.
Perform data profiling functions and interrogation queries against source systems and verify data marts after ETL processes.
Work closely with the data use teams in developing data products for the larger stakeholder groups.
Align with QA approaches established within the software development process to resolve data quality, inconsistency and integrity issues.
Maintain data dictionaries/metadata of the source systems and respective data marts.
Required Qualifications
B.Sc. Degree in Computer Science or a related field, or equivalent experience.
At least 1 years experience developing digital information systems.
Familiarity with open-source global goods, including demonstrated experience using DHIS2.
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Proven working experience with Microsoft SQL Server or PostgreSQL
Experience in NoSQL databases is an added advantage.
Proven experience developing web applications.
Demonstrated proficiency of languages such as R, Python etc.
Experience in implementing a data warehouse is an added advantage.
Ability to take direction to iteratively define and implement the solution as requirements are being identified and finalized.
Demonstrated experience in working within a multi-disciplinary team in a fast fast-paced, technically challenging environment.
Ability to work in a fast paced, agile development environment.
Excellent communication skills and attention to detail.
Good problem-solving skills, with an ability to see and solve issues before they affect business productivity.