Job Description

• Amendment #1
• 11/28/2023 : "Posting period" has been extended to Dec 08, 2023
• Job ID: 39313
• Job Category: Information & Technology
• Division & Section: Technology Services, Technology Services Delivery
• Work Location: Metro Hall, 55 John St
• Job Type & Duration: 1 Temporary Fulltime (12 month) vacancy
• Hourly Rate and Wage Grade: $53.05 - $58.15
• Shift Information: Monday to Friday, 35 Hours per week
• Affiliation: L79 Full-time
• Number of Positions Open: 1
• Posting Period: 15-NOV-2023 to 08-DEC-2023

In this role, you will be assigned to the Business Intelligence Services (BIS) team to provide support in the areas of BI functional and technical consultation, Implementation of BW on Hana / Native Hana objects and sustainment of existing BI solutions.

Major Responsibilities:

Your primary responsibilities as a Corporate Application Technical Leader (Data Engineer Developer) will be varied. Specifically you will:

• 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 (Data Engineer Developer) should describe your qualifications as they relate to: * Post-secondary education in Computer Science or a related discipline with considerable development/sustainment experience in large-scale IT solutions, or the equivalent combination of education and/or experience.

• Considerable experience in data warehouse / datalake modeling and best practices including experience with Microsoft SQL server and SAP Hana, SQL scripting and SQL coding / testing but not limited to queries, stored procedures, triggers, database objects and indices and proficient in performance tuning.
• Considerable experience in HANA modelling and best practices, creating information models such as procedures, HANA views (graphical and scripted views), all types of joins, rank nodes, calculated columns, decision tables.
• Considerable experience in data integration and data migration that connects various systems, applications and databases using RFC, APIs and other relevant technologies.
• Considerable experience in SAP BW.
• Experience in SAP reporting platform and Tableau.
• Experience in SAP S/4 HANA Embedded Analytics Concept.

You must also have:

• Experience writing solution architecture documentation, using structured systems analysis and design techniques, systems development methodologies and templates, an asset.
• Strong written and oral communication skills, including the ability to present and compose written documents appropriate for clients.
• Strong customer service orientation along with a demonstrated ability to establish and maintain effective stakeholder relationships.
• Excellent problem-solving, leadership, facilitation, presentation and interpersonal skills.
• Ability to work effectively as a team member, collaboratively with others in a multidisciplinary team environment and independently, as required.
• Advanced time management and estimation capabilities and ability to perform several tasks and projects concurrently.
• Ability to develop technology standards, techniques and product specifications.
• Knowledge of current and emerging technologies, and skills to evaluate and recommend new technology for introduction into a complex technical environment.
• Ability to develop project plans, projections and cost/benefit analysis of proposed solutions.
• Ability to develop, maintain and execute both test plans and disaster recovery plans.
• Ability to work flexible hours including days, afternoons, nights and weekends, as required.
• Ability to be on call for support of production systems, as required.
• Ability to travel across various office locations within the City of Toronto, as required.

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 .

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. . Learn more about the City\'s .

City of Toronto