Senior BI & Data Specialist

Join our team

Headquartered in Basel (Switzerland), Regent Lighting employs around 600 people in six countries, is the market leader in Switzerland and one of the leading lighting manufacturers in Europe. Through distribution partners, our products are distributed internationally in 35 countries.

For our location in Svilajnac we are looking for a:

SENIOR BI & DATA SPECIALIST

• Operate and develop our Group-wide Data & Analytics platform on Microsoft Fabric - Lakehouse, Warehouse, Pipelines, Dataflows Gen2, Notebooks;
• Build and maintain the medallion architecture with standardized data ingestion from Dynamics 365 F&SCM, and provide certified, reusable semantic models as the single source of truth;
• Develop and operate Group-wide Power BI solutions and standardized KPI dashboards for Finance, Controlling, Sales, Supply Chain and Operations, and automate month-end close, forecast and budget reporting;
• Keep the platform running: monitor refreshes, jobs and pipelines, resolve errors and incidents, manage workspaces, permissions and row-level security, and watch Fabric capacity usage and cost;
• Work to ALM best practice across DEV – TEST – PROD with Fabric deployment pipelines and Git integration in Azure DevOps;
• Implement data governance standards (data security, sensitivity labels, RBAC, data lineage, cataloguing) and safeguard data quality across all legal entities;
• Take over solutions currently run by external partners, including structured knowledge transfer, and steer those partners: specify, review, accept deliverables;
• Enable key users to build their own reports on certified models, and translate business requirements from the business functions into functional and technical specifications.
• Reference: FlvCzVH86QomcBJx4z7K7slEgOB3dmRTZIyqKk2D2wB9EFEbqq5ZkZJL5AYMwLYf

• At least 5 years in Business Intelligence, Data Engineering or Reporting Solutions, including several years hands-on with Microsoft Fabric or the Azure data stack (Synapse, Data Factory);
• Power BI at expert level: DAX, Power Query, semantic modelling;
• Strong SQL, data warehousing and data modelling (star schema, medallion architecture);
• ALM / CI-CD for BI solutions: deployment pipelines, Git, Azure DevOps;
• Experience with ERP data, ideally Dynamics 365 F&SCM;
• KPI and management reporting;
• A degree in Business Informatics, Computer Science, Data Analytics or a comparable field — or equivalent professional experience;
• Fluent English; German is an advantage;
• Structured, self-driven working style, ownership for production operations, and the ability to explain technical topics so that business colleagues follow.

• Dynamics 365 F&SCM or AX data model, data entities, integration via Link to Microsoft Fabric / Synapse Link;
• Azure Data Services (Data Factory, Synapse);
• Python / PySpark;
• Data governance with Microsoft Purview;
• Certifications PL-300, DP-600 or DP-700.

• An innovative company with a dynamic environment and requirements;
• Collaboration with our experienced team in Switzerland;
• An environment with a fail fast mentality with an open mind for new technologies and methodologies;
• The possibility to work on new and exciting projects in an ever-changing business landscape;
• Flexible working hours.