Name of Company: SavvyPro Edu Inc.
Company Address (Work Location): 720 Spadina Avenue, Unit 310, Toronto, ON, M5S 2T9
Job Title: Data Administrator (NOC 21223)
Job Duties & Responsibilities:
• Design and develop database by collecting customers’ and other departments’ requirements to improve our ERP system and LMS platform.
• Work closely with the DevOps engineering team to actively maintain the health and performance of our MongoDB database for our ERP system.
• Analyze query logs from different database systems to identify potential speed bottlenecks and provide systematic methods for optimization.
• Design, build and maintain ETL processes to sync our ERP data into SQL database for our business analyst team to create informative dashboard for business metrics.
• Conduct document database design through data modeling (e.g. Entity-Relationship Diagram) and review design to ensure optimized data environments.
• Develop and implement data administration models and ensure that database security models are implemented and monitored to secure the clients’ data.
• Develop automated scripts to create system backups and perform any necessary migrations on schedule.
• Regularly monitor, update and tune our database system configurations to provide 24x7 uptime and availability in high volume environment loads.
• Be responsible for all the data collected and deliver results to business operations and marketing teams
• Individually design and manage data-based project using project management software by being involved in the design planning phase, development phase and implementation phase.
Terms of employment: Permanent, Full-time Position
Salary: $46 per hour for 35 hours a week, 52 weeks a year
Work hours: day, night and weekend. Night or weekend shift maybe required based on the operational needs of the company
Location of work: 720 Spadina Avenue, Unit 310, Toronto, ON, M5S 2T9
Minimum Skills Requirements:
• Education: Bachelor’s Degree or higher
• Strong knowledge of R, Python or SAS in quantitative business and statistical analysis.
• Strong knowledge and experience in working with an ERP system and an LMS platform
• Knowledge of using data analytics such as SQL, Tableau etc.
• Knowledge of programming languages such as C, C++, Objective-C, Java etc.
• Knowledge of management system software, such as MySQL.
• Ability to work on various operating systems, such as Windows, Mac, Linux, Android.
• Excellent verbal and written communication in English.
How to apply:
• Email: hr@savvyuni.com
• Include references attesting to experience with your job application.
Contact information:
Contact person: HR Department
Website: www.savvypro.ca
Email: hr@savvyuni.com
|