Data Analyst - Prepit
Dsquares · 6th of October, Giza, Egypt
Technology, Information and Internet · 201-500 employees
About the role
As a Data Analyst, you will analyze data, build and maintain ETL processes, and deliver insights that drive product and business decisions. You will collaborate with various teams to develop scalable reporting solutions and support a data-driven culture.
What they look for
Requirements
A bachelor's degree in a related field and 2 years of experience as a Data Analyst or in a similar role are required. Strong proficiency in SQL and hands-on experience with ETL processes and relational databases are essential.
Benefits
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 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.
- 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.
- 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.
