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 providing solutions for the health sector since 1950. We are an innovative pioneer in the fields of ventilators, automated pipetting, sample management and in the development of process sensors.Hamilton Services acts globally as a service provider within the Hamilton companies. Whether the matter concerns human resources, ICT or compliance etc., we are responsible for performing important tasks for all Hamilton companies in Europe and Asia.

How you can make a difference:

Role Overview:

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

Key Responsibilities:

Data Engineering & 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 within data warehouses (e.g., Snowflake, Azure Synapse, BigQuery, Redshift, etc.)
• Maintain and improve data lake and warehouse structures aligned with best practices and governance standards

Data Modeling & 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 calculated measures
• 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 data validation, versioning, and documentation standards
• Contribute to data governance initiatives and ensure compliance with data security and privacy regulations (GDPR, etc.)
• Monitor and troubleshoot data pipelines and BI performance issues proactively

That's what you bring along:

Technical Skills

• Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related field
• 3+ years of experience in data engineering, BI development, or data modeling roles
• Strong SQL skills and experience with relational and dimensional data modeling (star/snowflake schemas)
• Hands-on experience with modern data warehouse technologies (e.g., Azure Synapse, Snowflake, BigQuery, Redshift)
• Proficiency in ETL/ELT tools (e.g., Azure Data Factory, dbt, Informatica, Talend, SSIS)
• Experience with BI tools such as Power BI, Tableau, or Qlik
• Familiarity with scripting or programming languages (Python, PySpark) is a plus
• Solid understanding of data governance, metadata management, and data lifecycle principles

Soft Skills

• Strong analytical and problem-solving abilities
• Excellent communication and collaboration skills with both technical and non-technical stakeholders
• Structured and detail-oriented working style
• Proactive mindset with a focus 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 cooperative and down-to-earth environment? At Hamilton, we not only offer a motivating working environment, but also various leisure activities and modern working conditions. Our interactions at eye level encourage open communication and a pleasant working environment. Become part of a team where your skills are valued and innovative ideas are fostered. Interested? Then apply online using the "Apply now" button.If you have any questions, please contact us at jobs@hamilton.ch with the following details:

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

Applications by post or e-mail can unfortunately not be considered.