Data Warehouse Architect (m/f) - Ärztekasse

Ä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 SSIS to extract, transform, and load data from various sources into the data warehouse.
• Design and optimize multidimensional data models using SSAS for efficient analysis and reporting.
• Develop interactive dashboards and reports using Power BI 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

• Bachelor's or master's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Data Warehouse Architect or similar role, with a focus on medical billing analytics.
• In-depth knowledge of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Power BI.
• Strong understanding of data modeling concepts, multidimensional databases, and OLAP cubes.
• Proficiency in SQL programming and database management.
• Experience working with healthcare data and familiarity with medical billing is considered a plus.
• Excellent analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Effective communication skills and the ability to collaborate with stakeholders at all levels.
• Proven track record of delivering high-quality solutions within established timelines.

What we offer

• 40h/per week
• 2 days home office option
• Highly innovative and international working environment
• Free parking
• Language trainings

Further information

A stimulating environment helps to find cool solutions to challenging complex requirements. We work in small agile teams where you can have impact and influence. You will find sharp engineers to have inspiring discussions with. We are solution-driven, but we don’t neglect the fun factor.

We look forward to receiving your application!

We look forward to receiving your application by e-mail at recruiting@aerztekasse.ch.