Business Intelligence Database analyst - Jobs in Winnipeg, MB

Job Description

Title: Senior Business Intelligence Database AnalystLocation: 333 or 363 Broadway in Winnipeg.Type: OnsiteDescription of Servicesa) Lead the data warehouse solution design, development, and implementation including Enterprise Data Warehouse (EDW) BI Semantic Models, Extract/Transform/Load (ETL), and OLAP development;b) Contribute to standards and frameworks for data modelling, data integration/ETL and reporting, and ensure these are being consistently used in the design and development of all relevant solutions;c) Ensure new business intelligence applications integrate and comply with the business intelligence architecture;d) Keep abreast of the latest trends in business intelligence technologies and practice, technologies on application integration, process management, and service-orientated application developmente) Maintain and continually improves practices that achieve high quality of business intelligence assets and improve confidence in data, processes, and development disciplines;f) Ensure compliance of WCB business intelligence database standards and guidelines by developing and maintaining documentation pertinent to standards, methodology, and operational procedures;g) Participate in the acquisition, implementation, and installation of acquired hardware and/or software for data warehousing applications;h) Manage the data warehouse performance and tuning;i) Ensure the business intelligence applications and databases are pro-actively maintained and available for WCB business and project teams to use;j) Work closely with the WCBs IT staff to ensure the platforms supporting the business intelligence applications are in optimal condition;k) Work closely with the WCBs IT staff to administer business intelligence portals, including developer and user security & access;l) Install, configure, maintain, and upgrade database management systems;m) Coordinate any changes to the configuration of the business intelligence applications; andn) Perform other related duties, as assigned.The Services shall normally be performed during Business Hours. However, the WCB may request some of the Services to be performed outside Business Hours from time to time, as deemed necessary, in the unfettered discretion of the WCB. The Contractor shall not be entitled to charge overtime rates unless specified in the Fee Schedule.The WCB requires the Contractor to supply one (1) resource on a full-time basis [thirty-six and a quarter (36.25) hours per week].The Senior BI Database Analyst must have experience and knowledge with the following:a) Minimum of five (5) years of demonstrated related experience as a BI database analyst in a data-driven organization;b) Working knowledge with Microsoft Power BI;c) Working knowledge of Microsoft Azure;d) Extensive knowledge in Microsoft SQL Server with experience in database design;e) Knowledge of SQL Server Integration Services (SSIS); andf) Knowledge of SQL Server Reporting Services (SSRS).The Senior BI Database Analyst should have experience and knowledge with the following (which may be considered an asset when evaluating):a) Knowledge of role-based access control and token-based authentication in a Microsoft environment;b) Knowledge of role-based access control and token-based authentication in an IBM Websphere environmentc) Knowledge of Team Foundation Server (TFS) and agile software release practices;d) Ability to perform work according to WCB source code management, release management, and incident management;e) Knowledge and experience of the WCBs processes or insurance models;f) Knowledge of actuarial practices and principles; andg) Understanding of the WCBs business and/or testing processes.Job Type: Full-timeSchedule:

• 8 hour shift

Ability to commute/relocate:

• Winnipeg, MB: reliably commute or plan to relocate before starting work (required)

Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job
• SimplyHired OnDemand

Stay Connected