Position: Microsoft SQL Business Intelligence
Category: Data Analyst
English level: upper
Years of experience: 5


Excellent IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server in Development, Test and Production Environments on various business domains like Mortgage, Financial, Healthcare, Insurance, Software, Law and Manufacturing.

o	Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
o	Ability to express complex technical concepts effectively, both verbally and written. 
o	Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
o	Exceptional experience and knowledge on Tableau report development by using all features with simple and creative solutions using Tableau desktop and server  
o	Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SAS, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
o	Strong skills on Deploy and operate large scale cloud infrastructure and application services in our own data centers on Amazon cloud and other Cloud providers
o	Experience in both on-prem and cloud solutions. Extensive experience with Microsoft Azure ecosystem such as: Power Bi Service, ADF2, Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL DW, Azure Blob, AKV Management. Also, hands-on experience with AWS cloud solutions such as AWS RDS SQL server, MySQL, Amazon Redshift, AWS EC2, AWS S3 buckets.
o	Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
o	Good Experience in working with APIs to access specific database features.
o	Experience in Performance Tuning and Query Optimization.
o	Hands-on experience with Azure Data Factory V2, Data Flows, Snowflake, Azure Data Lake, Azure analysis services.
o	Hands on experience in Creating Star Schema and Snowflake Schemas.
o	Working with source code version control using Azure DevOps or Git.
o	Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI Dax with good knowledge on SQL Server Analysis Services (SSAS).