Data Warehouse Architect (m / f)

Ä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

• Design and develop scalable data warehouse solutions to support medical billing analytics requirements.
• Collaborate with cross-functional teams to gather and understand business requirements and translate them into technical specifications.
• Implement ETL processes using dbt to transform and load data from various sources into the data warehouse.
• Design and optimize multidimensional data models for efficient analysis and reporting.
• Develop interactive dashboards and reports to visualize and communicate insights derived from medical billing data.
• Perform data profiling, cleansing, and validation to ensure data accuracy and integrity.
• Monitor and troubleshoot data warehouse performance issues, optimizing queries and processes for improved efficiency.
• Stay abreast of industry trends and best practices in data warehousing and analytics to recommend and implement innovative solutions.

Requirements

What we offer