As an analyst in Business Analytics, with a focus on Data Warehouse, you will work with clients to analyze, plan and organize analytic databases and applications. You will develop and maintain data warehouses and be a subject matter expert in SQL Programming, Data Warehousing and Relational Database Management System (RDBMS).
+ Lead the development, increment and maintenance of data warehouses and Operational Data Stores.
+ Develop and manage implementation of data/code fixes for defects utilizing the Application Lifecycle Management (ALM) process.
+ Monitor data warehouse load performance and data quality on a regular basis or for month-end and works with Information Technology (IT) staff to improve both performance and quality.
+ Consult with managers in requesting business units to determine project timelines, and where necessary, develops project plans to complete data warehouse requests.
+ Implement small source system changes within databases that are not part of MPI Projects such as new products and cover codes.
+ Ensure Business Analytics staff are aware of upcoming projects, data needs and any analytical requests anticipated from MPI projects.
+ Diploma in Computer Science, Computer Programming, Business Analysis or related discipline.
+ Three years of experience in systems analysis, design and/or programming in a data warehousing environment, including two years using applicable software.
+ Advanced knowledge of Data Warehousing concepts.
+ Advanced knowledge of SQL programming preferably in a Microsoft environment
+ Ability to prioritize multiple activities and work within deadlines.
+ Ability to complete technical reports and conduct thorough research.
+ Ability to communicate effectively, orally and in writing, in order to convey technical information in a clear, concise and understandable manner for both technical and non-technical audiences.
Street: 234 Donald Street
Post End Date: 3/6/2021
External Close Date: 3/5/2021
Placement (External): Term
Duration: 23 months
French Language Services Required: No