Specialist, Business Intelligence Data Warehouse

2 weeks ago

Nanaimo, British Columbia, Canada Island Health Full time $80,000 - $120,000 per year

Job Description
In accordance with the Vision, Purpose, and Values, and strategic direction of the Vancouver Island Health Authority (Island Health), patient safety is a priority and a responsibility shared by everyone; as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.

Reporting to the Manager, Enterprise Data Warehouse, the Specialist, Business Intelligence Data Warehouse develops, manages, and updates data models, including physical and logical models of the data warehouse, data mart, and staging area, and sometimes the operational data store and source systems. The Specialist is a lead resource responsible for the architecture, design, implementation, and operational support of the Business Intelligence databases, data repositories, and related infrastructure.

The Specialist is accountable for the day-to-day data warehouse environment that includes applications, systems, and services that are mission-critical and requires twenty-four hour support. The Specialist plays a key leadership role in the recovery process in the event of critical system outages.

QUALIFICATIONS:
Education, Training And Experience
A level of education, training and experience equivalent to a Bachelor's Degree in Computer Science and at least five (5) years' recent related experience in areas such as management of data warehouse implementations, performance of MS SQL Server DBA functions including backup and recovery, performance monitoring, performance optimization, disk space utilization, software installation and upgrades, logical and physical data modeling, development of stored procedures, triggers, views, and other database objects, ETL procedures; large scale project management; health care clinical and administrative implementations.

Skills And Abilities

  • Effective interpersonal, verbal, and written communication skills.
  • Ability to write programs in a variety of programming languages.
  • Ability to transfer knowledge and skills to other department staff.
  • Ability to provide clear and concise system documentation and procedures for other staff.
  • Ability to keep skill set up to date with new technologies as they are introduced to the workplace.
  • Data standards, database structures, database server administration.
  • Familiarity with HL7, XML, MIS guidelines.
  • Strong understanding of Cognos from a development and architecture perspective.
  • Ability to work independently and organize workload and priorities with minimal supervision.
  • Superior database querying skills including using Structured Query Language.
  • Physical ability to perform job.
  • Strong conceptual, communications, and technical skills.
  • Ability to translate business needs into technical solutions.
  • Strong relational and dimensional data modeling and database design skills.

Link To Full Job Description

  • Retail Warehouse

    6 days ago

    Nanaimo, British Columbia, Canada Value Village Full time $92,400 per year

    Description Position at Value VillageJob Title: Retail Warehouse & Production AssociatePay: 17.85$ $/hrWho we are:As one of the largest for-profit thrift operators in the United States, Canada and Australia for value priced pre-owned clothing, accessories and household goods, our mission is to champion reuse and inspire a future where secondhand is second...

  • Senior Information Technology Specialist

    2 weeks ago

    Nanaimo, British Columbia, Canada Intraworks I.T. Management Full time $60,000 - $90,000 per year

    Company DescriptionIntraworks I.T. Management is central Vancouver Island's largest I.T. Solutions company, specializing in assisting small and medium-sized businesses with their information technology needs. Intraworks provides comprehensive services including computer networks, consulting, cloud and security solutions, web and email hosting, secured...

  • Account Specialist

    1 week ago

    Nanaimo, British Columbia, Canada Genuine Parts Company Full time $60,000 - $90,000 per year

    SUMMARY:The Account Specialist drives sales, identifies, and generates opportunities for various types of customers. This role partners with Account Representatives within an assigned territory to deliver deep knowledge within a product group. The Account Specialist provides education of Motion products through technical presentations.JOB DUTIES• Increases...

  • Retail Backstock Specialist

    2 weeks ago

    Nanaimo, British Columbia, Canada MEC Full time $40,960 - $46,920 per year

    About MECIf you're looking for an opportunity to work with one of Canada's most iconic outdoor retailers, we've got your dream job.MEC is more than a store. We're a hub for the outdoor community, a leader in sustainability, and a place where you can be yourself. People come to us to try new things and plan new adventures – and as aRetail Inventory...

  • Senior Health Safety Specialist

    1 week ago

    Nanaimo, British Columbia, Canada F&M Installations Ltd. Full time $60,000 - $100,000 per year

    About the Company:The FMI Group is an electrical contracting company that specializes in construction of large-scale energy generation, transmission and distribution projects. We are proud to consider ourselves to be a leading industrial utility service provider within Western Canada, executing projects in British Columbia, Yukon Territory, Alberta, and...

  • Relationship Manager Intern, Business Markets

    21 hours ago

    Nanaimo, British Columbia, Canada RBC Full time

    Job DescriptionWhat is the opportunity?You will provide business and financial advice and manage a portfolio of high value small business clients who need your help as they start, manage and grow their enterprises.  You are RBC's ambassador to the local business market.  Applying your mindset for external marketing and client acquisition, you will develop...

  • Mobile Mortgage Specialist

    1 day ago

    Nanaimo, British Columbia, Canada Coast Capital Savings Full time

    Location(s): Victoria, Aulds Road Branch, Beverly Corners Branch, Central Saanich Branch, Courtenay Branch, Sidney Branch, Sooke Branch Job Type: Full Time Regular myWork Program: MobileStarting Salary Range: Commission PlanBackground Screening Requirement: Enhanced Criminal Record CheckCredit CheckIdentity Verification Employment...

  • Shipper and Receiver

    6 days ago

    Nanaimo, British Columbia, Canada Peterbilt Pacific Full time $111,120 per year

    The Shipper and Receiver ships, receives and records the movement of parts, supplies, materials, equipment and stock to and from an establishment. At Peterbilt Pacific, we strive to conduct our business as a well-respected organization; with integrity, excellence, productivity, and a positive attitude as our core values. We strive to have the highest...

  • Shipper and Receiver

    6 days ago

    Nanaimo, British Columbia, Canada Peterbilt Pacific Full time $45,000 - $90,000 per year

    The Shipper and Receiver ships, receives and records the movement of parts, supplies, materials, equipment and stock to and from an establishment.At Peterbilt Pacific, we strive to conduct our business as a well-respected organization; with integrity, excellence, productivity, and a positive attitude as our core values. We strive to have the highest care...

  • Computer Specialist

    7 days ago

    Nanaimo, British Columbia, Canada Micro-Vision Computers Full time $40,000 - $80,000 per year

    What Is The Role In The BusinessThis role is not for the faint of heart. This role is an opportunity to be part of the core group of people developing and implementing a new business strategy that carves out a unique place in the computer market. If you want to work in a business where every decision you make and action you take has an impact on the business...