Analyst – Business Analytics

  • Company:
    The Manitoba Public Insurance Corporation
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    13 hours ago
  • Category:

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.

ID: 2021-1897

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