Data Engineer

Job Description

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.
Source: https://reliefweb.int/job/4150554/data-engineer