Data Analyst

Total Systems Solutions Consulting Inc. - Calgary, AB (22 days ago)

Apply Now

Total Systems Solutions Consulting Inc currently seeking an experienced Data Analyst – Report Development resource for our client BC Pension Corporation in Victoria, BC.

Situated within the Enterprise Analytics team, the Data Analyst – Report Development resource supports program areas by developing reporting and analytics products that create transparent insights for decision making. This role combines technical expertise with statistical analysis to produce relevant insights, and communicate findings through effective data visualization.

The main deliverables will involve working with stakeholders to develop reports that utilize data warehouse data. Additionally, report conversion from Spotfire and Excel to Power BI will make up a considerable amount of the scope of work.


The Data Analyst – Report Development will provide the following services:

  • Relating Key Performance Indicators (KPIs) to data available in the data warehouse
  • Working with stakeholders to refine KPIs and reporting outcomes
  • Querying the data warehouse
  • Developing reports using Power BI based on previously created Spotfire reports
  • Working with stakeholders to assure quality and refine reports based on continuous feedback
  • End user training and handover
  • Working with business areas to transition reports and artifacts.

Required Skills:

  • A minimum of three years demonstrated experience building reports using Power BI and SQL.
  • A minimum of three years experience working directly with report consumers and other stakeholders to develop and hand-over reports.
  • Bachelor’s degree in engineering, data science, computer science, statistics, or mathematics.
  • A minimum of three years or more of demonstrated experience using SQL Server Integration Services (SSIS) is highly preferred.
  • Experience with TIBCO Spotfire is an asset.
  • The successful candidate will be required to work full time on-site in Victoria, BC.

Additional Comments:

  • The short-listed candidates will be required to attend interviews on November 28th or Friday November 29th, 2019.
  • Contract duration will be 4 months with possible extension

Job Type: Contract


  • SQL Server Integration Services (SSIS): 3 years (Preferred)
  • building reports using Power BI and SQL: 3 years (Preferred)
  • working with stakeholders to develop and hand-over reports: 3 years (Preferred)
  • TIBCO Spotfire: 1 year (Preferred)


  • Bachelor's Degree (Preferred)