Sr. Technical Staff

Cpus Engineering Staffing Solutions Inc.; Canada; Hybrid; CAD 30,000 - 60,000; Full time

Job summary

A leading engineering staffing firm is seeking a Sr. Technical Staff member to develop automated reports using SQL Server Reporting Services and Power BI. The ideal candidate will have a Bachelor’s degree in Computer Science or Engineering, and relevant experience in T-SQL and data analysis. This is a hybrid position based in Canada, offering the opportunity to contribute to significant projects in the industry.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, or related post-secondary education.
• Experience in developing T-SQL queries for data warehouse management.
• Experience in building and maintaining automated reports using SSRS or Power BI.

Responsibilities

• Develop and maintain automated reports using SQL Server Reporting Services and Power BI.
• Design SSRS reports and connect to integrated databases using SQL queries.
• Conduct administrative work for the OPG Master Data Management platform.

Skills

Developing T-SQL queries

Building and maintaining automated reports using SSRS

Data analysis

Working experience in Power BI

Education

Bachelor’s of Computer Science/Engineering

Tools

SQL Server Reporting Services (SSRS)

Power BI

TIBCO EBX

Primavera P6

Hexagon EcoSys

Job description

Job Details

• Job ID: 24-070
• Number of Vacancies: 1
• Level: MP4
• Duration: 12 months
• Hours of work: 35
• Location: DEC (Hybrid, 2 days remote)

Overview

We are currently requesting resumes for the following position: Sr. Technical Staff

Responsibilities

• Develop and maintain automated reports built using SQL Server Reporting Services (SSRS), Power BI or using HTML and JavaScript libraries such as D3.js.
• Design SSRS reports hosted on a .NET application and connect to an integrated database (IDB) using SQL queries, created per user specifications to help projects track their performance.
• Administrative, sustainment, and implementation work for the OPG Master Data Management platform TIBCO EBX, integration with the Microsoft Business Intelligence data warehouse IDB and data analysis.

Qualifications

• Bachelor’s of Computer Science/Engineering or related post-secondary education.
• Working experience in:
• Developing T-SQL queries for management of integrated MSBI data warehouse
• Building and maintaining automated reports using SSRS and/or Power BI

Assets (experience would be considered an asset):

• Project controls/management in large construction project or Nuclear industry
• Working experience using Asset Suite 7+, Primavera P6, and/or Hexagon EcoSys
• Building and maintaining MDM domains in TIBCO EBX
• EBX server administration, strategy and infrastructure