Senior HCM Analytics & BI Developer

Relha LLC; Northern (KY); Hybrid; USD 105,000 - 231,000; Full time

Job summary

CACI is seeking a Senior HCM Analytics & BI Developer to support a large-scale federal HCM modernization effort. You will design, develop, and maintain enterprise analytics, dashboards, and reporting delivering real-time workforce insights to government leadership and HR stakeholders.

The role is primarily remote with up to 10% travel within the Continental US. Requires extensive BI experience, Oracle OTBI/BIP, and strong knowledge of HR analytics and accessibility standards.

Qualifications

• Bachelor's degree required; 10+ years of relevant experience preferred.
• 10+ years in BI development, analytics, or enterprise reporting.
• 8+ years with Oracle OTBI, BIP or comparable BI tools (Tableau, Power BI, SAP BO).
• Proficiency in SQL with analytical queries on large HR/HCM data models.
• Experience creating interactive dashboards with drill-downs and dynamic visuals.
• Knowledge of HR/workforce analytics metrics and reporting.
• Experience with 508/WCAG-compliant visualizations and reports.
• Familiarity with Agile/SAFe methods.
• 11+ years BI development with Oracle Fusion HCM analytics preferred.
• Oracle Analytics Cloud or BI Publisher certification.
• Experience with federal HR analytics (EHRI, GHRR, HCAAF, DEIA, FEVS).
• Experience with Oracle Fusion HCM data model and OTBI subject areas.
• Experience with predictive analytics (Python, R, OAC ML).
• Experience with HCM Extract for bulk data transfers.

Responsibilities

• Develop OTBI analyses and dashboards delivering real-time workforce metrics.
• Build BIP reports/templates supporting EHRI submissions and HR reporting.
• Create OAC dashboards offering predictive analytics and cross-agency comparisons.
• Configure HCM Extracts for data extraction and data warehouse feeds.
• Produce org chart visualizations and workforce exploration tools.
• Build ad hoc and self-service reporting capabilities for agency HR teams.
• Develop DEIA, MD-715, FEVS, and accountability reporting.
• Ensure accessibility compliance across analytics products.
• Design semantic layers for consistent HR metric definitions.
• Collaborate with teams to translate requirements into specs.
• Support onboarding with reporting templates, data migration, and training.

Skills

Public Trust eligibility

Agile/SAFe

Data analytics

Interactive dashboards

SQL proficiency

HR analytics knowledge

Education

Bachelor's degree

Tools

Oracle OTBI

Oracle BI (BIP)

Tableau

Power BI

SAP BO

Oracle Analytics Cloud

BI Publisher

Job description

Job Title: Senior 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 10%

Type of Travel: Continental US

The Opportunity:

CACI is seeking a Senior HCM Analytics & BI Developer to support a large-scale federal HCM modernization initiative deploying Oracle Fusion Cloud HCM across multiple federal agencies. The role is responsible for designing, developing, and maintaining enterprise analytics, dashboards, and reporting solutions that provide government leadership and HR stakeholders with real-time workforce insights, compliance reporting, and predictive analytics.

This position is primarily remote with up to 10% travel.

Responsibilities:

• Develop OTBI analyses and dashboards delivering real-time workforce metrics (headcount, vacancy rates, time-to-hire, turnover, demographic trends).
• Build BIP reports/templates supporting EHRI submissions, GHRR compliance, SF-113 statistics, and agency-specific HR reporting.
• Create OAC dashboards offering predictive analytics, trend analysis, and cross-agency workforce comparisons.
• Configure HCM Extracts enabling bulk data extraction for analytics pipelines, data warehouse feeds, and external system integrations.
• Produce org chart visualizations and workforce exploration tools for navigating organizational hierarchy and position structures.
• Build ad hoc and self-service reporting capabilities empowering agency HR teams to develop custom insights.
• Develop DEIA, MD-715, FEVS, and accountability framework compliance reporting.
• Ensure Section 508/WCAG 2.1 AA accessibility across all analytics products.
• Design governed OTBI/OAC semantic layers supporting consistent definitions of key HR metrics.
• Collaborate with functional teams and government partners to translate human capital analytics requirements into technical specifications.
• Support agency onboarding with tailored reporting templates, historical data migration, and analytics training delivery.
• Serve as the technical authority for the domain, establishing best practices, standards, and technical oversight.
• Mentor cross-functional team members, drive innovation, and influence program-level solution decisions.

Qualifications:

Required:

• Ability to obtain/maintain Public Trust clearance (U.S. Citizenship required).
• Bachelor's degree and 10+ years of relevant experience (additional experience may substitute for degree).
• 10+ years in BI development, analytics, or enterprise reporting.
• 8+ years of experience with Oracle OTBI, BIP, or comparable BI tools (Tableau, Power BI, SAP BO).
• Proficiency in SQL, including analytical queries on large-scale HR/HCM data models.
• Experience creating interactive dashboards with drill-down, parameters, and dynamic visualizations.
• Knowledge of HR/workforce analytics (headcount, attrition, time-to-fill, span of control, workforce planning).
• Experience developing Section 508/WCAG-compliant visualizations and reports.
• Familiarity with Agile/SAFe methods.
• 11+ years BI development with Oracle Fusion HCM analytics preferred.
• Oracle Analytics Cloud or BI Publisher certification.
• Experience with federal HR analytics (EHRI, GHRR, HCAAF, DEIA, FEVS).
• Experience with Oracle Fusion HCM data model and OTBI subject areas.
• Experience with predictive analytics (Python, R, OAC ML).
• Experience with HCM Extract for bulk data transfer.
• Experience with Oracle Cloud technologies (OIC, OCI) in HCM/ERP environments.
• This position is contingent on funding and may not be filled immediately. However, this position is representative of positions within CACI that are consistently available. Individuals who apply may also be considered for other positions at CACI.

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 customers 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.

$105,100-$231,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.