BI Consultant/Lead (Azure Fabric and/or Open-Source Stack)
Part-time (2–3 days/week) | Remote | Long-term
A fast-growing Swiss-based consulting and technology company specializing in data analytics, AI implementations, and ERP systems is looking for a BI Consultant / Lead to strengthen its team. The company builds intelligent data and analytics solutions for international clients, combining modern cloud technologies with open-source flexibility.
Founded in 2021 and headquartered in Switzerland, it partners with organizations across industries to help them unlock the value of their data — from data integration and modeling to analytics and AI-driven insights.
You’ll join a dynamic environment where experts in Azure Fabric, data engineering, and BI work side by side with business stakeholders to deliver measurable business impact.
We mainly run two stacks:
• Azure Fabric: OneLake/Lakehouse, Fabric/Synapse pipelines, SQL endpoints, Power BI.
• Open-Source: Kafka, Apache NiFi, Iceberg, dbt, ClickHouse, Postgres
Scope/impact
• Own the conversation with business, shape the analytics roadmap/KPIs, and define the semantic model.
• Build the critical pieces hands-on or steer our (very capable) data engineering team end-to-end.
• Translate questions into robust data models, data contracts, and reliable dashboards; set QA/governance standards.
Must-haves (either track)
• Client-facing BI leadership; ability to frame problems and land simple, valuable solutions.
• Strong SQL and dimensional modelling (star/snowflake); comfortable defining metrics/semantics.
• Backlog writing for engineers (dbt tasks/ELT, data contracts, acceptance criteria).
Azure Fabric track (nice-to-haves become musts if choosing this track)
• Fabric/Synapse pipelines, Lakehouse/OneLake, SQL endpoints.
• Power BI (dataflows, DAX, tabular modeling, Row-Level Security).
• CI/CD for BI (deployment pipelines, versioning, environments).
Open-Source track (nice-to-haves become musts if choosing this track)
• Kafka event streams, Apache NiFi flows (ingest/enrichment/routing).
• dbt (models/tests/docs), ClickHouse for analytics at scale; familiarity with OLAP
engines.
• Apache Superset (dashboards, permissions) and basics of orchestration (e.g., Airflow/Argo) – nice to have.
Cross-cutting pluses
• Python for data wrangling; testing (dbt tests, unit/contract tests).
• Data quality & governance (SLAs, monitoring, lineage); GDPR awareness.
• Finance analytics background (P&L, margin, cash, working capital) is a strong plus.