- Working closely with the Basic Software Group (BSG) manager and internal customers to design, develop and maintain reports / analytics capability.
- Managing the database aspects of the reporting and analytics platform(s) to ensure that reporting jobs are successfully run and analytics data aligns to timeliness / completeness requirements.
- Creating, modifying the database structure, as necessary, from information given by application developers
- Working on database to ensure that the database and data warehouse is tuned for optimal performance.
- Working with business analysts and project managers to develop and refine reporting and analytics requirements.
- Ensure that the physical designs for the data warehouse and its data structures align with IT strategies, architecture frameworks and logical data models.
- Planning for backup and recovery of database information
- Troubleshooting technical issues, finding the root cause and designing, proposing, and implementing solutions
Requirements
- Install, Develop and management for new data warehouse.
- Experience with Microsoft data analysis and Modelling tools (SSIS, SSAS)
- Having a good experience of queries optimization and performance tuning
- Analyze various data warehouse objects.
- Evaluate all codes and ensure quality of all project deliverables.
- Experience of using any Source Control Software like Team Foundation Server/VSS/SVN
- Experienced in using any Agile Project Management tool like JIRA