This position will enable the success of Mayo Clinic’s strategic investment in Oracle’s reporting and analytics (R&A) solutions through building and maintaining key data, reporting and analytics via OTBI, BI Publisher and the Oracle Analytics / Fusion Analytics Warehouse (FAW). Success in this role will require the ability to execute data, reporting and analytical needs through all analytics project stages: Business Understanding, Data Understanding, Data Acquisition and Preparation, Testing, Validation, Visualization/Model Development, Deployment, Maintenance, and Retirement. Key responsibilities include:

• Design, build and test data augmentation and reporting solutions in the Oracle Analytics / Fusion Analytics Warehouse (FAW) including processing, cleansing, and verifying the integrity of data used for analysis, in partnership with Information Technology
• Build data models in Oracle BI Publisher for report development consumption.
• Design, develop, maintain, and deliver key Oracle Analytics / Fusion Analytics Warehouse (FAW) and ERP/HCM (OTBI and BI Publisher) reporting dashboards, analytics, and extracts.
• Schedule and deploy ad hoc and recurring analytics.
• Collaborate with Finance, HR, Supply Chain, and other domains to create reporting functional and technical design documentation (FDDs/TDDs) that accurately document required functionality.
• Engage with Harwick Project implementation partner for onboarding and knowledge transfer.
• Regression test solutions as part of regular upgrade cycle for both Oracle Fusion and Oracle Analytics / Fusion Analytics Warehouse (FAW) products.

Supports reporting and analytics (R&A) solutions across multiple clinical and/or business functions. Understands the business environment and the impact R&A can have on the business environment. Provides analysis and support for R&A solutions as well as system implementation and integration projects that require R&A analysis, design, testing and implementation for specific modules or applications. Optimizes the R&A solutions to achieve efficiency and enhanced end user experience. Maintains knowledge of existing systems and core domain operations and is certified in the vended application, as required. Understands strategic product direction to inform Mayo product roadmaps. Configures, designs, develops, or modifies R&A solutions via vendor tools or augmented tools developed within Mayo Clinic and is able to validate data integrity of changes introduced. Validates R&A changes align with stakeholders’ needs / requirements to ensure completeness, correctness, and clarity. Validates solutions to ensure it satisfies the stated requirements. Provides R&A quality assurance services for projects and systems and ensures regulatory compliance as it applies to R&A support for the business areas served. Resolves customer problems and responds to requested improvements and enhancements. Provides or reviews content for updating FAQs, job aids, and training materials. Research requests to determine scope, size, and impact. Works with customers to elicit requirements through a variety of techniques. Functions as a liaison between clinical, business, and technical areas throughout the lifecycle of the R&A development lifecycle, including transformation efforts. Supports and participates in data governance, reference data management, and/or data standards. Builds credibility and rapport with customers to understand their needs. Manages small- to mid-sized projects. Contributes to R&A testing activities. 

This vacancy is not eligible for sponsorship/ we will not sponsor or transfer visas for this position.

This position is 100% remote; can work from anywhere in the U.S.

Bachelor’s degree with minimum of 4 years of relevant experience. Relevant experience is considered in Administrative areas such as HR, Finance, Supply Chain, Healthcare or Information Technology. In lieu of degree, H.S. Diploma and 8 years of relevant experience may be considered.  Vendor application certification may be required.