Internship | Job Vacancies at Living Goods

Data Engineer at Living Goods

Purpose of the role:

We are looking for a Data Engineer to participate in the design, development, and management of our data warehousing infrastructure. This role involves building and maintaining data pipelines, managing both relational and non-relational databases, optimizing queries, and transforming raw data into structured data for analysis and reporting.

The successful candidate will collaborate closely with the program, MLE, product management, and software engineering teams to understand data requirements and oversee the implementation of suitable solutions to ensure stakeholders’ needs are satisfied.

Embedded within the Digital Health Team, this role will report to the Senior Manager, Data Engineering & Architecture. The ideal candidate will bring extensive expertise in Transactional Databases, Data Warehouses, and BI reporting systems.

Roles And Responsibilities

Participate in the design, implementation, and maintenance of data pipelines by performing extraction, transformation, and loading activities from structured and unstructured data sources into a data warehouse.
Design and Build Data models – star schema, snowflake. Understand common analytical data models like Kimball. Build physical data models and align with best practices and requirements.
Design, develop, and optimize complex SQL queries to support data discovery, analysis, and reporting. Leverage SQL to ensure accurate data staging and transformation processes that align with business requirements.
Conduct thorough data discovery to identify and address data quality issues, ensuring that the data is accurate, complete, and accessible for business needs
Monitor system logs for errors and performance issues; troubleshoot and resolve issues as they arise. Conduct day-to-day system checks and maintenance tasks to ensure system availability.
Develop BI technical documentation – data dictionaries, definitions, data flows, database schemas, data model diagrams, Entity Relationship Diagrams (ERDs), etc.
Collaborate with BI developers and users to understand business rules, capture requirements, develop user stories and write technical/functional specifications based on conceptual design and stated business requirements.
Assist across internal teams to define excellence in data governance, privacy, and security.

Skills & Competencies

3+ years experience as a Data Engineer.
Demonstrated experience in implementing data pipelines/ETL into data warehouses and data querying and analysis using cloud-based solutions such as AWS Redshift or Snowflake.
Proficiency in SQL & Python for advanced querying, data manipulation, and performance optimization.
Experience with ETL tools like AWS Glue, Airbyte or Talend for building automated data pipelines.
Strong knowledge of data modeling and transformation using tools like dbt.
Hands-on experience with workflow automation tools such as Airflow.
Expertise in managing CouchDB or PostgreSQL databases, including schema management, performance tuning, and complex queries.
Extensive data warehouse experience, with skills in performance tuning, query optimization, indexing, and data integrity management.
Proficiency in using BI tools such as Tableau, Power BI, or Superset for creating reports and dashboards.
Strong understanding of data governance, security, and compliance best practices in cloud environments.
Soft Skills: Teamwork, Collaboration, Problem solving, Strong communication and presentation skills to effectively translate technical concepts to business stakeholders.

Minimum Qualifications

A Bachelor’s degree in computer science, Data Science, Statistics, Mathematics, or a related discipline.
Professional certifications or equivalent experience in data management, ETL processes, data warehousing, data visualization, and managing large and complex datasets.

DevOps Engineer

Reports to: Senior DevOps Engineer.
Location: Nairobi – Kenya.

About Living Goods

Living Goods endeavours to improve access to essential healthcare services in underserved regions, particularly in sub-Saharan Africa. We empower Community Health Workers (CHWs) with digital tools that enable them to deliver door-to-door care. CHWs use a mobile app to track pregnancies, diagnose and treat common infectious diseases like malaria and pneumonia, monitor disease outbreaks, and follow up with families. Real-time data also supports performance monitoring and impact assessment. By integrating tech-based solutions into community health systems, Living Goods fosters better health outcomes, demonstrating the power of digital health in transforming healthcare delivery in resource-constrained settings.
We are seeking a seasoned DevOps Engineer to design, implement and maintain scalable and resilient infrastructure solutions to support our software development and deployment processes. The ideal candidate will have a strong background in DevOps and an understanding of its concepts and best practices.
Embedded within the Digital Health Team, this role will report to the Senior DevOps Engineer. The ideal candidate will bring expertise in designing, implementing and maintaining tools and processes for continuous integration, delivery, and deployment of our software solutions.

Roles and Responsibilities

Design and implement automation tools and frameworks for continuous integration, delivery, and deployment.
Collaborate with development teams to understand requirements and implement solutions.
Develop and maintain CI/CD pipelines to automate software delivery.
Monitor and manage infrastructure, ensuring optimal performance, security, and scalability.
Troubleshoot and resolve issues related to application development, deployment, and operations.
Implement and maintain version control systems, configuration management tools, and other DevOps-related technologies.
Continuously improve processes and tools to enhance efficiency and productivity.
Document processes and workflows to support team knowledge sharing.
Develop, test, implement, maintain, and optimize automated software delivery in an Infrastructure as Code (IAC) environment.
Implement integrations requested by software engineering teams.
Contribute to improving system reliability, availability and performance.
Stay up to date with industry trends and best practices in DevOps.

Skills and Competencies

Experience with cloud platforms (AWS, Azure, GCP).
Good knowledge in Docker and Kubernetes for container management and orchestration.
Hands on experience with DevOps tools and technologies, such as Jenkins, Docker, Kubernetes, terraform and Ansible, GitHub Actions and other CI/CD tools.
Experience in one or more programming languages, preferably Python and JavaScript
Linux system administration, monitoring, security best practices, networking, and logging.
Good knowledge of shell scripting, Java or Python.
Knowledge of monitoring and logging tools (Prometheus, Grafana, ELK Stack)
Working knowledge of databases both RDBS and NoSQL.
Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform.
Strong analytical and problem-solving skills, with attention to detail.
Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
Ability to prioritize tasks and manage time efficiently in a fast-paced environment.
Continuous learning mindset to stay updated with evolving technologies and industry best practices.
Familiarity with command-line tools on Linux or another UNIX-like operating system.
Experience with version control systems such as GIT.
Familiarity with open-source platforms and tools such as Digital Global Goods (CHT, CommCare, OpenSRP, OpenMRS, OpenLMIS, DHIS2, etc.) would be advantageous.

Minimum Qualifications

Bachelor’s degree in computer science, IT, or a related field.
3+ years of professional experience in a DevOps role, and experience in working on a Linux based infrastructure.
Relevant certifications in cloud platforms will be an added advantage.

Compensation

A competitive salary and benefits package commensurate with experience including health insurance and bonus opportunity. The opportunity to be your best while making lives better for those in need.

Living Goods is an equal opportunity employer and will consider every qualified applicant for employment