Identify data sources and streamline data collection, data cleansing and ELT operations through modern pipelines techniques both on premises and by utilizing cloud services.
Maintain databases and administer Enterprise data warehouses, data lakes and cloud technologies and pipelines.
Implement performance tuning techniques including indexes optimization and advanced SQL syntax refactoring.
Review data for inconsistencies or anomalies that could skew analytical results by identifying missing data values, correcting data, and finding duplicate data.
Document database design and data dictionaries by describing its content, context and parameters.
Analyze huge amounts of data and present results in a clear manner according to predefined roles and permissions.
Communicate findings and trends with metrics and KPIs using Power BI data visualization techniques and tools.
Implement data mining and predictive analysis through development of Artificial IntelligenceMachine Learning solutions and modules.
Establish and maintains data audit, security and integrity controls.