Senior Data Analyst - Prepit

Location: 6th of October City, Giza Governorate, Egypt

Department: Product

Workplace: hybrid

Employment Type: full

Description

A New Chapter: Dsquares X Prepit

We’re excited to share that Prepit has officially joined the Dsquares family! This acquisition marks a new chapter where we combine Prepit’s innovation and agility with Dsquares’ expertise and scale to build even stronger, more impactful loyalty and engagement solutions.

About Prepit:

Prepit aims to bridge the gap between restaurants & their diners, building lasting relationships using technology enabled solutions. Through a loyalty engine and a gamified online ordering experience, Prepit enables restaurants to collect critical diner data, identify trends in customer behavior, and directly communicate with diners to generate recurring business.

Our People is our Brand
Developing seamless loyalty solutions is only possible with a great team. Our culture is open, collaborative, and empowering. If you're passionate, driven, and eager to make an impact—you'll fit right in.

About The Role:

As a Senior Data Analyst at Prepit, you will be responsible for analyzing data, building and maintaining ETL processes, ensuring data quality, and delivering insights that drive product and business decisions. You'll collaborate closely with Product, Engineering, and Business teams to develop scalable reporting solutions and support a data-driven culture.

Key Responsibilities

• Collect, clean, transform, and analyze data from multiple sources.
• Design, develop, and maintain ETL/ELT pipelines to ensure reliable and timely data availability.
• Write efficient SQL queries to extract, validate, and analyze data.
• Build and maintain dashboards and reports using Metabase.
• Partner with Product, Engineering, and Business teams to define KPIs and reporting requirements.
• Monitor data quality and implement validation checks to ensure data accuracy.
• Perform ad hoc analyses to identify trends, opportunities, and business insights.
• Support data modeling and optimize datasets for reporting and analytics.
• Document data sources, ETL processes, and reporting logic.
• Continuously improve data workflows through automation and process optimization.

Requirements

• Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, Engineering, or a related field.
• +4 years of experience as an Senior Data Analyst or in a similar role.
• Strong proficiency in SQL.
• Hands-on experience designing and maintaining ETL/ELT processes.
• Experience working with relational databases (PostgreSQL, MySQL, or similar).
• Experience creating dashboards and reports using Metabase.
• Good understanding of data modeling and data warehousing concepts.
• Experience with Python (Pandas) for data analysis or automation is a plus.
• Familiarity with cloud platforms and modern data architectures is an advantage.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work independently in a fast-paced startup environment.

Benefits

• Comprehensive Wellbeing: Enjoy peace of mind with our private medical insurance and life cover.

• Work-Life Balance: Achieve optimal well-being with our hybrid work environment, generous maternity and paternity benefits, and regular team-building events.
• Continuous Development: Expand your horizons through our commitment to learning and development opportunities.