Business Intelligence System Administrator (Application Engineer)

Department Overview

The mission of the Information Technology Group (ITG) is to develop, implement, and maintain technology-based services and solutions enabling OHSU to effectively manage information to accomplish its missions.

 

The ideal candidate combines deep platform administration expertise with strong scripting, systems engineering, and database skills to build reliable, high-performance BI environments that support critical healthcare decision-making.

Function/Duties of Position

The Healthcare Business Intelligence (BI) Administrator is responsible for the administration, optimization, and operational support of enterprise analytics platforms supporting clinical, financial, and operational reporting. This role primarily focuses on managing Microsoft Fabric capacities and SAP BusinessObjects environments, with a secondary responsibility for IBM Cognos Analytics systems. This includes the installation, configuration, administration, and maintenance of these systems, which are leveraged in a 24x7, multi-server environment. 

 

Microsoft Fabric Administration

Overall responsibility for administering the centrally managed BIAA Microsoft Fabric capacities.  This work will require close collaboration with other administrators, architects, and stakeholders in analytics and engineering solutions.

• Documentation: Maintain system administration documentation, ensuring that new processes are documented or scripted.
• Performance: Monitor system health, performance, CPU utilization, and storage utilization. Resolve issues for optimal availability and performance.
• Planning: Assist architects and product owners in the maintenance of system roadmaps for capability enablement and capacity management.
• Provisioning: Set up workspaces and apply security configurations as directed by product owners and architecture.
• Configuration: Update system configurations, enabling or disabling features as appropriate and directed. Create and manage Spark pools to meet engineering use case requirements. Ensure that all system changes are documented in our change management system.
• Security: Coordinate with the system architect on the maintenance of security groups, workspaces, data gateway connections, and external partner user access. Maintain documentation in the service management system for all security-related changes.
• Access: Troubleshoot and advise on user access requests.  Act as a subject matter expert on Fabric User Group entitlements. Submit access requests on behalf of customers on request via the IAM system. Support external partners in resolving access requests and issues.
• Deployment: Support deployment pipelines by coordinating with DevOps vendors, architecture, and pipeline owners to ensure continuous deployment capability.
• Incident Management: Work with developers and report users to resolve configuration issues as needed. Coordinate with team leadership on incident management, disaster recovery planning, and execution. Work with the PCAS team leader to communicate planned and unplanned outages.
• Vendor Coordination: Work with Microsoft Support vendors to assist in resolving any issues that cannot be resolved internally and to implement new services.

 

SAP BusinessObjects Administration

Overall responsibility for administering production and non-production operations for the SAP BusinessObjects platform at OHSU.

• Documentation: Maintain system administration documentation, ensuring that new processes are documented or scripted.
• Performance: Monitor system health and performance, resolving issues for optimal performance and uptime.
• Planning: Assist architects in the maintenance of system roadmaps for upgrades and capacity planning.
• Upgrades: Perform installation, upgrades, and patching in a multi-server, multi-tier environment. Cloning environments and content as needed for platform upgrades, as well as upgrades for integrated supported platforms and applications.
• Configuration: Perform system configuration in accordance with vendor and architecture guidelines and maintain documentation of all configuration settings and changes.
• Security: Coordinate with the system architect on the maintenance of security groups, departmental folders, data connections, and security profiles. Maintain documentation in the service management system for all security-related changes.
• Access: Troubleshoot and advise on user access requests. Submit access requests