Senior Data Warehouse Engineer Ii

Cairo, Egypt

Careem is building the Everything App for the greater Middle East, making it easier than ever to move around, order food and groceries, manage payments, and more. Careem is led by a powerful purpose to simplify and improve the lives of people and build an awesome organisation that inspires. Since 2012, Careem has created earnings for over 2.5 million Captains, simplified the lives of over 50 million customers, and built a platform for the region’s best talent to thrive and for entrepreneurs to scale their businesses. Careem operates in over 70 cities across 10 countries, from Morocco to Pakistan.

**Position Overview**:
We are seeking a highly skilled and motivated Data Engineer to join our team. As a Data Engineer, you will play a critical role in designing, developing, and maintaining our data infrastructure, ensuring the availability, scalability, and reliability of our data systems. You will collaborate closely with cross-functional teams, including data scientists, analysts, and software engineers, to support data-driven decision-making and enable the efficient processing of large-scale data.

**What you'll do**
- Design and develop robust, scalable, and high-performance data pipelines and ETL processes to extract, transform, and load data from various sources into our data warehouse or data lake.
- Collaborate with stakeholders to understand their data requirements, and design and implement appropriate data models and database schemas to support their needs.
- Optimize data pipelines and ETL processes for performance and efficiency, ensuring timely and accurate data delivery to end-users.
- Monitor, troubleshoot, and resolve issues related to data quality, data consistency, and data integrity, ensuring the reliability and correctness of our data systems.
- Implement and maintain data governance practices and policies, ensuring compliance with data privacy and security regulations.
- Collaborate with data scientists and analysts to provide them with the necessary data infrastructure and tools for conducting advanced analytics and deriving insights.
- Stay up-to-date with the latest trends and technologies in data engineering and recommend innovative solutions to improve data engineering processes and systems.
- Document data engineering processes, data flows, and system architectures to ensure knowledge sharing and maintain an up-to-date repository of technical documentation.
- Work closely with cross-functional teams, including software engineers and infrastructure teams, to optimize data infrastructure and ensure its seamless integration with other systems.

**What you'll need**
- Bachelor's degree in Computer Science, Engineering, or a related field.
- Proven experience as a Data Engineer or in a similar role, working with large-scale data processing and ETL pipelines.
- Strong programming skills in languages such as Python, Java, or Scala, with experience in data manipulation and processing frameworks like Apache Spark.
- Experience with SQL and database technologies (e.g., relational databases, SQL queries, data modeling).
- Proficiency in working with big data technologies such as Hadoop, Hive and knowledge of distributed systems and cloud computing platforms (e.g., AWS, Azure, GCP).
- Familiarity with data integration and workflow management tools such as Apache Airflow
- Knowledge of data warehousing concepts and experience with data warehousing solutions is highly desirable.
- Strong analytical and problem-solving skills, with the ability to analyze complex data-related issues and propose effective solutions.
- Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.
- Attention to detail and a strong commitment to delivering high-quality work within established timelines.

**What we’ll provide you**

We offer colleagues the opportunity to drive impact in the region while they learn and grow. As a full time Careem colleague, you will be able to:

- Work and learn from great minds by joining a community of inspiring colleagues.
- Put your passion to work in a purposeful organisation dedicated to creating impact in a region with a lot of untapped potential.
- Explore new opportunities to learn and grow every day.
- Work 4 days a week in office & 1 day from home, and remotely from any country in the world for 30 days a year with unlimited vacation days per year.
- Access to healthcare benefits and fitness reimbursements for health activities including gym, health club, and training classes.