Data Lake Developer SQL Server, SSIS & Healthcare Data
I-Ray IT Solutions AB · Solna · 12 månader – upp till 2 år · Deadline 2026-10-27
I-Ray IT Solutions AB is seeking a **Data Lake Developer** for a full-time consultancy assignment running until 31 December 2027, with a possible extension through 2028. The position is **mostly remote**, with a requirement to work on site in Umeå one to two days per quarter. The role focuses on developing modern, secure data warehouse and data lake solutions for the healthcare sector. Key responsibilities include designing and optimizing SQL Server database structures, migrating sensitive patient data from legacy systems, building ETL workflows with SSIS and Python, implementing Kimball dimensional models, and integrating healthcare data across multiple platforms while ensuring strict legal and security compliance. Applicants must possess competency level 3 and demonstrate strong communication skills in both **Swedish and English**. Required qualifications include at least five years of SQL development experience with large databases, at least five years of database development within healthcare, and hands-on experience migrating sensitive patient data. Preference is given to candidates with at least five years of experience in Microsoft SQL Server, SSIS, and Kimball dimensional modeling, as well as knowledge of Python ETL development and healthcare standards such as HL7 FHIR and openEHR.
Data Lake Developer – SQL Server, SSIS & Healthcare Data
Location: Umeå, Sweden
Working Arrangement: Mostly Remote
Job Type: Consultant
Reference Number: RV1022
Assignment Period: Immediate start until 31 December 2027, with a possibility of extension until 31 December 2028
Scope: 100%
On-site Requirement: 1–2 days per quarter in Umeå
Application Deadline: 26 October 2026
About the Assignment
We are looking for an experienced Data Lake Developer to contribute to the development of modern, secure, and reliable data warehouse and data lake solutions within the healthcare domain.
The assignment focuses on making healthcare data accessible and usable through robust data architecture, database development, integration, and data migration. You will contribute to requirements analysis, technical design, architecture decisions, and the development of solutions for managing sensitive healthcare information.
The role also involves improving data quality, supporting secure data integration, and ensuring compliance with relevant security and legal requirements.
Key Responsibilities
- Develop and maintain data warehouse and data lake solutions using SQL Server.
- Design, develop, and optimize database structures and SQL queries for large-scale databases.
- Build and maintain ETL processes using SQL Server Integration Services (SSIS) and Python.
- Design and implement dimensional data models based on Kimball methodology.
- Migrate sensitive patient data from legacy systems to modern data platforms.
- Contribute to requirements gathering, technical architecture, and solution design.
- Develop integration solutions for healthcare data from multiple source systems.
- Ensure data quality, security, reliability, and compliance with applicable regulations.
- Apply relevant healthcare data standards and interoperability practices.
- Collaborate with stakeholders and development teams to improve data utilization and operational efficiency.
Mandatory Requirements
- Competency level 3.
- Good written and spoken communication skills in both Swedish and English.
- At least 5 years of experience in SQL development involving large databases.
- At least 5 years of experience in database development within the healthcare domain.
- Experience migrating sensitive patient data from legacy systems to newer data platforms.
Preferred Qualifications
- At least 5 years of practical development experience with Microsoft SQL Server and SQL Server Integration Services (SSIS).
- At least 5 years of experience with data warehouse dimensional modeling using Kimball methodology.
- Knowledge of healthcare informatics and standards such as HL7 FHIR and openEHR.
- Experience handling patient data or other sensitive information subject to security and legal requirements.
- Experience developing Python-based ETL and integration solutions for loading data from source systems into data warehouses.
- Experience improving healthcare data quality and operational efficiency.
Application Process
Interested candidates are invited to submit an updated CV highlighting relevant experience in SQL Server, SSIS, healthcare database development, data warehousing, ETL, and sensitive data migration.
Please apply as soon as possible. The application deadline is 26 October 2026