Ärztekasse Genossenschaft provides business process outsourcing and eHealth solutions to health professionals so they get relief from administration and can focus on medical work.
In the context of an innovation initiative, Ärztekasse is renewing and extending their products. To support this digitalization step, we are looking for a skilled Data Warehouse Architect to design, develop, and maintain our data infrastructure. This role offers an exciting opportunity to play a key role in optimizing our data architecture and driving actionable insights to improve operational efficiency and decision-making processes.
Data Warehouse Architect (m/f)
Pensum: 80-100%
Start: immediately or by appointment
Duration: unlimited
Location: Urdorf
Main Tasks
1. Own the warehouse data model Define and evolve the canonical representation of core business entities and processes Ensure consistent definitions and conformed concepts across all reporting and analytics use cases.
2. Architect a sustainable warehouse design across core (3NF) and dimensional layers Drive a pragmatic Inmon-style architecture: stabilize source data in a 3NF core model, and publish analytics-ready structures via dimensional marts Design the model so it remains robust against expected source-system replacements and changing operational landscapes (avoid “source-shaped” modeling where possible). Anticipate and formalize implicit requirements
3. Create and defend the mid-/long-term data architecture roadmap Develop a multi-stage roadmap aligned with the broader system landscape Explain design decisions clearly to technical and non-technical stakeholders - and defend trade-offs.
4. Implement and govern transformation logic with dbt
5. Enable reporting via dimensional marts and an ODS view layer
6. Own transactional and master-data reporting end-to-end: Take responsibility for the full portfolio of transactional reports and master data: requirements, design, implementation (where applicable), and stable operations.
7. Ensure data quality, auditability and performance
Requirements
8. Bachelor’s or Master’s degree in Computer Science / Information Systems (or equivalent experience).
9. Several years of experience designing and evolving enterprise data models in a data warehouse context.
10. Strong SQL skills and experience with relational databases in a DWH/analytics environment).
11. Strong command of dimensional modeling (and a solid understanding of normalized/core (3NF) modeling in hybrid DWH architectures.
12. Experience building and operating ELT/ETL transformations (ideally with dbt or similar), including testing, documentation and version control.
13. Ability to understand complex domains and translate business processes into robust, reusable data structures (healthcare/insurance or billing is a plus, not required).
14. Demonstrated architect mindset: anticipate implicit requirements, design for change, develop mid-/long-term roadmaps, and explain/defend modeling decisions to stakeholders.
15. Strong communication skills and ability to collaborate across teams and levels.
16. English required; German and/or French is a plus.
What we offer
17. 40h/per week
18. Highly innovative and international working environment
19. Free parking
20. Language trainings