Oracle HCM Analytics & BI Developer

Job Title:

Oracle HCM Analytics & BI Developer

Job Category:
Information Technology

Time Type:
Full time

Minimum Clearance Required to Start:
None

Employee Type:
Regular

Percentage of

Travel Required:

Up to 25%

Type of Travel:
Continental US

CACTI is seeking an HCM Analytics and Business Intelligence Developer to support a large‑scale federal HCM modernization program. The initiative deploys Oracle Fusion Cloud HCM as a unified human capital management platform for federal civilian employees across multiple agencies. In this role you will design, develop, and maintain the analytics and reporting ecosystem that delivers real‑time workforce analytics, compliance reporting, and predictive insights to government leadership, agency HR directors, and federal managers.

You will work across Oracle Transactional Business Intelligence (OTBI), Oracle BI Publisher (BIP), Oracle Analytics Cloud (OAC), and HCM Extract to build executive dashboards, ad‑hoc reporting capabilities, org chart visualizations, and EHRI/GHRR data submissions. All reporting outputs must meet Section 508 accessibility standards and support the diverse analytical needs of the federal HR enterprise. The position is primarily remote with up to 10% travel and is at the T3 level, suitable for a mid‑career technical professional who can independently perform a range of technical and functional tasks.

• Design and develop OTBI analyses and dashboards that provide real‑time workforce metrics across multiple federal agencies, including headcount, vacancy rates, time‑to‑hire, turnover, and workforce demographics.
• Build BIP reports and templates for structured reporting needs such as EHRI submissions, GHRR compliance reports, SF‑113 workforce statistics, and agency‑specific HR reporting requirements.
• Develop OAC dashboards and data visualizations for government executive leadership, delivering predictive analytics, trend analysis, and cross‑agency comparative workforce insights.
• Design and implement HCM Extract configurations for bulk data extraction that support downstream analytics, data warehouse feeds, and external reporting system integrations.
• Create org chart visualizations and interactive workforce exploration tools that enable managers and HR specialists to navigate organizational hierarchies and position structures across the federal enterprise.
• Build ad‑hoc reporting capabilities and self‑service analytics interfaces that empower agency HR teams to create custom analyses without requiring developer support.
• Develop compliance reporting solutions for government‑wide mandates, including EEO/MD‑715, FEVS workforce analysis, DEIA metrics, and human capital accountability frameworks.
• Ensure all reports, dashboards, and analytics outputs comply with Section 508/WCAG 2.1 AA accessibility standards, including screen reader compatibility, keyboard navigation, and alternative text for data visualizations.
• Design data models and semantic layers within OTBI and OAC that provide consistent, governed definitions for key workforce metrics and HR performance indicators.
• Collaborate with functional consultants and government stakeholders to translate human capital analytics requirements into technical report specifications and dashboard wireframes.
• Support agency transitions by configuring agency‑specific reporting templates, migrating historical reporting baselines, and delivering analytics training to agency HR teams.
• Apply established methods, standards, and practices to independently resolve functional and technical issues of moderate scope, contributing to team knowledge bases and consulting with senior staff on complex or unfamiliar problems as they arise.
• Communicate effectively with project team members and direct stakeholders to report progress, explain technical approaches, and support collaborative problem‑solving within assigned work streams and Agile Release Train ceremonies.

• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Statistics, or related field.
• 4+ years of experience in business intelligence development, data analytics, or reporting for enterprise systems.
• 3+ years of hands‑on…