Design and develop Oracle Transactional Business Intelligence (OTBI) analyses and dashboards providing real-time workforce metrics across multiple federal agencies including headcount, vacancy rates, time-to-hire, turnover, and workforce demographics
Build Oracle BI Publisher (BIP) reports and templates for structured reporting needs including EHRI submissions, GHRR compliance reports, SF-113 workforce statistics, and agency-specific HR reporting requirements
Develop Oracle Analytics Cloud (OAC) dashboards and data visualizations for government executive leadership providing predictive analytics, trend analysis, and cross-agency comparative workforce insights
Design and implement HCM Extract configurations for bulk data extraction supporting 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 (program functional requirements, A9) 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 workstreams and Agile Release Train ceremonies

Requirements

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 experience with Oracle OTBI, Oracle BI Publisher, or equivalent enterprise BI development tools (Tableau, Power BI, SAP BusinessObjects)
Proficiency in SQL with experience writing analytical queries against large-scale HR/HCM data models
Experience designing interactive dashboards with drill-down capabilities, parameterized filters, and dynamic visualizations
Knowledge of HR/workforce analytics metrics including headcount, attrition, time-to-fill, span of control, and workforce planning indicators
Experience developing accessible reports and data visualizations compliant with Section 508 or WCAG standards
Familiarity with Agile/SAFe development methodologies and iterative report development processes
Must be able to obtain and maintain a Public Trust clearance (US Citizenship required)
Additional experience may substitute for degree

Benefits

healthcare
wellness
financial
retirement
family support
continuing education
time off benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Oracle Transactional Business Intelligence (OTBI)Oracle BI Publisher (BIP)Oracle Analytics Cloud (OAC)SQLdata visualizationdata modelingHCM Extract configurationsreporting solutionspredictive analyticstrend analysis

Soft Skills

communicationcollaborationproblem-solvingtrainingindependent resolutionstakeholder engagementteamworkadaptabilityanalytical thinkingproject management

Certifications

Bachelor's degree in Data AnalyticsBachelor's degree in Information SystemsBachelor's degree in Computer ScienceBachelor's degree in StatisticsPublic Trust clearance