1

Splunk Power User Jobs in Toronto, ON (NOW HIRING)

... user experience. Being a part of our Team means you'll join a culture of creativity, curiosity, and ... We believe in the power of working together, you'll get to work with your peers, business partners ...

Splunk Power User information

What is a Splunk Power User?

Splunk Power Users are individuals who have advanced knowledge and skills in using Splunk for searching, analyzing, and visualizing machine data. They are proficient in creating complex searches, dashboards, alerts, and reports, and often help organizations derive insights from large volumes of data. Power Users typically have access to more features than standard users, such as creating knowledge objects and managing data models, but less access than Splunk administrators. They play a crucial role in maximizing the value of Splunk within an organization by building efficient queries and sharing actionable insights with teams.

What are the key skills and qualifications needed to thrive as a Splunk Power User, and why are they important?

To thrive as a Splunk Power User, you need a solid understanding of data analysis, search processing language (SPL), and system monitoring, typically supported by experience with IT operations or cybersecurity. Familiarity with the Splunk platform, dashboards, reports, and ideally a Splunk Power User certification are important technical assets. Strong problem-solving, attention to detail, and effective communication skills help users interpret data insights and collaborate with technical teams. These skills and qualities enable efficient use of Splunk for identifying issues, optimizing performance, and supporting organizational security and compliance.

How does a Splunk Power User typically collaborate with IT and security teams within an organization?

A Splunk Power User frequently acts as a bridge between raw data and actionable insights for both IT and security teams. They work closely with team members to create meaningful dashboards, alerts, and reports tailored to each department's needs. This role often involves translating technical requirements into Splunk searches and visualizations, facilitating faster troubleshooting and incident response. Regular collaboration ensures that data sources are properly onboarded and that the organization leverages Splunk's full potential for monitoring, compliance, and security.

What is the difference between Splunk Power User vs Splunk Administrator?

AspectSplunk Power UserSplunk Administrator
CredentialsBasic Splunk certifications, familiarity with Splunk queriesAdvanced certifications, deeper knowledge of Splunk architecture
Work EnvironmentEnd-users, analysts, and reporting rolesSystem management, deployment, and maintenance
Industry UsageData analysis, troubleshooting, and reportingSystem setup, configuration, and health monitoring

Splunk Power Users focus on analyzing data and creating reports using Splunk, while Splunk Administrators handle system setup, configuration, and maintenance. Both roles require familiarity with Splunk but differ in technical depth and responsibilities.

What are popular job titles related to Splunk Power User jobs in Toronto, ON?

For Splunk Power User jobs in Toronto, ON, the most frequently searched job titles are:

What job categories do people searching Splunk Power User jobs in Toronto, ON look for?

The top searched job categories for Splunk Power User jobs in Toronto, ON are:

Infographic showing various Splunk Power User job openings in Toronto, ON as of August 2026, with employment types broken down into 87% Full Time, 9% Part Time, 3% Contract, and 1% Nights. Highlights an 89% Physical, 5% Hybrid, and 6% Remote job distribution.

SYSTEMS INTEGRATOR 1 (Data Warehouse System Admin)

City of Toronto

Toronto, ON

CA$50.41 - CA$55.24/hr

Full-time

Re-posted 9 days ago


Job description

Job ID: 63864
Job Category: Information & Technology
Division & Section: Public Health, Operation and Business
Work Location: Union Station- 61 Front Street West, Toronto, M5J 1E6
Job Type & Duration: Full-time, Permanent Vacancy
Hourly Rate and Wage Grade: $50.41 - $55.24
Shift Information: Monday to Friday, 35 hours per week, 7 hours per day
Affiliation: L79 Full-time
Number of Positions Open: 1
Posting Period: 18-AUG-2026 to 08-SEP-2026


Job Description:
Reporting to the Senior Systems Integrator, Business Intelligence (BI) & Data Services, Systems Integrator 1 (Data Warehouse System Admin) will provide expertise and advice related to the Data warehouse (DW) environment sustainment / configuration and support along with maintaining implemented data extracts- transform-load (ETL) solutions and Databases for Toronto Public Health information technology systems and solutions. This Systems Integrator 1 (Data Warehouse Admin) takes initiative and is able to lead the planning, documenting and ongoing support activities of various software systems, with an emphasis on: Data Warehouse (DW) applications sustainment & process review, software deployment and administration, creation & execution of automation scripts and test plans, implementing software version (patches) update, reviewing and updating  DW procedures, and recommending changes to improve service delivery. Additionally, this DW admin must have excellent communication and interpersonal skills to effectively work with various business counterparts, TPH IT, and Corporate IT partners. All activities performed must adhere to established TPH and City of Toronto (CoT) policies and procedures.

Major Responsibilities:

  • Plans, support & implement Oracle Enterprise Data warehouse (EDW) related applications; Oracle Analytics Server (OAS), Oracle Business Intelligence Enterprise Edition (OBIEE); Map viewer, Oracle Web Logic server; Oracle Data Integrator (ODI), and data integrations via Extract-Transform-Load (ETL) environment for all stages (Development, Test / UAT, Production).
  • Manages / sustains / updates Oracle repository (RPD) to create, customize and maintain the End User Layers (Presentation Layer, Physical layer, Business Model & Mapping Layer), creates / updates business subject areas and folders, and defines analytical facilities (semantic layer) for end users, control & maintain the user access.
  • Analyzes and develops standard and ad-hoc usages logs reports using Oracle tools (OBIEE, OAS, ODI), upload it to SPLUNK, other repositories.
  • Evaluates the performance, systems log, installs and configures multi-tiered Oracle Application Server (OAS), Oracle Business Intelligence (OBIEE) and Oracle data integrator (ODI) environment on Linux platform.
  • Identifies systems related risks and prepares action plans to mitigate.
  • Liaises and co-ordinates with internal & external groups / vendors on accomplishment of tasks / deliverables.
  • Prepares and presents status report of DW environments and explanation for variances, issues, projects or work packages.
  • Prepares findings & "Lessons Learned" from post-implementation reviews, trouble shootings and root-cause analysis
  • Assesses, analyzes, evaluates and recommends process & policy alternatives for BI & DW projects & work packages.
  • Understands DW Logical Data Models and Design documents for proposed solutions that leverage existing DW Start Schema model and provide inputs
  • Updates / maintains Data Warehouse databases / data models using Data modelling tool.
  • Ensures data integrity and validation rules in ETLs, maintenance and sustainment.
  • Recommends improvements to current methodology, process, standards, and policies.
  • Assists staff in development/ implementation for OBIEE/ OAS, ODI and repository (RPD) using MUD (multi-user development) environment.
  • Liaise with staff in development of test strategy, test cases & test scripts for system performance, usability and acceptance testing of system solutions developed.
  • Leads team to draft implementation & rollout strategies and plans.
  • Conducts walk-through of deliverables to identify potential problems.
  • Prepares training material and documentation for use by end users and staff.
  • Collaborates with clients on "Go/No Go" cut-over decisions, e.g., rollouts.

Key Qualifications:
Your application must describe your qualifications as they relate to:

  1. University degree in computer science or the approved equivalent combination of education and experience.
  2. Considerable experience in OAS / OAC, OBIEE, Power BI, Tableau & ODI Administration, Performance monitoring/tuning, managing Oracle WebLogic, troubleshooting Load Balancer / network issues in multi-tier High-availability architecture.
  3. Considerable experience in Oracle RDBMS PL/SQL applications, and shell scripts.
  4. Considerable experience in developing / maintaining reports using Oracle Analytics Server or Oracle Business Intelligence (BI) suites in data warehouse environments.
  5. Considerable experience with Oracle database (OLTP and OLAP) and Oracle Data Integrator (ODI) ETL tool in administration and development capacity. 
  6. Considerable experience in BI Administration Tool (RPD)and OBIEE security setup including LDAP (e-Directory, AD) integration.

You must also have:

  • Technical knowledge of Oracle BI, Oracle Analytics Server (OAS / OAC), ODI and J2EE/WebLogic applications and in security components.
  • Ability to install, configure and administer the Oracle Fusion Middleware (OFM) i.e. OAS, OBIEE, ODI in enterprise environment on UNIX/Linux server operating systems.
  • Ability to work with Oracle 19c sustainment, implementation and integration with single sign-on authentication mechanisms including MSAD, LDAP, e-Directory, Oracle Internet Directory.
  • Ability to perform logical and physical application server designs, develop and implement procedures that support, maintain and enhance the Oracle Analytics Server (OAS), OBIEE & ODI environment
  • Ability to develop and implement procedures that enable proactive problem detection and avoidance, including disaster recovery planning and implementation.
  • Ability to work effectively with a group of multidisciplinary staff in a project team setting.
  • Ability to effectively communicate both orally and in writing.
  • Strong analytical and problem-solving skills, listening and interacting skills are essential.
  • Strong customer service orientation.
  • Ability to work with competing demands prioritizing and meeting deadlines.

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.