Main responsibilities:
-
Writing SQL queries and procedures
-
Maintain and Optimize an Existing SQL Database
-
Design and development of database structures
-
Conceptual, logical, physical design of MS SQL database / model
-
Determining customer analytics needs
-
Experience in building ETL on SSIS and T-SQL
-
Customized data visualization plus creative Power BI
-
Knowledge of C # and .NET is encouraged, but not required
Requirements:
-
Higher technical education
-
Basic MS SQL Server Administration Skills
-
Skills in using development tools SQL Server Management Studio, Visual Studio, SQL Server Data Tools.
-
Knowledge of SQL Server Reporting Services when generating reports.
-
MS SQL at the organizational level BIG DATA for OLAP systems
-
Knowledge of Relational Database Theory and Data Warehouse (DWH) Concept
-
Knowledge of Oracle SQL and PL / SQL (queries, functions and procedures)
-
Experience with Microsoft Power BI- DAX- T-SQL- SSAS- SSIS- Python- C # - 1C
The advantage will be:
-
Knowledge and application of Agile, SCRUM
-
Experience / visualization with any business intelligence system (Oracle BI, Power BI, Tableau, Qlik Sense, DOMO, etc.)
-
Knowledge of English at B2 level