Oracle Application Analyst - ERP/SCM Analytics

This position will enable the success of Mayo Clinics strategic investment in administrative systems including Oracle reporting and analytics (R&A) solutions through / Fusion Data Intelligence Platform (FDI). Success in this role will require the ability to deliver data reporting and analytics via OTBI BI Publisher and FDI following all the analytics project stages: Business Understanding Data Understanding Data Acquisition and Preparation Visualization/Model Development Testing Validation Deployment Maintenance and Retirement.

Key responsibilities include:

• Design build and test data augmentation and reporting solutions in Oracle Analytic tools including processing cleansing and verifying the integrity of data used for analysis in partnership with Information Technology
• Design develop maintain and deliver key Oracle Analytics / FDI 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 / FDI products.

Must have a strong working knowledge of Finance Human Resources Workforce Management and/or Supply Chain processes while providing reporting and analytics (R&A) analysis supporting the software programs or modules across multiple clinical and/or business functions. Understands the endtoend business processes and the impact IT functions can have on the business environment. Leads R&A analysis and support for installed systems as well as R&A implementation and projects that require data reporting and analytics analysis design testing and implementation for specific R&A modules or solutions. Leads transformation efforts to optimize end to end R&A processes to achieve efficiency and enhance end user experience. Informs and advises Product Owners on strategic product direction relevant to Mayo to develop product roadmaps. Proficient knowledge of existing systems and core domain operations and is certified in the vended application as required. Understands the business strategy and configures designs develops or modifies R&A solutions via vendor tools or augmented tools developed within Mayo Clinic and does so within complex integrated systems. Is able to validate data integrity of changes introduced and impact on endtoend R&A solutions for end users. Validates R&A solutions 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. Leads and resolves customer problems with R&A 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 system 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 medium to largesized projects and manages complexities within an integrated environment. Contributes to endtoend R&A process 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 from the U.S.

Bachelors 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. Previous healthcare experience and knowledge of administrative systems preferred. Knowledge and experience with project management systems analysis and design software testing process management or engineering systems documentation preparation and data management and analysis preferred. Must be customerservice oriented timely in responses to requests for service/information able to manage multiple tasks teams and/or priorities and able to work independently.

Preferred Qualifications:

• Deep understanding of Oracle data lineage
• Knowledge of Oracle Cloud Financial (FIN) HR (HCM) System and / or Supply Chain (SCM) modules
• Strong grasp of core data warehouse concept and design paradigms
• Desire & ability to work in a team environment and train on new Oracle technologies including options for Oracle University certifications
• Experience as a data scientist or developer with Oracle Analytics Oracle Autonomous Data Warehouse (ADW) EPM Oracle Analytics Cloud (OAC) and / or Oracle Data Integrator (ODI)