Job Information
City of Toronto SYSTEM DEVELOPMENT SPECIALIST (SAP BUSINESS INTELLIGENCE LEAD) in Toronto, Ontario
SYSTEM DEVELOPMENT SPECIALIST (SAP BUSINESS INTELLIGENCE LEAD)
Job ID: 54080
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, Temporary, 12 months Vacancy
Hourly Rate: $51.19 - $56.07
Shift Information: Monday to Friday, 35 hours per week
Affiliation: L79 Full-time
Number of Positions Open: 1
Posting Period: 11-04-2025 to 25-04-2025
Job Summary:
In this role you will be assigned to the Enterprise BI Services (EBIS) team, provide expert Business Intelligence functional and technical consulting, implementation and sustainment services to support City Business Intelligence initiatives. You will work on business process reviews, functional and technical consultation building various analytics solutions and assessments with City Reporting & BI strategic direction.
Job Functions:
Performs analysis, design, programming, testing, documentation and deployment preparation.
Conducts needs analysis, user interviews, and prepares detailed system designs including workflow diagrams.
Conducts user interviews to determine detailed systems requirements.
Completes preliminary analysis, system and functional design, workflow diagrams for quality systems development.
Designs, codes, tests, implements and maintains enterprise systems, ensuring compliance with access and privacy legislation.
Designs and develops systems that comply with access and privacy legislation.
Coordinates and develops program specifications and documentation.
Designs and conducts all levels of testing i.e. unit, system, integration, regression, performance, security, usability, optimization/configuration and coordinates user acceptance testing.
Liaises and coordinates with internal and external consultants in detailed systems deliverables and technical problem resolution.
Implements enterprise in-house developed/custom/packaged systems and systems changes.
Tests integrated systems to ensure system compatibility and proper functional integration.
Provides application maintenance and enhancement including implementation of vendor systems fixes and patches.
Conducts quality assurance on departmental and external developments.
Develops systems interfaces, performs data conversions, and supports users through technical assistance, troubleshooting and training.
Provides documentation and instruction/training to users of the system.
Designs and develops application security interfaces to enable clients in controlling and administering access to their systems.
Provides expertise, advice and technical skills for information and application service delivery.
Provides technical expertise, conducts research and evaluations of hardware/software/framework solutions and makes recommendations.
Recommends, presents and demonstrates system solutions to City management and corporate business clients.
Conducts presentations, participates in enterprise projects, system demonstrations and system walk-throughs at project review meetings.
Participates as a team member in the execution of project plans providing technical expertise and advice re: architecture, development tools, work effort estimates.
Directs the activities of staff, mentors, and recommends training.
Contributes to project charters, statements of work and project plans, project status reports and variance explanations, risk identification and mitigation planning.
Conducts research, investigates and recommends best practices for information and application services.
Contributes to post-implementation project reviews.
Recommends improvements to current methodologies, processes, standards, policies and guidelines.
Contributes in planning of future system growth and provides detailed work plans.
Participates in enterprise projects.
Conducts feasibility studies, business cases, RFI/P/Q's, technical reports by researching and participating in evaluations and recommending solutions.
Determines user training needs.
Key Qualifications:
Post-secondary education in Computer Science, Information Technology, or a related discipline, combined with experience supporting large-scale information technology systems. An equivalent combination of education and/or experience will also be considered.
Considerable experience with SAC, including designing and developing advanced analytics dashboards, planning models, and stories. Proven ability to work with stakeholders to gather and translate business requirements into actionable data visualizations and performance insights (e.g., financial, operational, risk, and KPIs).
Experience integrating data from multiple sources (cloud and on-premise), using tools such as SAP Datasphere, SAP BW, S/4HANA, HANA views, and other third-party data sources. Knowledge of live and import data connections, data modeling, blending, and preparation in SAC.
Experience with SAP BusinessObjects BI Suite (BI 4.x), including Web Intelligence (Webi), Crystal Reports, and integration with Microsoft Office tools. Familiarity with transitioning or harmonizing legacy reporting solutions into SAC is an asset.
Considerable experience in building and optimizing BEx queries, including integrating them with SAC and BO reports. Understanding of SAP BW architecture and data flows is preferred.
You must also have:
Knowledge of various on premise and cloud connections for data exchange (e.g., OData services, Salesforce, Google, SQL Databases, etc.) is an asset.
Strong 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.
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.
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 toemployment equity (https://jobs.toronto.ca/jobsatcity/content/Hiring-Policies-and-Statements/?locale=en_US) .
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’sHiring Policies and Accommodation Process (https://jobs.toronto.ca/jobsatcity/content/Hiring-Policies-and-Statements/?locale=en_US) .