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