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,