Data Engineer |
Confidentiel · Cairo, Egypt
Tailor my CV for this job — freeRole Objective:The Data Engineer I is responsible for supporting the design, development, and maintenance of the data infrastructure and data warehouse environment. The role ensures reliable, accurate, and scalable data availability by developing data models, integrating data sources, maintaining data quality, and supporting data analytics and data science initiatives across the organization.Roles & Responsibilities:Collaborate on architecting, building, and maintaining the data infrastructure.Designing, developing, and maintaining Data Warehouse models.Working with the product & tech teams on new features to ensure correct and complete data logging.Auditing data & identifying data quality issues using written & automated SQL tests.Working with engineering and testing teams to solve data quality issues and improvedata integrity.Documenting implemented data models.Integrating new data sources & maintaining current ones.Supporting the Data Science & Analytics team with data engineering related matters.REQUIRED EDUCATION, KNOWLEDGE, AND SKILLS0-2 years of experience in a similar role.Knowledge of ETL/ELT concepts.Experience designing a data warehouse using dimensional modeling.Expert in SQL, writing clean, optimized, and maintainable complex scripts.Familiarity with the inner workings of databases (Eg. Indexes, Row-based vs Columnarbased databases, Partitioning data, ...etc.)Expertise in in-data warehouse data transformation.Working knowledge of python (Pandas, PySpark is a plus).Working knowledge of git.Knowing how to write clean code, structuring projects.Having a structured organized mindset.Preferred Skills:Experience with handling document-based databases (ex. MongoDB) for analytics.Knowledge of GCP.Knowledge of Airflow.Knowledge of ML-Ops tools and technologies.Working expertise with Tableau.Knowledge of docker.