CORPORATE APPLICATION TECHNICAL LEADER (BW/Datasphere Lead)

Job ID: 66969

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

Hourly Rate and Wage Grade: $58.30 - $63.91

Shift Information: Monday to Friday, 35 hours per week 

Affiliation: L79 Full-time

Number of Positions Open: 1

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:

1. 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.
2. 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.
3. 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 real-time data access
4. Experience with SAP BW modernization  and migration to SAP Datasphere or cloud analytical platforms, including designing and implementation of security frameworks, role-based access controls, and data governance practices within SAP environments such as Datasphere and BW-HANA.
5. Considerable Experience developing and optimizing CDS views for SAP S/4 HANA Embedded Analytics, including integration of analytical data models into enterprise data platforms to support evolving business reporting and analytics needs.  
6. Considerable experience with BW systems including BW ABAP development, leveraging code-pushdown techniques with AMDP (ABAP Managed Database Procedures), data extraction from SAP/Non-SAP source systems and SAP HANA modeling in Eclipse
7. Extensive experience providing production operational support for enterprise data platforms, such as SAP BW HANA, including monitoring data loads, process chains/task chains, troubleshooting & resolving incidents and performance issues, supporting upgrades/maintenance, and ensuring service delivery aligned with SLA commitments during critical business events (e.g., budget cycles, major releases, production cut-over, hyper-care support).
8. Extensive Experience across one or multiple ERP data domains (Success Factor, Ariba, S4, PBF) and business process data domains (e.g., Finance, HR, Procurement, Financial Planning) to support enterprise reporting and analytics solutions.

You must also have:

• SAP BW/4HANA certification, SAP Business Data Cloud certification is an asset.
• Proficiency with SAP BOBJ Webi, Power BI, SAP Analytics Cloud (SAC), or hybrid enterprise BI ecosystems.
• Strong attention to detail and commitment to quality with high analytical skills.
• Ability to translate business requirements into technical data solutions leveraging BW-HANA & Datasphere capabilities, manage stakeholders.
• Experience using Service management tools such as JIRA, Service Now is an asset.
• Excellent verbal and written English communication skills.
• Ability to work independently and as part of a team when required.
• Knowledge of SAP Business Data Cloud architecture and components.
• Knowledge in skill areas such as SAP BTP Integration suite, SAP Databricks is an asset.
• Knowledge in cloud data platforms like AWS is an asset.

NOTE TO INTERNAL FULL-TIME AND PART-TIME CITY OF TORONTO EMPLOYEES:

City of Toronto employees must apply to full-time or part-time employment opportunities posted on the City's Internal Job Posting Portal.

Equity, Diversity and Inclusion

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity.

Accommodation

The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process.