DATA PROCESSING TECHNICIAN PRINCIPAL CLASS

Lester B. Pearson School Board (LBPSB); Dorval; On-site; CAD 75,000 - 110,000; Full time

Job summary

Lester B. Pearson School Board (LBPSB) is seeking a Senior BI Developer to support, develop, integrate, and optimize corporate applications, reporting solutions, and data services.

You will lead the design and implementation of Power BI reports and data models, validate data integrity, and provide technical guidance to IT staff and stakeholders. The role requires strong SQL, data transformation skills, and experience with enterprise applications and SSO platforms.

Qualifications

• Hold a Diploma of College Studies in Computer Science Technology or equivalent and have four years of pertinent experience.

Responsibilities

• Acts as senior technical resource for complex corporate and internally developed applications.
• Investigates, reproduces, documents, and resolves complex application and data issues with users and teams.
• Analyzes requirements and translates them into technical specifications, configurations, reports, and support solutions.
• Designs, develops, maintains, and optimizes Power BI reports, dashboards, and data models.
• Coordinates escalated requests and rollout activities, including documentation and training.
• Develops user guides, procedures, and knowledge-transfer materials.
• Provides technical guidance and training to staff and partners.
• Performs other related duties consistent with employment class.

Skills

Power BI

SQL

Data modeling

Data transformation

Troubleshooting

Education

DEC in CS Tech

Tools

Power BI

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.