TECHNICIENNE OU TECHNICIEN EN INFORMATIQUE, CLASSE PRINCIPALE

Lester B. Pearson School Board; Dorval; On-site; CAD 90,000 - 120,000; Full time

Job summary

Lester B. Pearson School Board is seeking a senior technical resource to support, develop, and optimize corporate applications and data services. You will design Power BI reports, write SQL queries, and transform data across multiple sources to improve reporting, performance, and user experience.

You will collaborate with IT, management, and stakeholders, provide training and documentation, and ensure best practices in data governance while supporting ongoing system enhancements.

Qualifications

• Diploma of College Studies in Computer Science Technology or equivalent and four (4) years of pertinent experience.
• Strong knowledge of SQL, relational databases, data transformation, data validation, and troubleshooting.
• Experience developing, maintaining, and optimizing Power BI reports, dashboards, data models, and visualizations.

Responsibilities

• Act as senior technical resource for complex issues involving corporate and internally developed applications.
• Investigate, reproduce, document, and resolve complex application and data issues with users and technical teams.
• Translate business requirements into technical specifications, configurations, and reports; design and support dashboards and data workflows.

Skills

SQL

Power BI

Data modeling

Data transformation

Troubleshooting

Dashboards

Reporting

Analytical thinking

Communication

Education

Diploma of College Studies in Computer Science Technology

Tools

GPI

Jade

Tosca

Mozaïk

Fusion

Job description

Nature of the Work

The principal and customary work of the incumbent consists of carrying out highly specialized technical functions of a complex nature in the support, development, integration, and optimization of corporate applications, reporting solutions, and related data services.

The incumbent acts as a senior technical resource for assigned corporate and internally developed applications, including GPI, Jade, Tosca, Mozaïk, the LBPSB SSO Portal, and Fusion. Working with a wide range of latitude according to established priorities and objectives, the incumbent analyzes complex requirements and incidents, evaluates possible courses of action, recommends technical solutions, adapts procedures, and develops methods to improve application performance, reliability, reporting, and user experience.

The incumbent works with IT personnel, professionals, management, departments, users, vendors, and other partners. The incumbent distributes work among technicians, ensures that assigned work is completed, reviews completed work at management’s request, and provides training, technical guidance, documentation, and knowledge transfer.

Principal Responsibilities

• Acts as the senior technical resource and escalation point for complex issues involving assigned corporate and internally developed applications.
• Investigates, reproduces, documents, and resolves complex application, data, integration, access, and reporting issues with users and technical teams.
• Analyzes approved business and user requirements and translates them into technical specifications, configurations, reports, dashboards, procedures, and support solutions.
• Evaluates possible courses of action and recommends practical solutions based on organizational requirements, established standards, security considerations, and available technologies.
• Participates in the design, testing, implementation, integration, enhancement, and ongoing support of business applications.
• Designs, develops, maintains, and optimizes Power BI reports, dashboards, data models, and visualizations; develops SQL queries and data transformations using databases, files, and enterprise applications.
• Validates data accuracy, consistency, security, and performance and communicates findings and recommendations to technical and non-technical audiences.
• Supports the technical administration of Power BI, including publishing, workspace administration, refresh monitoring, access management, and report distribution, in accordance with established requirements.
• Coordinates escalated requests and application rollouts, including technical activities, testing, communications, training, documentation, and post-implementation support.
• Develops user guides, technical documentation, procedures, presentations, training, and knowledge-transfer materials.
• Recommends and implements improvements to applications, support processes, procedures, documentation, reporting solutions, and technology adoption.
• Distributes work among technicians and ensures its completion; at management’s request, reviews completed work and provides feedback; and participates in technicians’ training and technical development.
• Provides technical advice and supports users, colleagues, and other technicians in resolving complex issues while maintaining effective relationships with departments, vendors, and partners.
• Performs other related duties consistent with the class of employment.

Qualifications

Hold a Diploma of College Studies in Computer Science Technology or in Computer Science Technology in an appropriate specialty for the class of employment, or a diploma or attestation of studies recognized as equivalent by the competent authority, and have four (4) years of pertinent experience.

Other Requirements

The incumbent must demonstrate:

• Experience supporting complex corporate, administrative, or enterprise applications.
• Strong knowledge of SQL, relational databases, data transformation, data validation, and technical troubleshooting.
• Experience developing, maintaining, and optimizing Power BI reports, dashboards, data models, and visualizations.
• Ability to analyze complex technical and operational requirements, evaluate options, and recommend practical solutions.
• Ability to work independently with a wide range of latitude, manage competing priorities, and meet deadlines.
• Strong analytical, organizational, problem-solving, customer-service, and interpersonal skills.
• Ability to explain technical concepts and findings clearly and to prepare specifications, procedures, documentation, training materials, reports, and support solutions for varied audiences.
• Ability to work collaboratively with cross-functional teams and stakeholders and a commitment to continuous learning.
• Strong oral and written communication skills in English and French.

Assets

• Experience in a school board, educational organization, or comparable public-sector environment.
• Knowledge of GPI, Jade, Tosca, Mozaïk, Fusion, single sign-on solutions, or comparable enterprise applications.
• Experience with Power BI Service administration, application implementations, integrations, quality assurance, testing, and organizational change.
• Experience using multiple data sources and preparing technical training, user documentation, and knowledge-transfer materials.