Position: Data warehouse / BI Developer
Company: Intellias
Category: SQL
Experience required: 2y
English level: upper
Published: 2021-08-01T00:00:00+03:00

Our customer is fast grown FinTech startup in the loan management domain operating in EU. We are at the beginning of the long-term journey to build a loan management system using Microsoft technology stack.
Join us now and become a part of a core team to influence architecture setup, establish cooperation with customer and all this cool stuff at the start of the project!

We are looking for a Data Warehouse Developer who will join the DWH-BI team to support a debt management company with operations in several European countries.  You will be part of a geographically distributed team that works in the multinational European environment.

**Responsibilities:**

- Elaborate on the requirements with business users and analysts
- Map data sources to Data Warehouse including development of data full way transformation
- Implementation of Power BI reports and other SQL scripts into production
- Develop code of Data Warehouse, Master Data and Data Marts (MS SQL Server, SSIS)
- Maintenance and monitoring of the production solutions, addressing issues and improvements
- Performing data quality checks for data source systems

**Requirements:**
- 2+ years of experience in DWH and data modeling or/and Big Data areas.
- Good knowledge of Microsoft technology stack (Microsoft Azure cloud, Power shell, Power BI, Power App)
- Good knowledge of T-SQL and Microsoft SQL Server
- Good knowledge of data modeling
- Experience with Power BI or other reporting tools (e.g. QlikView, Business objects, Tableau, Microstrategy)
- Experience in development of ETL (stored procedures)
- Basic knowledge of database architecture

**What other skills/experience would be good to have?**

- Good experience in query tuning
- Experience with SSRS and SSIS
- Experience in development of technical projects, preferably with experience in implementation of Business Intelligence and/or Data Warehouse solutions
- Experience in development and performance tuning of complex Transact-SQL scripts.
- Experience within debt collection, financial services is an advantage.
- Good command of English (able to communicate in an international environment)