DWH Architect (Data Modeling)

Kitopi is the world’s leading tech-powered multi-brand restaurant. With a mission to satisfy the world’s appetite, Kitopi operates a portfolio of both invested and franchised F&B brands, serving as enablers in the food market by helping brands to grow and scale, both in the delivery and dine-in space.
Launched in Dubai, UAE in January 2018, Kitopi has grown to become one of the greatest success stories in the cloud kitchen and food tech space. In July 2021, Kitopi announced its $415 million Series C funding round, led by the world’s largest technology-focused investment fund, Softbank Group Corp’s Vision Fund 2. This investment catapulted Kitopi to the prestigious Unicorn status, making it the fastest Unicorn to have emerged from the MENA region.
As a leading food-tech business, Kitopi’s growth has been largely fueled by its innovative and scalable software solutions. Kitopi’s kitchens are powered by its proprietary Smart Kitchen Operating System (SKOS) - an in-house suite of applications that optimizes cloud kitchen operations in real-time. As part of its growth roadmap, technological innovation, data science,  artificial intelligence, and robotics will take center stage as Kitopi continues to reinvent the food industry as we know it today.
With over 4,000 employees, Kitopi currently operates 200+ locations across the UAE, KSA, Kuwait, Bahrain, and Qatar, and runs its engineering hub in Krakow, Poland, its robotics hub in Denmark, and its global customer experience center in Dubai, UAE.
At Kitopi, we are committed to empowering our business and product teams with robust reporting and analytics capabilities, enabling data-driven decision-making and fostering innovation. Collaborating closely with our product squads, we strive to leverage data-powered products to drive growth and enhance operational efficiency. 
Within our structured data organization, comprising both business domain-focused verticals and technical practice-focused horizontals, we recognize the pivotal role of data modeling in elevating our reporting and analytics practices. You’ll be working with a team of Data Engineers, ML Engineers, and Data Analysts in collaboration with product and business managers across the company’s data ecosystem to design and continue to scale the data models that make up our data warehouse and support decision-making across our product and business. 

Responsibilities:

• In brief:
• Set up the data modeling practice, processes and platform. Own the data models that make up our data warehouse. 
• Lead the highly iterative dimensional modeling process. 


• In detail: 
• Develop a comprehensive understanding of our products and operations and become intimately familiar with the source data and its generating systems, using a combination of documentation, direct interaction with engineering teams, and systematic data profiling. 
• Collaborate with the data, product, and business teams to gather and distill their reporting and analysis requirements and work together to design effective data models that accurately represent the underlying business processes. 
• Establish data modeling and naming standards that promote consistency and best practices across the data warehouse and communicate these standards effectively to the broader data team. 
• Define and maintain a high-level data warehouse architecture, including fact, dimension, and aggregation layers, and the relationships between them. 
• Work with members of the data team to design data models that effectively measure performance and capture the performance drivers for the various business processes in our complex business. 
• Write, maintain, and communicate data design documentation to ensure that the broader data team has a clear understanding of our data models and how they work. 
• Oversee the implementation of data models, ensuring that they are accurate, efficient, and scalable, and that they meet the reporting and analysis needs of the broader organization. 
• Develop, maintain, and manage the end-to-end data modeling process, from requirements gathering to model design to implementation and ongoing maintenance. 
• Collaborate with the data engineering team to design effective data pipeline infrastructure, abstractions, and tooling that support our data modeling efforts. 
• Collaborate with cross-functional teams to understand specific analytics requirements and create standardized data models that empower end-users to independently generate insights through self-service analytics tools.  
• Advocate for data modeling depth, rigor, and consistency across the data and business teams, and coach data scientists and engineers on the principles of effective data modeling. 

Requirements:

• At Kitopi, we value alignment with our mission and principles. The successful candidate will share these values and work in accordance with them. 
• A Bachelor's or Master's degree in Engineering, Computer Science, Technology, or similar is required. 
• 5+ years of experience working in data, with experience spanning multiple data disciplines, including data science, data engineering, data analysis, and data warehousing.  
• 3+ years of experience in data modeling at a high-growth consumer product company or similar. 
• Keen on gaining a deep understanding of our business, product, and operations. You should have a piercing eye for important business questions that the data models would be able to answer. 
• A drive for consistency, a mind for abstraction, and attention to detail are necessary traits for this role. 
• Experience with modeling diverse product and business processes, including operational process data (e.g., Kitchen Operations, Logistics, and Supply chain), D2C (mobile app event tracking, A/B testing), Growth data(Marketing, brands, sales, and food menu), Customer experience(retention, contact center, feedbacks, ratings, and reviews), Strategic data(market expansion, kitchen-brand fit), scrapping data(brand health and competition landscape), Subscription data(for our mealplans), user experience(for our dine-in and QSR), experimentation(for our product initiatives) and financial data. 
• A strong grasp of dimensional modeling concepts, such as fact table grain definition, logical views, dealing with non-additive facts, periodic and accumulating snapshots, changing dimensions, and bridge tables. 
• Experience in designing data pipelines (e.g., AirFlow DAGs), including identifying dependencies, opportunities for abstraction, and performance bottlenecks. 
• Deep familiarity with relevant technologies is a plus. 

Technologies We Use:

• Data Warehouse / Big Data: Snowflake, ADL, and Postgres 
• Reporting: Power BI 
• Data Pipelines: Kafka, Python, SQL, Airflow, Airbyte, and DBT 
• ML Ops: Amazon SageMaker 
• Platform: AWS 
• Repository: Gitlab 
• Analysis: SQL, Python, and Excel 
• Presentation: Power BI, Excel 365, and PowerPoint 
• Documentation: Confluence 
• Sprints and Backlog: Jira 

Perks & Benefits:

• Expanded tech stack
• ESOP - Employee Stock Option Plan 
• You choose a form of employment (26 paid days off on B2B)
• Additional paid days off for volunteer activities
• U-Day - time for medical check-ups, examinations, or diagnosis
• Top-notch equipment: high-end MacBook Pro + additional accessories
• Support for your development: 2 000 PLN growth annual budget available to every employee, internal initiatives: webinars/workshops, knowledge sharing sessions internal conferences (Kitopi Academy)
• Mentoring program 
• Freedom Day - time for things you are passionate about
• Free English classes
• Worksmile benefit platform (private medical healthcare, Multisport card, vouchers, etc.) 
• Life insurance 
• Wellbeing program (psychological care, physical health, and socializing activities)
• Referral bonus 
• Great office with fruit & snacks, social budget for every team & awaydays, and more!

Recruitment Process and TimelineFirst, you apply and let our recruiters review your profile. After reviewing, you will receive a link to book a meeting with a recruiter at your convenience to share more about yourself and for us to get to know you better. If you have been shortlisted, you will have the opportunity to meet our hiring managers. Depending on the scope of the role and the function, you may need to attend 2-3 rounds (which might include case study, role-play, trial, or live coding - this will be communicated to you in the initial conversation). Upon successful completion, your recruiter will get in touch with you to discuss the offer. We aim to take you through this process within 2-3 weeks.
So, what does it really mean to work at Kitopi?We are constantly striving to make Kitopi the best place to work in the world, by empowering you to be the best version of yourself every day. Our company values act as our guiding principles to help ensure that everyone feels safe, included, and like they truly belong. 
Kitopi is an equal opportunity employer. While we currently operate in 6 countries, we are over 70 different nationalities of talented Kitopians. We celebrate our rich diverse backgrounds, lifestyles, and cultures and have a 0 tolerance policy towards racism, bigotry, and hate. Please apply if you see a position that makes your heart skip a beat and help us build a company where we're all proud to work for.
Along with offices in all the markets we operate in, we also believe in a “work from anywhere” policy - you get to choose the environment you operate in because we believe this will help you deliver work you’re proud of. 
Tech-enabled and customer-obsessed, at Kitopi, we are a team of passionate humans who are on a mission together to satisfy the world’s appetite.