Application Analyst - Oracle Finance/SCM Analytics

This position will enable the success of Mayo Clinic’s strategic investment in administrative systems including Oracle and UKG’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 Data Intelligence Platform (FDI). Success in this role will require the ability to lead and 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 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), and UKG 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 end-to-end 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 end-to-end 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 large-sized projects and manages complexities within an integrated environment. Contributes to end-to-end R&A process testing activities. May be required to provide 24/7 on-call support.

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.

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 and UKG 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