Senior Data Engineer

About Bosta: Launched in 2017, Bosta is an overnight delivery provider for E-commerce companies in Egypt. Leveraging technology to empower businesses is what we do best. Our goal is to disrupt the logistics industry by bringing technology and experience all together to provide a one-stop-shop for delivery solutions. We rely on advanced technology to deliver orders to our customers in a fast way. Businesses can track and connect with couriers and follow up on their orders - all in one system.About the role: We’re rebuilding Bosta’s data platform end-to-end: from MongoDB at the source, through a governed semantic layer that LLM-native tools (NL-to-SQL agents, AI analysts, embedded copilots) can sit on top of safely and cheaply. You will help own that rebuild.This is a hands-on role. You’ll set patterns, write the foundational code, and ship across the stack — from CDC and ingestion through dbt, the semantic layer, and the interfaces that BI tools and AI agents consume.Job Responsibilities End-to-end pipeline work: MongoDB CDC → ingestion → lakehouse → warehouse → dbt → semantic layer → BI/AI consumersCo-ownership of architecture decisions with the Data Engineering LeadCDC from production MongoDB without degrading operational DB performance; ingestion patterns that make adding a new source a config change, not a projectOrchestration that’s observable end-to-end (Airflow, Dagster, or Prefect)The dbt project: structure, conventions, tests, contracts, exposures, CIThe semantic / metrics layer (dbt Semantic Layer, Cube, or equivalent) — one canonical definition per business metricLLM-readiness: column-level documentation, PII tagging, query cost guardrails, materialized metric tables, and evals on AI-generated SQLMigration of existing logic out of the Tableau and Metabase sprawl into modeled, governed sourcesJob Qualifications4+ years across data engineering and/or analytics engineering — you’ve spent meaningful time on both sidesComfort spanning the stack: comfortable shipping a Debezium connector one week and a dbt mart the nextDeep dbt and SQL — you’ve owned a non-trivial project, not just contributed to oneProduction CDC experience (Debezium, Kafka Connect, Airbyte, or hand-rolled) against operational databases — bonus if that database was MongoDBA cloud warehouse you know deeply (Redshift, Snowflake, BigQuery, or Databricks)Strong Python; comfortable in Linux, infra-as-code, and CI/CDWorking understanding of how LLM tooling (RAG, NL-to-SQL, embedded agents) consumes a data platform — and what breaks when the platform isn’t readyStrong opinions on modeling, lightly held; bias toward observabilityBonus:MongoDB schema evolution at scaleProduction semantic-layer rollouts (dbt Semantic Layer, Cube, LookML, MetricFlow)Lakehouse formats (Iceberg, Delta, Hudi) or streaming experience (Kafka, Flink, Kinesis)Data catalog / lineage tooling (DataHub, Atlan, Collibra)Logistics, marketplaces, or other operationally heavy domainsEvals on AI-generated SQL or analytical reasoning