Analytics Engineer: Data Products & BI

Sika AG; Zürich; On-site; CHF 110,000 - 170,000; Full time

Benefits offered by this job

Social benefits

Pension plan

Accident insurance

Job summary

Sika AG is seeking a data engineer to build and maintain data models in dbt on Databricks, turning raw source data into reliable, well-documented data products. You will translate business questions into clear data structures, KPIs and shared metric definitions, enabling self-service analytics for the business.

The role emphasizes governance, data quality and CI/CD for BI solutions, coaching analysts and engineers, and partnering with cross‑functional teams to deliver trusted dashboards using

Qualifications

• Educational background in business economics or similar.
• Track record of building data models that feed production reports and dashboards.
• Strong SQL and hands-on dbt experience in production, including incremental models, tests, macros and documentation.
• Solid data modelling skills: dimensional models with fact and dimension tables, and layered architectures from raw data to business-ready tables.
• Familiarity with data mesh concepts and experience building data products.
• Experience with Databricks, including Unity Catalog and performance tuning of queries and tables.
• Knowledge of SAP data and its business logic in areas such as finance, sales or supply chain (a strong plus).
• Confidence working with business teams to turn their questions into clear metrics and agreed KPI definitions.
• Care for data quality: automated tests, freshness checks and reconciliation of figures against source systems.
• Experience with reporting tools such as Power BI and self-service and natural-language analytics such as Genie.
• Software engineering practices applied to data: Git, code review, CI/CD and some Python for automation.
• Fluency in English.

Responsibilities

• Build and maintain data models in dbt on Databricks that turn raw source data into reliable, well-documented data products.
• Translate business questions and requirements into clear data structures, KPIs and shared metric definitions.
• Define and promote best practices for building BI solutions: data model design for reporting, dashboard templates and CI / CD pipelines.
• Enable self-service: give business users certified datasets, clear documentation and guidance so they can build their own analyses on trusted data.
• Set up governance for data consumption, including access rights, certified versus ad hoc content, ownership, and lifecycle management of reports and datasets.
• Work with data engineers, analysts, BI developers and business stakeholders across domains, and coach them on modelling and BI best practices.

Skills

SQL

dbt

Data modelling

Data mesh concepts

KPIs & metrics

Power BI

Genie

Python

Git/CI-CD

English fluency

Education

Educational background in business economics or similar

Tools

Databricks

Unity Catalog

SAP data

Power BI

Genie

Git

CI/CD

Python

Job description

Sika AG is seeking a data engineer to build and maintain data models in dbt on Databricks, turning raw source data into reliable, well-documented data products. You will translate business questions into clear data structures, KPIs and shared metric definitions, enabling self-service analytics for the business.

The role emphasizes governance, data quality and CI/CD for BI solutions, coaching analysts and engineers, and partnering with cross‑functional teams to deliver trusted dashboards using