Data Analyst - Prepit

Posted Yesterday
Be an Early Applicant
6th of October City, Al Jīzah, EGY
In-Office
Junior
Artificial Intelligence • Software
The Role
Collect, clean, transform, and analyze data; design and maintain ETL/ELT pipelines; write SQL; build Metabase dashboards; monitor data quality; support data modeling; perform ad hoc analyses and document processes to inform product and business decisions.
Summary Generated by Built In

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 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.
  • 2 years of experience as a 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.

Skills Required

  • Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, Engineering, or related field.
  • 2 years of experience as a 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.
  • Familiarity with cloud platforms and modern data architectures.
  • Excellent analytical, problem-solving, and communication skills.
  • Ability to work independently in a fast-paced startup environment.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Cairo, Cairo
301 Employees
Year Founded: 2012

What We Do

Dsquares is a loyalty and rewards company that helps businesses increase customer loyalty and retention. As the Global Loyalty Expert, the company equips businesses with an impressive array of tools that span the entire spectrum of strategic commercial planning, merchant management, and state-of-the-art AI and Data Analytics. This robust platform seamlessly integrates modern capabilities like ingenious pointing systems, electrifying e-vouchers, captivating gamification elements, and enlightening analytics tools. Operating across more than 10 countries in the Middle East and Africa, Dsquares partners with enterprises across diverse sectors, including banking, telecom, and retailers, revolutionizing the way businesses thrive in the competitive landscape.

Similar Jobs

In-Office
6th of October City, Al Jīzah, EGY
5629 Employees

Lionbridge Logo Lionbridge

General Application - GLOBAL

Information Technology • Natural Language Processing
In-Office or Remote
15 Locations
4622 Employees
In-Office
6th of October City, Al Jīzah, EGY
155459 Employees

Dsquares Logo Dsquares

AI Transformation Specialist

Artificial Intelligence • Software
In-Office
6th of October City, Al Jīzah, EGY
301 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account