CORPORATE APPLICATION TECHNICAL LEADER (BUSINESS INTELLIGENCE SPECIALIST: POWER BI - TABLEAU)
- Job ID: 64981
- Job Category: Information & Technology
- Division & Section: Technology Services, Enterprise Services & Operations
- Work Location: Metro Hall, 55 John St, Toronto, ON
- Job Type & Duration: 1 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: 09-Jun-2026 to 23-Jun-2026
Job Summary:
To lead project teams and provide senior technical consulting and analysis, development, testing, quality assurance and project planning expertise to deliver and sustain critical enterprise business applications and information.
Job Functions:
- 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 for Data Visualization Specialist:
- Extensive experience integrating data from multiple sources, including relational databases, cloud platforms, and third-party APIs, ensuring seamless and scalable data connectivity across BI tools (e.g., Power BI, Tableau).
- Extensive experience building interactive dashboards, reports, and visual analytics solutions using Power BI / Tableau.
- Experience developing optimized data models and semantic layers, including calculations and queries (e.g., DAX, Tableau calculations, LOD expressions) to support efficient, accurate, and high-performance reporting.
- Strong experience with Power BI, Tableau, and/or Microsoft Fabric, including gathering business requirements and translating them into data-driven insights across performance, financials, risk, and other KPIs.
- Demonstrated knowledge of secure data practices, including data protection in transit and at rest, implementation of role-based access controls, encryption, and data masking within BI and data platforms.
- Proven ability to troubleshoot and resolve data modeling, performance, and visualization issues across BI tools to ensure optimal usability, responsiveness, and data accuracy.
- Understanding of BI platform governance and deployment models, including Power BI/Fabric and Tableau environments, with knowledge of licensing models considered an asset.
You must also have:
- Understanding of data warehousing concepts and familiarity with tools like Azure Data Factory, Synapse, or SSIS is a plus.
- Knowledge of various on premise and cloud connections for data exchange (e.g. OData services, Salesforce, Google, SQL Databases, etc.) is an asset.
- Solid grasp of ETL processes, data cleansing, and performance optimization for large datasets.
- 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.
- 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 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.