BI Developer

Job description Ensure the EDW is running efficiently, performing regular updates, backups, and troubleshooting any issues that arise. Design and implement dimensional models (star and snowflake schemas) to facilitate efficient querying and reporting. Implement data validation and cleansing procedures to maintain high data quality and integrity. Optimize database performance through indexing, query optimization, and other techniques. Gather business requirements for enhancement, customizations and develop technical requirement documents. Should be able to provide solution technically. Prepare estimate based upon the custom requirement and prepare project schedule. Engage in business meetings to understand and review the feasibility of the business requirements. Responsible for gap analysis of functional flows, provide solution design, perform POCs and demo for the Gaps solution from standard solution sets as well customized solutions. Work closely with Microsoft support team and should be able to create service request as and when required for business-critical issues. Should be able to redefine and make technical/strategic changes to enhance existing Business Intelligence systems. Involve in post implementation support to provide solution for production issues or for any other maintenance activities which might also involve change management process. Maintain comprehensive documentation of data models, ETL processes, and other relevant procedures. BSc/MSc degree in computer science or any branch of Engineering. Experience: Strong experience with SQL, database management systems (e.g., SQL Server, Oracle, MySQL), and ETL tools (e.g., ADF, SSIS,