Key Responsibilities:
- Responsible for designing, modelling, developing and supporting Database Management Systems (DBMS).
- Analyses data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, perfects, and certifies database schema design to meet system(s) requirements.
- This position handles data migration from multiple systems including interaction with end users to gather requirements using the available BI tools at hand.
- Ensure data quality and integrity throughout the migration process, performing data validation and reconciliation as needed.
- The Database analyst will support the Information Systems department by migrating the data from one system to another systems , Create complex functions and stored procedures.
- Design, develop, test, and implement reports as necessary to fulfil business requirements Build appropriate and useful reporting deliverables in accordance with due dates and project requirements Ability to construct reusable reports based on common reporting requests using available tools Provide timely scheduled management reporting .
- Develop and execute test cases to confirm the migrated data's accuracy and functionality .
Skills and Qualifications:
Minimum 10 years of experience
- ETL
- Power Bi
- SSIS/SSRS
- SQL
- DBMS/DBA