Position: Senior Business Intelligence Engineer (Healthcare Domain)
Company: Sigma Software Group
Experience required: 5y
English level: upper

Would you like to help shape the future of healthcare?

Sigma Software is seeking a motivated Senior Data Analyst to help us with our data warehouse challenges. You will be involved in creating and implementing solutions for the healthcare domain, using data analytics as well as data science tools and instruments.

We look forward to having you on our team!

**CUSTOMER**
Our client is a leading medical technology company. The portfolio of products, services, and solutions is at the center of clinical decision-making and treatment pathways. Patient-centered innovation is and always will be at the core of the company. The client is committed to creating better outcomes and experiences for patients, no matter where they live or what they face. The client is innovating sustainably to provide healthcare for everyone, everywhere.

**PROJECT**
In this project, the integration and aggregation of several data sources allow us to provide valuable insights into what happens with the CT (Computer Tomography) systems during the new software development process, as well as how our customers use these systems. Our current SQL server-based infrastructure should be migrated to a new Azure cloud-based platform shortly. Therefore, a lot of solutions need to be relocated.

**REQUIREMENTS**
Several years of experience in DB and DWH modeling
Good experience with MS-SQL Server and related services, development of advanced topics (partitioning, column store, performance optimization, replication)
Strong SQL knowledge
Experience with Cloud data platform development and migration
Good understanding of ETL/ELT and DWH concepts, modeling, and development of ETL (Extract, Transform, Load) processes
Good team player
Excellent communication skills and fluency in business English

**RESPONSIBILITIES**
Tasks include, depending on your focus: data preparation, data modeling, data science, reporting, and dashboarding
Create and enhance data solutions enabling seamless data delivery and be responsible for collecting, parsing, managing, and analyzing large data sets across different domains for analysis
Connect business questions to data projects to create new analytics capabilities
Write and debug complex SQL queries from databases
Design and develop ETL processes that are scalable, repeatable, and secure for stakeholder needs
Document data flow diagrams, security access, data quality, and data availability across all business systems

**WILL BE A PLUS**
Knowledge in design and programming of user interfaces
Hands-on experience with Azure
Knowledge of Databricks