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.

Work format: B2B contract, paid days off (holidays, sick leave, public holidays), budget for a laptop.