Note: The job is a remote job and is open to candidates in USA. Oregon Health & Science University (OHSU) is Oregon's only public academic health center, dedicated to patient care, groundbreaking research, and training future healthcare professionals. They are seeking a Healthcare Business Intelligence (BI) Administrator responsible for the administration, optimization, and operational support of enterprise analytics platforms, focusing on Microsoft Fabric, SAP BusinessObjects, and IBM Cognos Analytics systems.
Responsibilities
- 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
- Maintain system administration documentation, ensuring that new processes are documented or scripted
- Monitor system health, performance, CPU utilization, and storage utilization. Resolve issues for optimal availability and performance
- Assist architects and product owners in the maintenance of system roadmaps for capability enablement and capacity management
- Set up workspaces and apply security configurations as directed by product owners and architecture
- 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
- 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
- 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
- Support deployment pipelines by coordinating with DevOps vendors, architecture, and pipeline owners to ensure continuous deployment capability
- 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
- Work with Microsoft Support vendors to assist in resolving any issues that cannot be resolved internally and to implement new services
- Overall responsibility for administering production and non-production operations for the SAP BusinessObjects platform at OHSU
- Maintain system administration documentation, ensuring that new processes are documented or scripted
- Monitor system health and performance, resolving issues for optimal performance and uptime
- Assist architects in the maintenance of system roadmaps for upgrades and capacity planning
- 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
- Perform system configuration in accordance with vendor and architecture guidelines and maintain documentation of all configuration settings and changes
- 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
- Troubleshoot and advise on user access requests. Submit access requests on behalf of customers on request via the IAM system
- Work with developers and report users to resolve configuration issues as needed. Coordinate with team leadership on incident management, disaster recovery planning, and execution
- Support team-based delegated deployment management by ensuring that the deployment service is operational, performant, and configured optimally. Monitor deployment operations to ensure conformance to system standards
- Monitor user-created schedules to ensure compliance with system standards
- Work with SAP Support for any issues that cannot be resolved internally
- Serve as the backup to the primary Cognos Analytics Administrator
- Act as a subject matter expert to effectively direct user inquiries about access and security groups. Working knowledge of how security is applied to folders, packages, and reports within Cognos
- Perform report and package migrations using Motio tools
- Coordinate with architects, developers, and incident management leads to resolve unplanned system downtimes and performance impacts, and to communicate with stakeholders on the status of the incident
- Assist with scheduling recurring reports when needed
- Work with IBM Support for any issues that cannot be resolved internally
- Other duties as assigned
Skills
- Bachelor's degree in computer science, a related field, or a clinical field and six years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
- Associate's degree in computer science, a related field, or a clinical field and seven years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
- Eight years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
- Equivalent combination of education and experience where one year of experience will be substituted for an Associate's degree and two years of experience will be substituted for a Bachelor's degree
- 2 or more years of paid work experience as a Systems/Application Analyst or Application Administrator
- 2 years administering a Microsoft Fabric Capacity, administering capacity, workspaces, permissions, Spark clusters, and monitoring CPU utilization
- 2 years working with an SAP BusinessObjects environment, including administrative duties
- Knowledge of data warehousing architecture
- Ability to read, write, and maintain SQL Code at an intermediate proficiency level
- Ability to read, write, and maintain PowerShell scripts at an advanced proficiency level
- Knowledge of ETL/ELT processes and pipeline dependency
- Ability to read, write, and maintain Python/PySpark scripts at an intermediate proficiency level
- Microsoft Power BI Data Analyst Associate (PL-300) on hire or within 6 months of hire
- Microsoft Certified: Azure Administrator Associate (AZ-104) within one year of hire
- Microsoft Certified: DevOps Engineer Expert (AZ-400) within one year of hire
- Master's degree in Computer Science
- 2 years administering an SAP BusinessObjects environment
- 2 years administering an IBM Cognos Analytics system
- Experience administering Business Intelligence systems at an academic medical center or healthcare-related organization
- 3 years working with load-balanced, multi-tier, on-premises, and cloud servers
- 3 years SQL Server Experience, including SSIS and T-SQL, coding, performance tuning, and system optimization
- 3 years working in a Windows VM Server environment creating PowerShell scripts, managing file permissions, and monitoring system processes
- Experience with HIPAA and PHI compliance
- Ability to read, write, and maintain SQL Code at an advanced proficiency level
- Ability to read, write, and maintain Python/PySpark scripts at an advanced proficiency level
- Microsoft Certified: Azure Database Administrator Associate (DP-300)
- Microsoft Certified: Fabric Data Engineer Associate (DP-700)
- SAP Certified Technology Associate - SAP BusinessObjects Business Intelligence Platform
- IBM Cognos Analytics Administrator Certification
Benefits
- Healthcare for full-time employees covered 100% and 88% for dependents.
- $50K of term life insurance provided at no cost to the employee.
- Two separate above market pension plans to choose from.
- Vacation - up to 200 hours per year dependent on length of service.
- Sick Leave - up to 96 hours per year.
- 9 paid holidays per year.
- Substantial Tri-Met and C-Tran discounts.
- Employee Assistance Program.
- Childcare service discounts.
- Tuition reimbursement.
- Employee discounts to local and national businesses.
Company Overview