ERP APPLICATION SPECIALIST (Power BI Expert)

City of Toronto; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

The City of Toronto is seeking a skilled ERP Application Specialist with expertise in Power BI. This permanent, full-time role involves supervising the implementation and maintenance of Enterprise Applications, ensuring data integrity and performance optimization. The ideal candidate will have substantial experience in data analysis and visualization, with a commitment to inclusiveness and diversity within the workplace.

Qualifications

• Experience with Power BI and Microsoft Fabric required.
• Strong understanding of data warehousing concepts.
• Knowledge of data security practices is essential.

Responsibilities

• Implements detailed plans and oversees Enterprise Applications.
• Analyzes performance indicators to ensure operational effectiveness.
• Supervises staff and evaluates performance.

Skills

Power BI

Data Analysis

Data Visualization

Problem-Solving

Communication

Education

Post-secondary education in computer science

Tools

Microsoft Power BI

Microsoft Fabric

SAP Analytics Cloud

Tableau

Azure Data Factory

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert: Create Alert

ERP APPLICATION SPECIALIST (Power BI Expert)

Job ID: 55785

Job Category: Information & Technology

Division & Section: Technology Services, Enterprise Services & Operations

Job Type & Duration:Permanent, Full-time

Shift Information: Monday to Friday, 35 hours per week

Affiliation: Non-Union

Number of Positions Open: 1

Posting Period: 23-Jun-2025 to 08-Jul-2025

Major Responsibilities:

• Implements detailed plans and recommends policies/procedures regarding program specific requirements.
• Supervises, motivates and trains assigned staff, ensuring effective teamwork, high standards of work quality and organizational performance, continuous learning and encourages innovation in others.
• Supervises the day to day operation of all assigned staff including the scheduling, assigning and reviewing of work. Authorizes and coordinates vacation and overtime requests. Monitors and evaluates staff performance, approves salary increments, hears grievances and recommends disciplinary action when necessary.
• Provides input into and administers assigned budget, ensuring that expenditures are controlled and maintained within approved budget limitations.
• Contributes to the planning and implementing of upgrades, new releases, new functionality and deployment of Enterprise Applications Systems to new business units.
• Prepares documentation detailing the processes followed in the Enterprise Applications Systems and assists in the establishment of policies and procedures for these processes.
• Monitors and administers Business Cases, Requests for Proposal (RFP), Requests for Quotation (RFQ), and Requests for Information (RFI).
• Provides suggestions and advice to management on emerging technology trends and guidance on various Enterprise Applications Systems technology roadmaps.
• Assists other areas of the City including Agencies, Boards and Commissions in their implementation of Enterprise Applications Systems Solutions.
• Participates in the planning and developing of short and long term work packages.
• Participates in annual internal and external audit.
• Analyzes the performance indicators and standards for the section to measure operational effectiveness, customer satisfaction and to establish employee objectives. Monitors customer service feedback as appropriate.
• Provides analysis and input into the work estimates, status reports as required for sponsors, managers and/or senior management team.
• Provides support to implement Enterprise Applications in City's divisions and include projects that affect the entire City operation as well as specific Agencies, Boards and Commissions as required through new implementations or upgrades.
• Ensures corporate standards are maintained in the Enterprise Applications Systems.
• Develops and maintains professional relationships with division personnel by providing advice and guidance on the use of the Enterprise Applications Systems.
• Provides support in finding solutions to issues/barriers identified in the operations of the Enterprise Applications Systems.
• Participates on project teams that require technical expertise and leadership in areas involving Enterprise Applications Systems.
• Provides support in the unit's operations related to Enterprise Applications Systems maintenance.
• Provides support and advises to Divisions, City Agencies, Boards and Commissions on various issues related to Enterprise Applications Systems.
• Ensures integrity and security of City's confidential data, records, reports and sensitive information in accordance with corporate policy and SAP standards.
• Analyzes the business needs and identifies best practices by analysis, validation and documentation of the business and system requirements.
• Organizes and assists in workshop creation to formalize designs, modifies and creates business processes that will be used to implement the business transformation solutions.
• Participates in IT initiatives by following the systems development life cycle (SDLC) approach and successfully manages all the phases of initiation, planning, requirements gathering, design, development, testing, implementation and maintenance of the Enterprise applications.

Key Qualifications:

Your application for the role of Power BI Specialist should describe your qualifications as they relate to:

• Post-secondary education in computer science, or the approved equivalent combination of education and/or experience.
• Considerable experience with Power BI and Microsoft Fabric, identifying and gathering business requirements to build a data-driven analysis of performance, financials, risk & other KPls.
• Extensive experience in integrating data from multiple sources, including databases, cloud services, and third-party APIs, to ensure seamless data connectivity.
• Considerable experience in troubleshooting and resolving data modeling and visualization issues to ensure optimal performance and data accuracy.
• Experience in developing optimized data models, DAX calculations, and queries for efficient and reliable reporting.
• Microsoft PowerBI related certification is preferred
• Demonstrated knowledge in implementing secure data practices, including data security in transit and at rest through robust storage solutions, access controls, encryption, and data masking techniques.
• Knowledge of Microsoft Power BI or Fabric licensing model is an asset.
• Experience in other analytics tools like SAP Analytics Cloud or Tableau is an asset.
• Understanding of data warehousing concepts and familiarity with tools like Azure Data Factory, Synapse, or SSIS.
• Knowledge of various on premise and cloud connections for data exchange (e.g. OData services, Salesforce, Google, SQL Databases, etc.).
• 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.

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 .