Analytics Engineer
Sika · Zurich
Job description
About the role
Sika, a specialty chemicals company active in the building and industrial manufacturing sectors, is looking for an Analytics Engineer. The role builds and maintains data models in dbt on Databricks that turn raw source data into reliable, documented data products, and promotes best practices for BI solutions.
Key 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 BI solutions: data model design for reporting, dashboard templates and CI/CD pipelines.
- Enable self-service by giving business users certified datasets, clear documentation and guidance so they can build their own analyses.
- Set up data 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, and coach them on modelling and BI best practices.
Required profile
- Educational background in business economics or similar.
- Track record of building data models that feed production reports and dashboards.
- Confidence working with business teams to turn their questions into clear metrics and agreed KPI definitions.
- Fluency in English.
Required skills
- 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 query and table performance tuning.
- Knowledge of SAP data and its business logic in finance, sales or supply chain (a strong plus).
- Automated tests, freshness checks and reconciliation of figures against source systems.
- Reporting tools such as Power BI and self-service analytics such as Genie.
- Software engineering practices for data: Git, code review, CI/CD and some Python for automation.
What we offer
- An attractive employment package with good social benefits, an excellent pension fund and accident insurance.
- Competitive salaries aligned with local market benchmarks and the scope of the role.
- A supportive work environment that values diversity and inclusion.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Switzerland.
Salary: DevOps Engineer Based on 11 job offers in SwitzerlandApply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 1 day ago
Expires 1 month from now
11 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
Sika
Zurich
Related job offers
-
DevOps Engineer Workplace Client Engineering (m/w/d)
Zürcher Kantonalbank Zurich -
Senior Platform Engineer (AI Agents Platform)
worldreplica.ai Zurich -
Cloud Architect – AI, Retail & Enterprise Solutions
Haystack Zurich -
R&D Engineer - Control Firmware (80-100%)
abb Quartino -
Intern - Data Analyst / Economic Affairs
United Nations Conference on Trade and Development GENEVA