Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Reporting to the Senior Systems Integrator, Business Intelligence (BI) & Data Services, this role provides expertise and advice related to Data Warehouse (DW) environment sustainment, configuration, and support. The position involves maintaining implemented data extracts-transform-load (ETL) solutions and Databases for Toronto Public Health IT systems. The Systems Integrator 1 (Data Warehouse Admin) leads planning, documentation, and ongoing support activities for various software systems, focusing on DW applications, software deployment, automation scripting, version updates, and procedure improvements to enhance service delivery. Excellent communication and interpersonal skills are essential for collaborating with business counterparts and IT partners, adhering to all TPH and City of Toronto policies.

Responsibilities

Plans, supports, and implements Oracle Enterprise Data Warehouse (EDW) related applications including Oracle Analytics Server (OAS), Oracle Business Intelligence Enterprise Edition (OBIEE), Map viewer, Oracle Web Logic server, and Oracle Data Integrator (ODI).
Manages and sustains Oracle repository (RPD) to create, customize, and maintain End User Layers, creates/updates business subject areas and folders, defines analytical facilities, and controls user access.
Analyzes and develops standard and ad-hoc usage logs reports using Oracle tools (OBIEE, OAS, ODI) and uploads them to SPLUNK or other repositories.
Evaluates performance, systems logs, and installs/configures multi-tiered Oracle Application Server (OAS), Oracle Business Intelligence (OBIEE), and Oracle Data Integrator (ODI) environments on Linux.
Identifies systems-related risks and prepares mitigation action plans.
Liaises and coordinates with internal and external groups/vendors for task accomplishment.
Prepares and presents status reports of DW environments, explaining variances, issues, projects, or work packages.
Prepares findings and 'Lessons Learned' from post-implementation reviews, troubleshooting, and root-cause analysis.
Assesses, analyzes, evaluates, and recommends process and policy alternatives for BI & DW projects.
Understands DW Logical Data Models and Design documents for proposed solutions, providing input.
Updates and maintains Data Warehouse databases/data models using a data modeling tool.
Ensures data integrity and validation rules in ETLs, maintenance, and sustainment.
Recommends improvements to current methodology, processes, standards, and policies.
Assists staff in development/implementation for OBIEE/OAS, ODI, and repository (RPD) using the multi-user development (MUD) environment.
Liaises with staff in the development of test strategy, test cases, and test scripts for system performance, usability, and acceptance testing.
Leads teams to draft implementation and rollout strategies and plans.
Conducts walk-throughs of deliverables to identify potential problems.
Prepares training material and documentation for end users and staff.
Collaborates with clients on 'Go/No Go' cut-over decisions for rollouts.

Requirements

University degree in computer science or an approved equivalent combination of education and experience.
Considerable experience in OAS / OAC, OBIEE, Power BI, Tableau & ODI Administration, Performance monitoring/tuning, managing Oracle WebLogic, and troubleshooting Load Balancer/network issues in multi-tier High-availability architecture.
Considerable experience in Oracle RDBMS PL/SQL applications and shell scripts.
Considerable experience in developing/maintaining reports using Oracle Analytics Server or Oracle Business Intelligence (BI) suites in data warehouse environments.
Considerable experience with Oracle database (OLTP and OLAP) and Oracle Data Integrator (ODI) ETL tool in administration and development capacity.
Considerable experience in BI Administration Tool (RPD) and OBIEE security setup including LDAP (e-Directory, AD) integration.
Technical knowledge of Oracle BI, Oracle Analytics Server (OAS / OAC), ODI, and J2EE/WebLogic applications and security components.
Ability to install, configure, and administer Oracle Fusion Middleware (OFM) i.e. OAS, OBIEE, ODI in an 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.

Skills

Data Warehouse (DW) environment sustainment
Data Warehouse (DW) configuration
Data Warehouse (DW) support
Data extracts-transform-load (ETL) solutions
Databases
Oracle Enterprise Data warehouse (EDW)
Oracle Analytics Server (OAS)
Oracle Business Intelligence Enterprise Edition (OBIEE)
Map viewer
Oracle Web Logic server
Oracle Data Integrator (ODI)
Oracle repository (RPD)
End User Layers (Presentation Layer, Physical layer, Business Model & Mapping Layer)
Business subject areas and folders
Analytical facilities (semantic layer)
User access control
Usage logs reports
SPLUNK
Performance evaluation
Systems log analysis
Multi-tiered Oracle Application Server (OAS) installation and configuration
Multi-tiered Oracle Business Intelligence (OBIEE) installation and configuration
Multi-tiered Oracle Data Integrator (ODI) installation and configuration
Linux platform administration
Risk identification and mitigation
Status reporting
Lessons Learned documentation
Root-cause analysis
Process and policy recommendation
Data modeling
Data integrity
Validation rules
Methodology improvement
Process improvement
Standards improvement
Policy improvement
Multi-user development (MUD) environment
Test strategy development
Test case development
Test script development
System performance testing
Usability testing
Acceptance testing
Implementation strategies
Rollout strategies
Deliverable walk-throughs
Training material preparation
Documentation preparation
Cut-over decision collaboration
Oracle RDBMS PL/SQL
Shell scripts
Power BI
Tableau
Oracle WebLogic administration
Load Balancer troubleshooting
Network troubleshooting
High-availability architecture
Oracle database administration (OLTP and OLAP)
BI Administration Tool (RPD)
OBIEE security setup
LDAP integration (e-Directory, AD)
J2EE
UNIX server administration
Oracle 19c sustainment
Single sign-on authentication mechanisms
MSAD integration
e-Directory integration
Oracle Internet Directory integration
Logical application server design
Physical application server design
Proactive problem detection
Proactive problem avoidance
Disaster recovery planning
Disaster recovery implementation
Multidisciplinary team collaboration
Written communication
Oral communication
Analytical skills
Problem-solving skills
Listening skills
Interacting skills
Customer service orientation
Prioritization
Deadline management

Location

Union Station- 61 Front Street West, Toronto, M5J 1E6

Work Type

Full-time
Permanent

Experience Level

Considerable experience

Education Level

University degree in computer science or the approved equivalent combination of education and experience

Salary/Compensations

$50.41 - $55.24

About the Company

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve.
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).

Equal Opportunity

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve.
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.