SENIOR ENTERPRISE SOLUTIONS TECHNICAL LEAD (BI & Data Lead)

• Job ID: 51159
• Job Category: Information & Technology
• Division & Section: Technology Services, Technology Services Delivery
• Work Location: Union Station, 61 Front Street West, Toronto, ON
• Job Type & Duration: Full-time, Permanent 
• Salary: $122,305.00-$163,639.00
• Shift Information: Monday to Friday, 35 hours per week per week 
• Affiliation: Non-Union
• Number of Positions Open: 1
• Posting Period: 27-Nov-2024 to 11-Dec-2024

The City of Toronto is the fourth largest city in North America and the fourth largest government in Canada, with a highly diverse and multicultural population. In addition, the City of Toronto has several agencies and corporations including the Toronto Police Service, Toronto Public Library, and the Toronto Transit Commission, which make up the broader municipal organization.

Consistently ranked one of the world’s most livable cities, Toronto is home to more than 2.9 million people whose diversity and experiences make this great city Canada’s leading economic engine and one of the world’s most diverse and livable cities.

Toronto is a global leader in technology, finance, film, music, culture, and innovation, and consistently places at the top of international rankings due to investments championed by its government, residents, and businesses.

In its pursuit of modernizing City services through strategic investment, digital transformation, and a culture of innovation, the Technology Services Division collaborates with all City Divisions, agencies, boards, and corporations to deliver client-centric business solutions and secure, reliable IT infrastructure.

Embarking on a transformative journey, the Technology Services Division is reshaping its culture and service delivery approach, focusing on four key priorities:

• Build Resilient Foundations: Establish a robust, reliable, and secure technology infrastructure.
• Deliver User-Centric Solutions: Provide enterprise-grade modern solutions with a focus on user experience.
• Harness Data Power: Utilize data to drive operational processes and informed decision-making Citywide.
• Empower Stakeholders: Engage and empower stakeholders to foster a culture of agility and innovation.

As The Senior Enterprise Solutions Technical Lead (BI & Data Lead), you will report to the Business Intelligence Services Manager within the Technology Services Division. In this role, you will provide specialized technical and business consulting services to address project and operational needs, including Business Process Reviews, Data Architecture Design and Review, Technical Architecture Review, and Technical Assessments, all in alignment with the City’s Data and BI strategic direction.

The Senior Enterprise Solutions Technical Lead (BI & Data) is responsible for leading a team of skilled BI and Data professionals who support services in data warehousing (cloud/on-prem), data management and integration, and reporting and analytics. This position requires close collaboration with Project Managers, Technical Solutions Services Managers, technical team members, and other SAP and non-SAP stakeholders.

A key focus of this role is to implement the Enterprise BI vision by fostering strong partnerships and utilizing effective communication and problem-solving skills to provide technical leadership in BI & Data Management, aligned with the organization’s strategic BI & Data goals.

Specifically, you will provide leadership in the areas of:

Major Responsibilities:

• Manages, motivates, and trains unit staff to ensure effective teamwork, high-quality work, continuous learning, and innovation.
• Oversees BI & Data Services delivery within Business Intelligence Services.
• Supervises daily operations of assigned staff, including work scheduling and review, vacation and overtime authorization, performance evaluations, and salary adjustments.
• Develops and administers the unit's annual budget, ensuring expenditures remain within approved limits.
• Leads the design and implementation of foundational BI enterprise solutions, providing technical leadership in BI & Data Management development.
• Defines and delivers long-term strategic goals for BI enterprise solution implementation, collaborating with business users, divisional managers, clients, and stakeholders.
• Develops and implements critical BI enterprise solution components and information.
• Conducts ongoing research to update BI enterprise solutions based on organizational needs.
• Ensures solutions, data strategies, and architectures comply with regulatory standards.
• Oversees technical design and implementation for City of Toronto corporate enterprise solution environments.
• Designs BI enterprise solution architecture to meet current and future organizational needs.
• Assesses existing architecture and develops future enterprise solution designs.
• Creates tactical solutions to achieve long-term goals and overall roadmap.
• Promotes enterprise solution methodologies and standards.
• Addresses solution-related issues, including integration and multi-platform compatibility.
• Identifies opportunities for solution reuse, migration, and retirement.
• Leads governance and data management across the organization, including data quality, integration, modeling, governance, and warehousing.
• Establishes and enforces mechanisms for compliance with technology and information governance policies.
• Collaborates with Business, Data Analytics team and other stakeholders on business processes, data sourcing, data quality, and data migration strategies.
• Leads data migration design, development, and testing to meet business needs and adhere to agile, SDLC, and SAP best practices.
• Ensures adherence to solution and data quality management standards.
• Sets methods for measuring and improving solution and data quality.
• Oversees data mapping, movement, interfaces, and analytics, ensuring data quality.
• Conducts solution and data capacity planning, life cycle assessments, and feasibility studies.
• Develops strategies for solution administration, backup, disaster recovery, business continuity, and archiving.
• Defines backup, archival, and disaster recovery strategies for enterprise solutions.
• Ensures integrity of the enterprise solution environment in collaboration with business and technical partners.
• Selects and implements appropriate tools, software, and systems to support solution goals.
• Defines standardized methods for enterprise solution projects.
• Collaborates with project managers and business unit leaders on enterprise solution projects.
• Directs technical project teams to ensure consistency across projects.
• Manages vendor relationships to select products and services aligned with organizational goals.
• Provides leadership in preparing formal contractual documents, including Requests for Proposals, Statements of Work, RFRs, and RFQs.
• Designs scalable, sustainable BI & Data solutions aligned with business objectives and industry best practices.

Key Qualifications:

Your application for the role of Senior Enterprise Solutions Technical Lead (BI & Data Lead) should describe your qualifications as they relate to:

1. Considerable experience in a BI & Data Management leadership and supervisory position that has implemented large-scale BI and Data enterprise implementations, covering the entire solution lifecycle.
2. Considerable experience in BI & Data Management development and sustainment, including data modelling, data quality, data integration (ETL), data migration, data virtualization, master data management, metadata management, data governance, data warehousing and analytics.
3. Considerable experience with SAP such as SAP Business Warehouse (cloud/on-prem), SAP Business Intelligence platform, SAP Data Services, SAP Analytics Cloud and SAP Fiori.
4. Considerable experience influencing and leading BI end-to-end architecture and roadmaps, gap analysis and documenting the proposed solutions (for ex: data design, platform, data flow, configurations, and setup)
5. Experience with Analytics tools like Tableau or Power BI at enterprise level.
6. Considerable experience managing staff resources, contractors and vendors and conducting vendor management, performance and service level agreements.
7. Post-secondary education in Computer Science or a related discipline with experience in large-scale information technology systems or the approved equivalent combination of education and experience in the Data Management field.
8. Strong ability to motivate teams and create a collaborative working environment.
9. Highly developed leadership, interpersonal, conflict resolution, negotiation, facilitation and problem-solving skills, with the ability to work collaboratively in a multidisciplinary team environment and independently as required.
10. Strong written and oral communication skills, including presenting and composing written documents to senior IT and business stakeholders.

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.