Senior Data Engineer for SaaS Platform

We are a Swiss-based company launching a B2B SaaS analytics platform for SMEs in Switzerland and Europe. We provide ready-made, standardized dashboards on a subscription model using Apache Superset, with Odoo as our primary data source. We have in-house Odoo developers and in-house Keycloak/IAM specialists. We are looking for an external Apache Superset & Data Architecture Expert to build the core analytics platform, ensure strict data isolation, and prepare the system for future AI integrations. Your Responsibilities: Deployment: Set up a production-ready, scalable Apache Superset instance on Swiss servers (Infomaniak using Jelastic Cloud, Managed Kubernetes, or cloud VMs). SSO Integration (Collaboration): Connect Superset to our Keycloak instance via OAuth2/OIDC (our internal team handles Keycloak; you will handle the Superset-side configuration, including Flask-AppBuilder Security Manager overrides if needed). Multi-Tenancy & Security: Design and implement a robust multi-tenant architecture within Superset. SME clients must be strictly isolated. You will configure Row-Level Security (RLS) and dynamic data access based on user attributes passed from Keycloak. Localization: Configure Superset for multi-language environments (German, French, English, Italian). Data Integration: Work with our Odoo team to connect Superset efficiently to Odoo data structures (PostgreSQL / Data Warehousing). AI Analytics Readiness: Architect the system to later support AI-driven ad-hoc queries (e.g., integrating LLMs for natural language-to-SQL generation within or alongside Superset). Required Skills & Experience: Deep, proven expertise in configuring and customizing Apache Superset for enterprise or SaaS use. Strong understanding of Multi-Tenancy and Row-Level Security (RLS) within BI tools. Experience mapping OIDC/OAuth2 tokens and roles into Apache Superset's security model. Solid DevOps foundation (Docker, Kubernetes, PostgreSQL) – experience with Infomaniak is a major asset. Python proficiency (essential for advanced Superset configurations). Experience or strong interest in AI/LLM integrations for data analytics. Screening Questions: Can you describe a past project where you implemented strict multi-tenancy (data isolation) inside Apache Superset? How did you approach Row-Level Security (RLS)? Our team is setting up Keycloak. What specific requirements or claims do you need from our Keycloak token to successfully automate user provisioning and role mapping inside Superset? Have you ever connected Apache Superset to an Odoo database or a replicated Odoo data warehouse? What is your experience with AI features in Superset (e.g., Superset AI text-to-SQL) or connecting custom LLM pipelines to PostgreSQL?