Senior Data Analyst - Prepit
Dsquares 6th of October, Giza, Egypt
Technology, Information and Internet · 201-500 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
You will be responsible for designing and maintaining ETL/ELT pipelines while analyzing data to drive product and business decisions. You will also collaborate with cross-functional teams to build dashboards and ensure high data quality standards.
What they look for
Requirements
Candidates must hold a bachelor's degree in a relevant field and possess at least 4 years of experience in data analysis. Strong proficiency in SQL and hands-on experience with ETL processes and data visualization tools like Metabase are required.
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 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.
- 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.
- 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.
Similar roles
-
Data Analyst
Lucid Motors King Abdullah City, Makkah, Saudi Arabia
-
Data Analyst
Lucid Motors King Abdullah City, Makkah, Saudi Arabia
-
Senior Analytics Engineer
Asana Vancouver, British Columbia, Canada · CA$106K–CA$120K/yr
-
Financial Data Analyst – Army National Guard
RadiantHire Solutions Inc. Arlington, Virginia, United States
-
Sr Business Data Analyst
DHL (Supply Chain) Olive Branch, Mississippi, United States · $70K–$115K/yr
- Data Analyst Strategy and Operations