Database Analyst/Programmer

Location: WFH, Toronto
Contract Duration: 4 Months

Summary: The main function of a Database Analyst / Programmer is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems.

Job Responsibilities:
– Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies
– Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions
– Design, implement, automate and maintain large scale enterprise data ETL processes
– Modify existing databases and database management systems and/or direct programmers and analysts to make changes Test programs or databases, correct errors and make necessary modifications
– System and Design Reports
– Must have advanced Excel and PowerPoint skills

Qualifications:
1. 0-3 years of Prior Financial Reporting experience. We are open to new graduates
2. Experience with database technologies
3. 1-3 years of experience of the ETL process
4. Knowledge of at least one scripting language (MDX Preferred)
5. Strong written and oral communication skills
6. Strong troubleshooting and problem solving skills and user support

Nice to have:
1. Experience with database technologies – preference is with Oracle, SQL Server
2. MDX – Multi Dimension Expressions- extension of SQL