Corporate Application Technical Leader (BW/Datasphere Lead)

Position Details

• Job Category: Information & Technology
• Division & Section: Technology Services, Enterprise Services & Operations
• Work Location: Metro Hall, 55 John St, Toronto, M5V 3C6
• Job Type & Duration: Full-time, Permanent Vacancy
• Shift Information: Monday to Friday, 35 hours per week
• Affiliation: L79 Full-time
• Posting Period: 28-Aug-2026 to 11-Sep-2026

Job Description

As a Corporate Application Technical Leader (BW/Datasphere Lead), you will provide expertise and advice in initiation, analysis, design, development, implementation and sustainment of SAP enterprise Datawarehouse analytical solutions. This resource will contribute to developing corporate system architecture, methodologies, standards, procedures, and guidelines aligned with Enterprise BW/Datasphere modernization program.

Major Responsibilities

• Directs business and technical inter-divisional staff and professional services to deliver and sustain complex, critical enterprise business applications and information through the application life cycle and reports progress to manager, stakeholders and team members and ensures successful delivery of solutions adhering to project management methodology.
• Directs the day-to-day work output of staff and resources including the scheduling, assigning, and reviewing of work tasks to ensure a continuing and consistent service by sustaining complex, critical enterprise business applications and information.
• Negotiates amongst divisional business and technical stakeholders with multiple points of view to drive consensus for corporate-wide solution designs.
• Brings together multiple stakeholders from across all divisions and provides expert advice within the context of corporate architectures, standards, policies, procedures, and emerging technologies.
• Determines project requirements, analyzes, and recommends feasible options, designs, builds and/or codes, acquires, tests, and implements enterprise information structures and applications, and sustains information technology solutions to meet critical City-wide and divisional business objectives and to provide scalable enterprise solutions.
• Applies technical expertise to recommend, develop and maintain corporate policies, procedures and standards that are consistent with legislation to ensure enterprise information and applications integrity.
• Applies technical expertise to ensure security, privacy and quality assurance requirements are implemented in a manner that delivers business requirements and is consistent with MFIPPA and legislation, thereby ensuring the integrity of complex enterprise information and applications.
• Applies project management expertise to lead and/or input to project management and procurement processes including the evaluation and recommendation of complex technical solutions and professional services.
• On a project basis, provides direction and assigns work to non-I&T positions e.g. divisional unit staff (management & bargaining-unit).
• Applies technical expertise to develop and/or input to procurement and project management documentation. Examples include business cases, RFI/P/Qs, Sole Sources, statements of work, service level agreements, project charters, project plans, status reports, issue logs, change orders, resource plans, budgets, migration plans, contingency plans, and risk assessments.
• Communicates effectively e.g. leading and facilitating meetings, preparing, and delivering presentations and reports. Audiences include business/project managers, project team members and other orders of government and external parties.
• Develops and/or applies complex business and application models, information structures, data models, data schemas, technical program code, network and security interfaces, data and application design as governed by architectural frameworks, technology standards, information policies and legislative requirements.
• Applies a strong understanding of information and technology industry and City priorities over both the short and longer term to advise, develop and maintain City infrastructures, methodologies, tools, and techniques; ensures conformance and adherence in daily practice among business and technical teams.
• Actively participates in corporate and cross-divisional initiatives to design, construct and implement business and application infrastructure solutions, such as data warehousing, document management and electronic service delivery.
• Analyzes and recommends changes to current business practices, business and information processes, data flows, performance measures, information delivery and knowledge utilization toward a more efficiently managed and coherently integrated information environment for all divisions in the city.
• Generates the plan and directs the project team in the execution of software upgrade activities.
• Applies technical expertise to perform analysis, development and testing for new or enhancements to existing complex, critical enterprise business applications and information.
• Applies technical expertise to support the development and testing environments of complex computing solutions.

Key Qualifications

Your application for the role of Corporate Application Technical Leader (BW/Datasphere Lead) should describe your qualifications as they relate to:

• Post-secondary education in Computer Science, Information Technology, Engineering, or a related discipline, or the approved equivalent combination of education and/or experience supporting and sustaining large-scale enterprise data and analytics platforms.
• Experience working with SAP Datasphere environments, including enterprise data warehousing, dimensional and analytical data modeling, complex SQL scripting, stored procedures, table functions, performance optimization, and data provisions.
• Experience integrating SAP and non-SAP data into SAP Datasphere using tools and frameworks such as: SDI, SDA, ODP framework, SLT, APIs and ETL/ELT processes, including data replication and...