HCM Analytics & BI Developer

Talantir; United States; Remote; USD 75,000 - 158,000; Full time

Job summary

CACI is seeking an HCM Analytics & BI Developer to support a large-scale federal HCM modernization program. The role focuses on designing and maintaining analytics across OTBI, BIP, OAC, and HCM Extract to deliver real-time workforce insights and compliant reporting.

Primarily remote with up to 10% travel, you will collaborate with government stakeholders to translate requirements into scalable dashboards and data models, ensuring accessibility and governance across the HR analytics ecosystem.

Qualifications

• Bachelor's degree required in a relevant field and 4+ years in BI development, analytics, or reporting for enterprise systems.
• 3+ years hands-on experience with Oracle OTBI, BI Publisher, or equivalent enterprise BI tools.
• Proficiency in SQL for analytical HR/HCM data models; strong dashboard development with drill-downs and filters.

Responsibilities

• Design OTBI analyses and dashboards with real-time workforce metrics across multiple federal agencies.
• Create BIP reports and templates for EHRI/GHRR and SF-113 reporting needs.
• Develop OAC dashboards with predictive analytics and cross-agency insights.
• Configure HCM Extracts for bulk data extraction and downstream data warehouse loads.
• Build org charts and self-service analytics interfaces for HR teams.
• Ensure accessibility and WCAG 2.1AA compliance for all outputs.
• Collaborate with stakeholders to translate requirements into technical specs.

Skills

Oracle OTBI

Oracle BI Publisher

Oracle Analytics Cloud

SQL

Dashboard design

Agile/SAFe

Public Trust clearance

Data visualization

Education

Bachelor's degree in Data Analytics, Information Systems, Computer Science, Statistics, or related field

Tools

OTBI

BIP

OAC

Oracle Fusion HCM data model

Job description

Job ID 322917 Job Title: 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

The Opportunity

CACI is seeking an HCM Analytics and Business Intelligence Developer to support a large-scale federal HCM modernization program. This enterprise-scale initiative will deploy Oracle Fusion Cloud HCM as the unified human capital management platform for federal civilian employees across the government across multiple federal agencies. In this role, you will design, develop, and maintain the analytics and reporting ecosystem that provides government leadership, agency HR directors, and federal managers with real-time workforce analytics, compliance reporting, and predictive insights. 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 Section508 accessibility standards and support the diverse analytical needs of the federal HR enterprise. This is a primarily remote position with up to 10% travel. This position is at the T3 level, suited for a mid-career technical professional who applies solid working knowledge and established methods to independently perform a range of technical and functional tasks, resolving problems of moderate scope and complexity.

Responsibilities

• 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 Section508/WCAG2.1AA 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

Qualifications

Required

• 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, PowerBI, 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 Section508 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

Desired

• 6+ years of BI development experience with specific experience on Oracle Fusion HCM analytics and reporting
• Oracle Analytics Cloud certification or Oracle BI Publisher certification
• Direct experience with federal HR analytics including EHRI reporting, GHRR submissions, or federal human capital accountability reporting
• Experience with Oracle Fusion HCM data model and subject areas within OTBI
• Proficiency with predictive analytics techniques and tools (R, Python, Oracle Analytics machine learning features) applied to workforce analytics use cases
• Knowledge of the Human Capital Framework metrics, FEVS survey analytics, and DEIA workforce reporting requirements
• Experience with Oracle HCM Extract for bulk data extraction and data warehouse loading
• Experience with Oracle Cloud technologies including Oracle Integration Cloud (OIC) and/or Oracle Cloud Infrastructure (OCI) in enterprise HCM or ERP environments

What You Can Expect

A culture of integrity. At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.

An environment of trust. CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth. Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.

Pay Range

There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is: $75,200-$158,100

CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.