Data Engineer Intern at Palladium Group

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

• BSc. 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.
• Good analytical and conceptual thinking skills.
• Excellent documentation skills.