Senior Business Intelligence Report Modeler/Developer 80 - 100 % (f/m/d)

Staff discounts for many leisure activities and services

Senior Business Intelligence Report Modeler/Developer 80 – 100 % (f/m/d)

True to the vision "We drive innovation to improve people’s lives," the Hamilton companies have been delivering solutions for the healthcare industry since 1950. We are an innovative pioneer when it comes to ventilators, automated pipetting and storage of samples, as well as the development of process sensors.

As part of the Business Unit Shared Services (SHS) of Hamilton Bonaduz AG, this area takes on central tasks for the Hamilton companies. Teams in HR, ICT, Corporate Communication, Facilities, and Finance ensure that processes run smoothly and employees worldwide are optimally supported.

What you can achieve:

Role overview:

As a Data Engineer / BI Modeler, you play a key role in designing, building, and maintaining the company’s data architecture and business intelligence solutions. You ensure that high-quality, consistent, and reliable data is available for analysis, reporting, and decision-making. You work closely with business stakeholders, data analysts, and IT teams to translate business requirements into scalable data models and efficient ETL processes.

Main tasks:

Data engineering and architecture

• Design, develop, and maintain scalable data pipelines (ETL/ELT) to integrate data from multiple systems and sources
• Ensure data quality, consistency, and integrity across all environments
• Optimize data flows and query performance in data warehouses (e.g., Snowflake, Azure Synapse, BigQuery, Redshift, etc.)
• Maintain and improve data lake and warehouse structures in accordance with best practices and governance standards

Data modeling and BI

• Design and implement logical and physical data models optimized for analytics and self-service BI tools (Power BI, Tableau, Qlik, etc.)
• Develop reusable semantic models, datasets, and metric calculations
• Collaborate with business stakeholders to define KPIs, metrics, and analytical dimensions
• Support end users in understanding and accessing data for reporting and analysis

Governance & Quality

• Implement standards for data validation, versioning, and documentation
• Contribute to data governance initiatives and ensure compliance with data protection and data security regulations (GDPR, etc.)
• Proactively monitor and troubleshoot data pipelines and BI performance issues

What you bring:

Technical skills

• Bachelor’s or Master’s degree in computer science, data processing, information systems, or a related field
• At least 3 years of experience in data processing, BI development, or data modeling
• Strong SQL skills and experience with relational and dimensional data modeling (star/snowflake schemas)
• Practical experience with modern data warehouse technologies (e.g., Azure Synapse, Snowflake, BigQuery, Redshift)
• Proficiency with ETL/ELT tools (e.g., Azure Data Factory, dbt, Informatica, Talend, SSIS)
• Experience with BI tools such as Power BI, Tableau, or Qlik
• Knowledge of scripting or programming languages (Python, PySpark) is an advantage
• Solid knowledge of data governance, metadata management, and data lifecycle principles

Soft skills

• Strong analytical and problem-solving skills
• Excellent communication and collaboration skills with technical and non-technical stakeholders
• Structured and detail-oriented working style
• Proactive mindset focused on continuous improvement and automation

Preferred technology stack

• Cloud: Microsoft Azure (Data Lake, Synapse, Data Factory, Power BI)
• Database: SQL Server / Snowflake
• Tools: dbt, Git, Jira, DevOps CI/CD

Learn more about career opportunities at Hamilton at jobs.hamilton.ch.

Do you share our values and feel at home in a collegial and down-to-earth environment? At Hamilton, we offer not only a motivating work environment but also various leisure activities and modern working conditions. Our informal culture promotes open communication and a pleasant atmosphere. Become part of a team where your skills are valued and space is created for innovative ideas. Interested? If you have any questions, please contact us at jobs@hamilton.ch and provide the following details:

Reference: JR-5324-fjs/Contact: Lisa Nahrgang

Applications by mail or email unfortunately cannot be considered.

What We Offer

What We Offer

Green Sense: The healthy and sustainable staff restaurant

Sports & Fun – see what surprises lie in store

Advisory services provided by external partners for various life situations

Diverse opportunities for further training and development

An informal working environment

Compensation time for bridging days between Christmas and New Year

A dedicated pension fund with the possibility to choose from three options

I live out my artistic, romantic side in music and my serious side at work.