Data and BI Engineer

The Data & BI Engineer plays a critical role in transforming raw data from the Simplex Suite platform into clean, well-structured, and trustworthy datasets, as well as insightful reports and dashboards that empower business decisions. Reporting directly to the CTO, this position is responsible for designing data models and analytical layers that provide leadership and customers with a clear, real-time view of performance across orders, customers, loyalty, and operations for global QSR and F&B brands. This is a hands-on role where you will be deeply involved in every stage of the data journey—from ingestion and transformation to warehousing and business intelligence—ensuring accuracy, timeliness, and actionable insights.

Key Responsibilities

Data Modelling & Architecture
Design and build data models and analytical layers, including warehouses, marts, and data lakes where applicable. Convert raw, unstructured source data into clean, conformed, and well-documented structures such as facts, dimensions, and semantic/metrics layers. Maintain a single source of truth for business metrics to ensure consistency across all reports and dashboards.

Raw Data, ETL & Transformation
Ingest raw data from various sources including the platform, databases, and third parties. Develop reliable ETL/ELT pipelines using strong SQL and Python skills. Ensure data quality, lineage, and freshness by automating and scheduling pipelines with robust monitoring and failure recovery mechanisms.

Data Warehousing & Lakes
Build and maintain scalable, cost-effective, and high-performance data warehouses and lakes. Manage storage, partitioning, and modeling to support fast and reliable analytical queries.

BI, Reporting & Dashboards
Create and maintain clear, accurate, and decision-ready reports and dashboards. Collaborate with leadership and teams to understand key business questions and deliver data-driven answers. Proactively identify trends, outliers, and actionable opportunities rather than simply responding to requests.

Business Impact
Measure the effectiveness of data models, reports, and dashboards by their ability to influence decisions and drive business outcomes. Translate complex analysis into plain, actionable insights for leadership and customers. Provide curated data views to CRM, loyalty, and marketing teams to enhance segmentation and campaign effectiveness.

Data Quality, Security & Practice
Own data quality by ensuring accuracy, reconciliation, and trustworthiness of all business metrics. Implement data security and privacy best practices, including least-privilege access, secure storage of secrets, and safeguarding sensitive information such as PII and payment data. Follow a secure software development lifecycle (SDLC) with Git, testing, code reviews, and CI/CD pipelines, ensuring reproducible and well-documented data workflows.

Required Qualifications

- Bachelor’s or master’s degree in Computer Science, Data Science, Statistics, or a related field.
- Minimum of 6 years of hands-on experience in data engineering and business intelligence, covering raw data processing, transformation, data warehousing, data lakes, ETL/ELT, and reporting.
- Expert-level SQL skills and solid proficiency in Python for data manipulation and pipeline development.
- Proven experience in data modeling (dimensional and semantic layers) and managing data warehouses or lakes.
- Strong expertise in BI and dashboarding tools such as Power BI, Tableau, Looker, or Metabase.
- Demonstrated ability to deliver data solutions that create measurable business impact.
- Security-aware and privacy-conscious with experience owning projects end to end.

Preferred Qualifications and Benefits

While not explicitly listed, candidates who understand the QSR and F&B industries and can connect data insights directly to business outcomes will excel. The role offers the opportunity to work strategically and hands-on in a fast-paced environment, contributing directly to the success of global brands through impactful data solutions.

---

This role demands a self-starting, detail-oriented professional who thrives on delivering outcomes. Success will be measured by timely delivery of current, in-depth data views; trusted and reconciled data layers; impactful analytics that influence decisions; high adoption of BI tools; and strict adherence to data security and privacy standards.