Why Mayo Clinic
Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the patient first, we are also dedicated to our employees, investing in competitive compensation and comprehensive benefit plans – to take care of you and your family, now and in the future. And with continuing education and advancement opportunities at every turn, you can build a long, successful career with Mayo Clinic. You’ll thrive in an environment that supports innovation, is committed to ending racism and supporting diversity, equity and inclusion, and provides the resources you need to succeed.
Responsibilities
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 lead, direct 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 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.
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 reporting and analytics (R&A) analysis Leads R&A analysis and support for installed systems as well as R&A implementation and projects that require systems 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 enhanced 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 R&A solutions for end users. Validates R&A solutions 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.
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. Possible infrequent travel to a Mayo Clinic campus may be required.
Qualifications
Bachelor’s degree with minimum of 8 years of relevant experience or Master’s degree with 6 years relevant experience. Relevant experience is considered in administrative areas such as HR, Finance, Supply Chain, Healthcare, or Information Technology. Vendor application certification may be required.
Preferred Experience:
- Deep understanding of Oracle data lineage
- Strong SQL experience for data retrieval and data modeling.
- 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 Fusion Analytics Warehouse (FAW), Oracle Autonomous Data Warehouse (ADW), EPM, Oracle Analytics Cloud (OAC) and / or Oracle Data Integrator (ODI)
Exemption Status
Exempt
Compensation Detail
$108,306 – $157,040 / year
Benefits Eligible
Yes
Schedule
Full Time
Hours/Pay Period
80
Schedule Details
Typically business hours
Weekend Schedule
as needed
International Assignment
No
Site Description
Just as our reputation has spread beyond our Minnesota roots, so have our locations. Today, our employees are located at our three major campuses in Phoenix/Scottsdale, Arizona, Jacksonville, Florida, Rochester, Minnesota, and at Mayo Clinic Health System campuses throughout Midwestern communities, and at our international locations. Each Mayo Clinic location is a special place where our employees thrive in both their work and personal lives. Learn more about what each unique Mayo Clinic campus has to offer, and where your best fit is.
Affirmative Action and Equal Opportunity Employer
As an Affirmative Action and Equal Opportunity Employer Mayo Clinic is committed to creating an inclusive environment that values the diversity of its employees and does not discriminate against any employee or candidate. Women, minorities, veterans, people from the LGBTQ communities and people with disabilities are strongly encouraged to apply to join our teams. Reasonable accommodations to access job openings or to apply for a job are available.
Recruiter
Maggie Kramer