Skip to Sub-navigation

Microstrategy Administrator

Job number:
Job title:
Microstrategy Administrator
Job type:
Permanent Full time
Ottawa, Toronto, Ontario, Canada
Number of positions:
Date posted:
August 10, 2022
Closing date:
August 23, 2022

Who we are

We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we provide essential information on Canada's health systems, enabling decisions that lead to healthier Canadians. As a valued member of the CIHI team, you and your work will have a pivotal role in the evolution of Canada's health care systems.

CIHI is recognized as an exceptional place to work that embraces diversity, respect, integrity, collaboration and innovation.

At CIHI, we recognize what matters to our employees. Some of the benefits of working at CIHI include

  • HOOPP Pension Plan (Defined Benefits Pension)
  • Retirement Planning Program
  • Generous vacation days for permanent and long-term contracts
  • Work-life balance
  • Career Planning Program
  • Learning and Professional Development Program
  • Flexible benefits program from your first day on the job for permanent and long-term contracts

Why is this role important?

Reporting to the Manager, Technology Services, the MicroStrategy/Qlik Administrator provides daily administrative and development support for CIHI’s MicroStrategy/Qlik toolset. They are also responsible for providing senior-level technical expertise & recommendations to CIHI management relating to CIHI’s corporate MicroStrategy/Qlik usage strategy.

The MicroStrategy/Qlik Administrator provides consulting support to ITS development and operations staff as well as business areas. They formulate policies and procedures relating to MicroStrategy/Qlik application development and management.

The MicroStrategy/Qlik Administrator is responsible for maintaining the optimal performance of MicroStrategy/Qlik business intelligence applications, performance monitoring, capacity planning and tuning.

What you'll do

  • Assigns junior-level MicroStrategy/Qlik administration tasks to designated team members and provides associated direction and guidance as required;
  • Support CIHI’s Information Security Management System (ISMS) through the implementation, management and/or monitoring of required Information Security controls;
  • Participates in key ISMS processes as required, including but not limited to Risk Management, Audit and Assessment, Monitoring and Reporting and Record Management
  • Provides daily MicroStrategy/Qlik administrative and development support. Including:
    • Product installation and hardening, version upgrades, patch management, daily system monitoring, usage reporting
    • Security/user authentication
    • MicroStrategy Intelligence and Web server tuning
    • Project architecture
    • Schema development and implementation
    • MicroStrategy project/object migration through development, UAT and production environments
    • The creation of MicroStrategy objects to meet report requirements (i.e. attributes, metrics, filters, prompts and reports)
  • Provides senior-level recommendations to the Manager of eReporting and EDW Services on the selection of MicroStrategy related software and hardware. Makes recommendations relating to the development of the overall corporate MicroStrategy usage strategy;
  • Provides senior-level cross-training, support and knowledge transfer to ITS development/maintenance teams and business areas;
  • Leads and coordinates the resolution of MicroStrategy-related technical issues in a time-sensitive/priority-sensitive manner;
  • Has overall responsibility for the design, implementation and administration of MicroStrategy security. Including object, user and report related security;
  • Maintains relationships with vendor (MicroStrategy). Manages vendor relationships (including acquiring new patches, software upgrades, license maintenance and promoting industry best practices within CIHI).
  • Works closely with Unix/NT/DB Administrators relating to performance tuning, upgrades and archive strategy;
  • Develops and documents policies and procedures for MicroStrategy system processes. Maintains and documents MicroStrategy related data profiles/engineering and architecture;
  • Maintains current knowledge of advancements in the latest MicroStrategy/Qlik technologies.

What you'll bring to the table

  • Bachelor’s Degree in Computer Science or equivalent.
  • Minimum of 5 years Data Warehousing knowledge and experience in an Oracle 9i/10g environment; and a minimum of 3 years experience as a MicroStrategy Administrator.
  • Solid knowledge of MicroStrategy/Qlik.
  • Experience with configuring, tuning, upgrading MicroStrategy Web and Intelligence servers.
  • MicroStrategy security administration experience.
  • Solid knowledge of SQL (both programming and tuning).
  • Strong application development background.
  • Excellent interpersonal and communication skills – both written and oral. With the ability to communicate effectively with users, management and technical staff.
  • Excellent analytical, problem solving and troubleshooting skills.
  • Works well under pressure and is able to prioritize competing priorities appropriately.
  • Ability to work with minimal supervision and direction.
  • Ability to work in fast-paced multi-disciplinary teams.
  • Ability to work as a team player and leader.
  • Must be able to work after hours/weekends and on call.
  • MicroStrategy certification is an asset.
  • Knowledge of the Canadian healthcare system, the CIHI environment and program areas is an asset.
  • Fluency in both official languages is an asset.

To find out more about this role and other exciting opportunities visit our website at and check out our 'Careers' section.

We thank all those who apply, however, only candidates selected for an interview will be contacted.

Vaccination remains the most effective tool to reduce the risk of COVID-19. CIHI is committed to ensuring the health and safety of our employees in the workplace, and therefore CIHI requires proof of vaccination for all of our employees unless a valid accommodation under legislation exists.

At CIHI we are committed to fostering an inclusive, barrier-free and accessible environment. Part of this commitment includes arranging accommodations to ensure an equitable opportunity to participate in the recruitment and selection process. If you require an accommodation, we will work with you to meet your needs.