Oracle Reporting Analyst I

PRIMARY PURPOSE:

The Oracle Reporting Analyst position specializes in designing, building, and maintaining data reports and dashboards within Oracle Cloud ERP/HCM. The position serves as a critical bridge between IT and business functions by transforming raw data into actionable insights across financials,and human resources. Responsibilities encompass the use of Oracle Cloud reporting tools including Oracle BI Publisher for Fusion Human Capital Management, OTBI (Oracle Transactional Business Intelligence), Microsoft Power BI, and Fusion Data Intelligence (formerly Fusion Analytics Warehouse).

The Oracle Reporting Analyst is responsible for developing custom reports and optimize existing reports within Oracle Report Writer for the Oracle Cloud ERP system. This role partners with functional and technical stakeholders and subject matter experts to gather reporting requirements and translate them into well-structured, accurate, and timely BI Publisher reports that support business operations, compliance, and decision-making. This role does not own reporting architecture, data models, or enterprise reporting strategy.

ORGANIZATIONAL SUMMARY:
 

The University of South Florida is a top-ranked research university serving approximately 50,000 students from across the globe at campuses in Tampa, St. Petersburg and USF Health. In 2025, U.S. News & World Report recognized USF with its highest overall ranking in university history, as a top 50 public university for the seventh consecutive year and as one of the top 15 best values among all public universities in the nation. U.S. News also ranks the USF Health Morsani College of Medicine in the highest tier, placing it as one of the top 16 medical schools in the nation and inside the top 10 among public universities. USF is a member of the Association of American Universities (AAU), a group that includes only the top 3% of universities in the U.S. With an all-time high of $750 million in research funding in 2025 and as a top 20 public university for producing U.S. patents, USF uses innovation to transform lives and shape a better future. The university generates an annual economic impact of nearly $10 billion for the state of Florida. USF’s Division I athletics teams compete in the American Conference. Learn more at www.usf.edu.

USF is proud to be an innovating partner within the Tampa Bay region, listed by Forbes as the top emerging tech city in the country. 

USF Information Technology (USF IT) provides technology services and support for the University of South Florida. The IT team, led by the Vice President and CIO, provides the following services: Administrative Services, Client Support, Communication Services, Teaching and Learning, Analytics and Reporting, Mobile and Web Services, Consulting Services, Cybersecurity Service and Research Technologies. For more information, please visit: Information Technology | University of South Florida (usf.edu).

ADDITIONAL INFO FOR APPLICANTS: The selected candidate must have current work authorization in the United States. This position is not eligible for Visa Sponsorship.

USF offers GREAT BENEFITS to full-time employees!!

• Medical Insurance
• Dental Insurance
• Vision Insurance
• Paid Vacation Days
• Paid Sick Days
• 11 Paid Holidays
• Various Retirement Options, including 401K employer match
• Tuition Assistance (available for yourself, spouse, partner or dependent)
   

For more information about your total compensation package and other USF benefits, please visit: Work at USF.

PRIMARY JOB DUTIES:

BI Publisher Report Development and Maintenance (55%)

• Design, develop, test, and maintain Oracle BI Publisher reports using SQL data templates, RTF layouts (PDF, Excel, Word, etc.), and bursting definitions
• Design, develop, and maintain reports and dashboards using OTBI, Microsoft Power BI, BI Publisher, and Fusion Data Intelligence
• Modify existing BI Publisher reports to meet changing business or compliance needs
• Use effective formatting, parameters, prompts, and layouts to ensure reports are clear, usable, and consistent
• Validate report output for accuracy, completeness, and alignment with source data
• Ensure reports are delivered on schedule and function as intended in test and production environments

Requirements Gathering and Collaboration (20%)

• Meet with functional stakeholders to understand reporting needs and data requirements
• Translate business requirements into technical BI Publisher specifications
• Clarify data sources, filters, and expected outputs with customers and technical peers
• Collaborate with senior developers, analysts, and functional leads on reporting prioritization

Data Integrity, Access, and Environment Support (15%)

• Support report security, role-based access, and data privacy standards within Oracle environments
• Assist with report migrations, updates, and validations across environments
• Monitor report execution issues and coordinate resolution with technical teams
• Maintain awareness of Oracle HCM data structures relevant to reporting

Documentation and User Support (7%)

• Create and maintain documentation for BI Publisher reports, including purpose, parameters, and data sources
• Respond to basic questions about report access, content, and usage
• Maintain inventory of supported BI Publisher reports

Continuous Learning and Improvement (3%)

• Build proficiency in Oracle BI Publisher features and best practices
• Identify opportunities to improve report usability, performance, or maintainability
• Stay current on Oracle reporting standards and organizational guidelines

MINIMUM QUALIFICATIONS:

Bachelor's degree in Information Technology, Computer Science, Business Analytics, or IT related field and four years of experience in report development or data reporting; OR seven years of experience in report development or data reporting or a combination of relevant experience and education.

Degree Equivalency Clause: Four years of direct experience for a bachelor’s degree.
• Senate Bill 1310- The Florida Senate (https://www.flsenate.gov/Session/Bill/2023/1310) is conditional upon meeting all employment eligibility requirements in the U.S.
• SB 1310: Substitution of Work Experience for Postsecondary Education Requirements
• A public employer may include a postsecondary degree as a baseline requirement only as an alternative to the number of years of direct experience required, not to exceed:
• (a) Two years of direct experience for an associate degree;
• (b) Four years of direct experience for a bachelor’s degree;
• (c) Six years of direct experience for a master’s degree;
• (d) Seven years of direct experience for a professional degree; or
• (e) Nine years of direct experience for a doctoral degree
• Related work experience may not substitute for any required licensure, certification, or registration required for the position of employment as established by the public employer and indicated in the advertised description of the position of employment.
• Minimum Qualifications that require a high school diploma are exempt from SB 1310.

TECHNICAL SKILLS:

Required:

• Oracle Tools: Proficiency in OTBI, BI Publisher, Microsoft Power BI, HCM Extracts, and BICC (BI Cloud Connector).
• Database & Querying: Strong knowledge of SQL and PL/SQL.

Preferred:

• Functional Modules: Deep understanding of data models in Oracle Finance, and/or Human Capital Management (HCM).
• Experience with Oracle Data Integrator (ODI) and Oracle Integration Cloud (OIC).
• Experience in Oracle GenAI, Oracle Cloud Infrastructure (OCI) services for AI, such as OCI Data Science, OCI Vision, and OCI Language and Microsoft Azure.

INDUSTRY KNOWLEDGE:

• 3 to 4 years of experience in Business intelligence concepts and operational reporting.
• Proficiency in data visualization, dashboard creation, and data source integration.
• Data governance principles and organizational data privacy standards.

IT CORE COMPETENCIES:

• Growth Mindset: Takes ownership of personal growth and embraces the concept that intelligence and talent can be developed through continuous learning. Willing to take on new challenges, and views failure as an opportunity to grow.
• Communication: Comfortable using a broad range of communication styles, and chooses appropriate, effective ways to communicate. Adapts communication style depending on the audience and situation. Listens and asks questions to develop a better understanding.
• Collaboration: Collaborates with others in the pursuit of common missions, visions, values and goals. Fosters a sense of community within and across teams, building on mutual respect, trust, and drawing on the strengths of others.
• Client Obsession: Client focused when creating solutions or solving problems, believing that everything we do is to earn and keep our clients’ trust.
• Ownership: Takes responsibility, accountability and proactively focuses on areas they can directly influence. Understands their role within the team and recognizes that they share the team’s successes and failures.
• Outcome Driven: Focuses on desired results, business outcomes, and how to achieve them. Takes appropriate actions to ensure commitments are met and results achieved.

The University of South Florida is a top-ranked research university serving approximately 50,000 students from across the globe at campuses in Tampa, St. Petersburg and USF Health. In 2025, U.S. News & World Report recognized USF with its highest overall ranking in university history, as a top 50 public university for the seventh consecutive year and as one of the top 15 best values among all public universities in the nation. U.S. News also ranks the USF Health Morsani College of Medicine in the highest tier, placing it as one of the top 16 medical schools in the nation and inside the top 10 among public universities. USF is a member of the Association of American Universities (AAU), a group that includes only the top 3% of universities in the U.S. With an all-time high of $750 million in research funding in 2025 and as a top 20 public university for producing U.S. patents, USF uses innovation to transform lives and shape a better future. The university generates an annual economic impact of nearly $10 billion for the state of Florida. USF’s Division I athletics teams compete in the American Conference. Learn more at www.usf.edu.