Data Engineer – Data Warehouse & Reporting (w/m)

Ärztekasse Genossenschaft develops innovative software solutions for health professionals in close collaboration with its partners and suppliers. Our digital services support medical practices across Switzerland with reliable, secure, and efficient solutions in the healthcare domain.

As a Data Engineer, you will play a key role in strengthening our reporting landscape by enhancing client-facing reports and providing reliable, insightful data to support both operational processes and strategic business decisions.

Our delivery organization is geographically distributed, offering you the opportunity to work closely with interdisciplinary teams located in Urdorf and Geneva. In this role, you will contribute your expertise to data analysis, internal data quality assurance, and the development of intelligent, high-value reports tailored to our clients’ needs. We are looking for an experienced engineer who enjoys turning complex data into meaningful insights and who thrives in a collaborative, multi-site environment.

Data Engineer – Data Warehouse & Reporting (w/m)

Pensum: 80-100%
Start: immediately or by appointment
Duration: unlimited
Location: Zurich area (Urdorf or Geneva)

Background

Our data warehouse architecture, tooling, and target reporting platform are already defined. We operate an Inmon-style data warehouse architecture with a core (3NF) layer and dimensional layers, using Apache NiFi for ingestion, dbt for transformation, and JMIX reporting as our target reporting platform.

The role is created to accelerate implementation and operationalization by taking ownership of concrete development tasks across ingestion, transformation, and reporting enablement.

Scope Clarification

This is an implementation-focused role. The position does not define the overall data warehouse architecture or reporting strategy but executes development tasks within an already agreed architectural and methodological framework.

Purpose of the Role:

You will actively contribute to the rollout and scaling of our existing data warehouse and reporting platform by implementing data pipelines, transformation logic, dimensional models, and reporting-ready datasets. Your work will directly increase delivery speed and reduce bottlenecks for the existing team.

Your Responsibilities

• Implement and maintain ELT pipelines using Apache NiFi and dbt
• Develop transformation routines for the core (3NF) data warehouse structures according to established standards using dbt
• Build dimensional models (facts and dimensions) using dbt
• Apply agreed modeling patterns, naming conventions, and loading strategies
• Implement data quality checks using dbt tests and support stable daily operations
• Prepare reporting-ready datasets and support report implementation using JMIX reporting
• Develop maintainable reporting templates
• Collaborate closely with existing DWH and reporting leads, taking ownership of assigned backlog items

Required Profile

• Strong SQL skills and solid understanding of relational databases
• Practical experience implementing data warehouses
• Hands-on experience with dbt and data pipelines (Apache NiFi or comparable tools)
• Comfortable working within defined architectural guidelines and standards
• Reporting experience is a plus, especially template-based or Jasper-style reporting
• Structured, quality-oriented working style
• Very good English skills (German or French is a plus)

What We Offer

• A meaningful role in the Swiss healthcare sector
• A clearly scoped, hands-on engineering role with real impact
• Modern data tooling and established architecture
• Collaboration in a professional, supportive, and distributed team
• Flexible working conditions and long-term perspective within a stable cooperative organization

We look forward to receiving your application!