Freelance Oracle Bi Publisher Jobs in Virginia (NOW HIRING)

Job Summary:
RIT Solutions, Inc. is seeking an Oracle Cloud HCM BI, Reporting & Dashboard Analyst responsible for designing, developing, managing, and supporting enterprise reports and dashboards for Oracle Cloud HCM applications. The role involves collaborating with HR and leadership stakeholders to translate business needs into actionable reporting and visual dashboards.
Responsibilities:
• Design, develop, administer, and support HCM reports and dashboards using Oracle BI Publisher (BIP) and OTBI.
• Build interactive OTBI dashboards for HR, Payroll, Talent Acquisition, and executive leadership, including workforce metrics, payroll costing, recruiting pipelines, turnover, and compliance reporting.
• Develop complex SQL queries, data templates, and RTF layouts to support operational, analytical, and regulatory HCM reporting.
• Create role-based dashboards with drilldowns, prompts, KPIs, and visualizations aligned to business needs.
• Develop and manage scheduled, burst, and ad hoc reports ensuring accurate and timely delivery.
• Collaborate with HR, Payroll, and ORC functional analysts to gather and document reporting and dashboard requirements.
• Troubleshoot data accuracy, performance, and visualization issues in reports and dashboards.
• Support testing and validation of reports and dashboards during Oracle quarterly updates and HCM enhancements.
• Ensure all reporting and dashboards comply with university data security, FERPA, HIPAA, and role-based access controls.
• Provide production support through ticketing systems and incident response.
• Serve as a subject matter expert for Oracle Cloud HCM reporting and dashboard best practices.
• Maintain an HCM reporting and dashboard catalog including metrics definitions, data sources, security roles, and stakeholders.
• Identify opportunities to standardize HR dashboards, improve performance, and reduce report duplication.
• Stay current on Oracle HCM analytics enhancements and roadmap updates.
• Participate in university-wide projects involving Oracle Cloud implementations, upgrades, and data initiatives.
• Collaborate with FSO security and leadership teams to ensure accurate and secure data access for reporting.
• Support change management and release planning activities related to reporting.
• Provide documentation and knowledge transfer to ensure continuity and supportability of reporting solutions.
Qualifications:
Required:
• Bachelor's degree required. Additional job-related experience may substitute for the required education on a year-for-year basis.
• Five to seven years of relevant experience in Oracle Cloud reporting development and support, with strong emphasis on BI Publisher.
• Extensive hands-on experience with Oracle BI Publisher (BIP) for enterprise report development and support, including data templates, layouts, parameters, and bursting.
• Strong SQL skills for querying Oracle Cloud Fusion HCM data models, data validation, reconciliation, and troubleshooting.
• Demonstrated experience designing and supporting interactive dashboards using Oracle Transactional Business Intelligence (OTBI).
• Experience designing dashboards with KPIs, prompts, drill-downs, filters, and visualizations in user-friendly, actionable formats.
• Understanding of Oracle Cloud data security, role-based access controls, and compliance requirements.
• Ability to translate functional business requirements into scalable, maintainable, and well-documented reports and dashboards.
• Experience supporting production reports and dashboards, including issue resolution, root cause analysis, and performance optimization.
• Strong documentation and communication skills, with the ability to work effectively with both technical and non-technical stakeholders.
• Proven ability to work collaboratively in complex enterprise environments with multiple stakeholders.
• Proven ability to work collaboratively in complex enterprise environments with multiple functional and technical stakeholders.
Preferred:
• Experience supporting Oracle SaaS applications is strongly preferred.
• Experience in a higher education or public sector environment.
• Familiarity with FERPA, HIPAA, SOC 2, TAC 202, or similar regulatory requirements.
• Experience supporting state or regulatory reporting integrations.
• Familiarity with Oracle EPM integrations.
Company:
Jobdiva Job Portal: https://www1.jobdiva.com/candidates/myjobs/searchjobsdone.jsp?a=xbjdnwgjodtga1y1im2g881fkkeiwd0775lbvq8yqgps8vb2q36w2vj1ga6xxork&compid=-1 Recruitment (contingency search and campus selection). Founded in 2019, the company is headquartered in Arlington, USA, with a team of 201-500 employees. The company is currently Growth Stage.