Job #:

10002

Division:

Information Technology Services

Vacancy Type:

Full-time Permanent

Affiliation:

Union: CUPE 79

Contract Length:

Grade:

TCHC 9

of Vacancies:

1

Salary/Hourly Range:

49.20 - 53.92

Hiring range/wage:

49.20

Work Details (Days/hours):

Monday to Friday, 35 hours/week

Posted Date:

10/8/25

Existing or New:

New

Deadline to Apply:

10/22/25

What we offer

In addition to competitive wages and a rewarding career where you can truly make a difference, we offer a comprehensive compensation package that meets the various needs of our diverse employees, including:

• Three Weeks paid annual vacation days, increasing with years of service;
• Defined benefit pension plan with OMERS, includes 100-per-cent employer matching;
• Health and dental benefits;
• Employee and family assistance program;
• Maternity and parental leave top up (93% of base salary);
• Training and development programs including tuition reimbursement of $1500 per calendar year.
• Fitness membership discount;

This job offers the opportunity to work from home as part of a hybrid work arrangement. This arrangement will allow you to work some days at a TCHC work location and the rest of the time from home. The amount of time required to work at a TCHC work location is flexible, while considering operational and service delivery requirements.

Make a difference

This position reports to the Manager of Business Intelligence within the ITS department of TCHC. Performing in a senior role, this position supports both existing business software systems and develops new ones, as authorized by client business groups through ITS management. This position is involved in all areas of BI systems development, from business concept to implementation.

This position will assist the BI team to build out the new BI infrastructure to support corporate analytics, reporting and dashboards.

What you’ll do

• Consult with management on the operational requirements of software solutions
• Contributing expertise on information system options, risk and operational impact
• Mentoring junior software developers in gaining experience and assuming DevOps responsibilities
• Managing the installation and configuration of solutions
• Collaborating with developers on software requirements as well as interpreting test stage data
• Completing code and script updates as well as resolving product implementation errors
• Overseeing routine maintenance procedures and performing diagnostic tests
• Documenting processes and monitoring performance metrics
• Conforming to best practices in network administration and cyber security
• Performs ad-hoc database migrations, upgrades, installations, configurations, troubleshooting and monitoring of SQL Server databases
• Assists with BI project work efforts estimation
• Develops detailed technical specifications, User Guides and ETL documentation including training of users
• Serves as Subject Matter Expert in BI tool development concepts
• Research into the current state of BI marketplace to make recommendations and selection criteria for the procurement of new BI tools and technologies
• Coordinates and supports development efforts of technical and corporate staff with database tuning efforts as well as ongoing application implementation, support and upgrades
• Supports production issues and maintenance as necessary – acting as second level support for troubleshooting and resolving BI related applications / databases
• Participates in BCP and DR planning, ITSM process improvement, run book creation and service catalog updates

What you’ll need

• Passionate about business intelligence, the use of BI and analytics to improve business operations

• Deep understanding of multidimensional and tabular data models

• Ability to ensure smooth software deployment by writing script updates and running diagnostics

• Ability to create standards and go from design to implementation

• Capable of performing SQL Server database backups, restores and patching on Windows environments and advanced database tuning

• Excellent oral and written communication skills and ability to present to client groups, to consult with technical and non-technical staff and to prepare reports and proposals

• Proficiency in documenting processes and monitoring metrics

• Advanced knowledge of best practices related to data encryption and cyber security

• Must be able to handle multiple priorities in a fast-paced environment

• Excellent organizational skills to deliver projects on-time and on-budget

• Excellent interpersonal and conflict resolution skills, sensitivity and tact

  Preferred:

• Experience with working on large scale and multiyear initiatives

• Experience with Microsoft BI stack

• Experience with CDC concepts and scripted CDC Frameworks

• Experience with Microsoft Azure, Power BI or other modern BI tools

• Experience building SSAS / Tabular cubes and Power BI dashboards / reports against such cubes

• Experience in building / designing / maintaining a SQL Server data warehouse

What’s next

Once you apply, we’ll review your resume and contact you if your skills and experience match the qualifications for the role. If you are selected to move forward, the process will include one or more interviews and/or assessments and reference checks.

Candidates for unionized positions must score a minimum of 70% to pass any interview or assessment and be considered for the next stage of the recruitment process. Successful candidates will be determined based on score and where applicable, union seniority. Not all candidates who score 70% or higher will automatically proceed to the next stage of the recruitment process as this will be dependent on the number of candidates and number of available roles.

INDS