DWH & BI Engineer

Are you passionate about gathering and analyzing data? You like responsibility and wearing many hats in your role?Then you found the right place! Join Nortal to improve the Estonian healthcare sector by making the data easily accessible to Estonian biggest hospitals and contribute to crucial decision making!   

In your key role as a DWH & BI Engineer, you will be gathering and shaping the data, that drives management-level decisions in hospitals. Help to increase healthcare professionals' efficiency so they could provide the best support for patients. In your role, you will work very closely with Estonia’s biggest hospitals like Tartu Ülikooli Kliinikum and Ida-Tallinna Keskhaigla. 

In your versatile role you will:  

• Manage and maintain Oracle databases, with a focus on ETL processes and SQL query and PL/SQL optimization.
• Extract specific data sets from primary databases to fulfill client reporting needs.
• Transform and prepare the extracted data for integration into client-specific reports.
• Oversee and optimize data loading processes to ensure efficient data transfer.
• Assist clients in creating custom reports to meet their reporting requirements.
• Monitor, troubleshoot, and resolve issues within data workflows and queries.

• At least 2-3 years of experience in BI Development  
• Hands-on experience with BI and reporting tools such as Power BI, Oracle BI, Tableau, or others, including their configuration and maintenance 
• Proven experience with SQL programming (Oracle, PostgreSQL, MySQL, Microsoft SQL, or others)  
• Experience with Data Warehousing  
• Knowledge of database management systems (Oracle Database, Microsoft SQL, or other)  
• Experience with data integration processes (e.g., ETL, ELT) and managing data pipelines 
• Fluency in spoken and written Estonian 
• Strong troubleshooting skills to diagnose and resolve BI system issues  

We like to say that Nortal is a right-sized company – big enough to undertake and impact influential projects yet small enough to care. At Nortal, your voice is heard, and everyone’s input matters. You solve critical problems for fascinating customers from different domains. You work with experienced colleagues in a warm environment. You can execute your ideas in a reasonable time frame. And what you do and learn here are universally relevant and valuable. Last but not least, Nortal is an agile company with a low hierarchy – meaning heavy on common sense, light on rules, and substance is more important than titles!  

Does this sound like the right fit for you? Don’t hesitate to apply – let’s (video) meet and greet!