Job Description
- 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 Intelligence\Machine Learning solutions and modules.
- Establish and maintains data audit, security and integrity controls.
Skills
- Deep understanding of databases and data analysis procedures with exceptional troubleshooting abilities.
- Experience with SQL, Power BI and programming languages.
- Ability to communicate and visualize complex data in a simple, actionable way with exceptional technical writing skills.
- Ability to analyze data requirements and to develop analytical database constructs specific to requirements.
- Ability to work effectively in a dynamic group that has several concurrent projects.