Key Responsibilities
- Ability in data modelling, design, build, and deploy DW/BI systems for various sectors such as Insurance, Health Care, Banking, etc.
- Performance tuning of ETL processes and SQL queries, and implementation of ETL and query tuning techniques.
- Development of transformation queries, views, and stored procedures for ETL processes and process automations.
- Translation of business requirements into technical specifications, evaluation, and enhancement of existing BI systems.
- Utilization of business intelligence and visualization software (e.g., Tableau, Qlik Sense, Power BI, etc.) to enable customers to drive their analytics and reporting.
- Development and maintenance of technical documentation for BI systems.
Qualifications Required
- Hands-on experience in MS SQL Server & MSBI (SSIS/SSRS/SSAS) with a solid understanding of database concepts, star schema, SQL Tuning, OLAP, Databricks, Hadoop, Spark, and cloud technologies.
- Proficiency in designing and implementing complete ETL/SSIS processes and data transformation for ODS, Staging, and Data Warehouse.
- Experience in creating self-service reporting solutions using business intelligence software (e.g., Tableau, Qlik Sense, Power BI, etc.).
This role at Cognitio Analytics will offer you the opportunity to apply your technical skills in a dynamic and innovative environment where you can contribute to impactful digital transformation projects.