Full Stack Microsoft BI Consultant
A. Accountabilities:
Proven Experience in developing procedures/functions/and very advanced Database Scripts on Enterprise Scale (ex. Banking, Telecom, Retail).
Extensive Experience in designing and developing SSIS solutions to acquire and prepare data from numerous upstream systems.
Expert in building complex data transformations and cleansing packages with SSIS.
Proven Experience in managing/customizing and extending huge enterprise Databases/Data warehouse with of millions of daily transactions.
Design, model, develop & optimize stored procedures to meet data management and data reporting objectives.
Design and model data flows and ETL procedures ensuring data quality and integrity.
Work with data engineers to ensure that data sets feeding the various systems and the analytics platforms for optimal performance.
Develop automated data audit and validation process to ensure end users are getting the right data.
B. Qualification:
Excellent ETL/Data warehouse Technical Documentation skills.
Expert level in Power BI & DAX.
Expert in SQL Server DBs and SQL DW.
Extensive Experience in ETL processing in a very large data warehouse environment.
Experience in SSAS.
Experience in Azure data platform.
Experience in Oracle, No SQL DBs.
Experience in Apache Spark / PySpark is a plus.
Additional Preferable skills include : SSAS, Azure Data (Synapse & ADF), Oracle.
C. Experience:
At least 8-10/- years experience in same role.
D. Education:
Bachelors degree in Computer Science or Information Technology or any related domain.
E. General Skills:
Excellent Written and Communication Skills.
Day-to-day discussions, team meetings.
Written (requirements and design specifications) forms.
Overall ability to be clear and concise in all communications.
Customer Oriented.
Expert level in Microsoft Business Intelligence.
Arab Nationals are preferred.
F. General Remark:
The role is required for Diyar United Company - Qatar Office.
Shall be interested at Qatar opportunity location.